--- title: Larilyn's Tip of the Week:  Microsoft Excel - Shortcut Keys description: Cell Data to Separate Columns image: https://www.inmotionnet.com/hubfs/mario_kart_8_deluxe.jpg --- [Skip to content](https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-cell-data-to-separate-columns-0-0-0-0#main-content) [Contact us](https://www.inmotionnet.com/contact) ![](https://www.inmotionnet.com/hs-fs/hubfs/InMotionLogoNEW_RGB%20copy.png?width=600&height=350&name=InMotionLogoNEW_RGB%20copy.png) - [Home](https://www.inmotionnet.com/) - [Contact](https://www.inmotionnet.com/contact) - Client Tools Show submenu for Client Tools - [Client Portal](https://na.myconnectwise.net/v4_6_release/services/system_io/CustomerPortal/Portal.html?company=inmotionnets) - [Payment Portal](https://inmtn.connectboosterportal.com/) Open main navigation Close main navigation - [Home](https://www.inmotionnet.com/) - [Contact](https://www.inmotionnet.com/contact) - Client Tools Show submenu for Client Tools - [Client Portal](https://na.myconnectwise.net/v4_6_release/services/system_io/CustomerPortal/Portal.html?company=inmotionnets) - [Payment Portal](https://inmtn.connectboosterportal.com/) - [Contact us](https://www.inmotionnet.com/contact) Apr 15, 2022 4:30:00 AM # Larilyn's Tip of the Week:  Microsoft Excel - Shortcut Keys [Larilyn Holt](https://www.inmotionnet.com/blog/author/larilyn-holt) Share: [facebook-f icon](http://www.facebook.com/share.php?u=https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-cell-data-to-separate-columns-0-0-0-0) [linkedin-in icon](http://www.linkedin.com/shareArticle?mini=true&url=https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-cell-data-to-separate-columns-0-0-0-0) [Twitter icon](https://twitter.com/intent/tweet?url=https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-cell-data-to-separate-columns-0-0-0-0) [pinterest-p icon](http://pinterest.com/pin/create/link/?url=https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-cell-data-to-separate-columns-0-0-0-0) [envelope icon](mailto:?body=https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-cell-data-to-separate-columns-0-0-0-0) Have you guys ever played Mario Kart?  ![mario_kart_8_deluxe](https://www.inmotionnet.com/hs-fs/hubfs/mario_kart_8_deluxe.jpg?width=540&name=mario_kart_8_deluxe.jpg) That is something that my nephews LOOOOVE to play!  And it's actually a video game I'm decently good at.  ![Mario_Kart_Super_Circuit_Award_Ceremony](https://www.inmotionnet.com/hs-fs/hubfs/Mario_Kart_Super_Circuit_Award_Ceremony.webp?width=536&name=Mario_Kart_Super_Circuit_Award_Ceremony.webp) Don't ask me to play most games.  I'm horrible.  When it comes to fighting the level bosses or whatever, I would rather make my little character turn and run the other way.  It's happened before.  My sister can vouch for me.  ![tumblr_l6ob3iJ3IL1qbzf0vo1_500](https://www.inmotionnet.com/hs-fs/hubfs/tumblr_l6ob3iJ3IL1qbzf0vo1_500.webp?width=408&name=tumblr_l6ob3iJ3IL1qbzf0vo1_500.webp) And let's just say she never asked me to play for her while she took a quick shower ever again.  She was lost on the map.  Anyway..... Back to what I'm good at.  MarioKart!  One of the things that I like about it is that as you get to know the tracks, you learn the shortcuts that can take you from the back of the pack to the front of the pack.  Where you have to avoid the pesky blue shells.  But that's beside the point.... ![Mario_Kart_Blue_Shell](https://www.inmotionnet.com/hs-fs/hubfs/Mario_Kart_Blue_Shell.png?width=315&name=Mario_Kart_Blue_Shell.png) And just like in MarioKart, in Excel I truly appreciate a good shortcut!  You guys actually should know this by now.  I believe the subject has been addressed multiple times. Any key combination that allows my hands to stay on my lovely little keyboard and not have to move my hand over to the mouse?  That's my jam. ![fa88d2b1-8b88-42d3-8528-7c2895ebaeef_1.e7952a61778c6bcb55d20776f6f7ea67](https://www.inmotionnet.com/hs-fs/hubfs/fa88d2b1-8b88-42d3-8528-7c2895ebaeef_1.e7952a61778c6bcb55d20776f6f7ea67.jpeg?width=395&name=fa88d2b1-8b88-42d3-8528-7c2895ebaeef_1.e7952a61778c6bcb55d20776f6f7ea67.jpeg) And I'm no selfish Shelly.  I'm here to share a plethora of Excel shortcuts with you today! ![images](https://www.inmotionnet.com/hs-fs/hubfs/images.jpg?width=284&name=images.jpg) I hope these help you in your Excel endeavors.  Enjoy! **Ctrl+;** —Inserts today's date. **Ctrl+Shift+:**—Inserts the current time **Ctrl+Shift+#**—Changes the format of a date (there needs to be a date in the cell already) **Ctrl+5**—Applies a strike-through to the text in a cell. **Ctrl+0**— (that's a zero) Hides the current column. **Ctrl+9**—Hides the current row. **Ctrl+F6**—Switches between open workbooks (like when you switch between open programs in Windows, but in different files of Excel that you have open) **Ctrl+PageUp or PageDown**—Quick shift between the sheets in the currently open workbook. **F2**—Edit the current selected cell  **Shift+F10**—Opens the right-click menu for the cell you're in       [Excel](https://www.inmotionnet.com/blog/tag/excel) ## Related posts [![](https://www.inmotionnet.com/hs-fs/hubfs/1c7e9681-5cd0-4ab3-8b47-f4220f046c0d_text.gif?height=200&name=1c7e9681-5cd0-4ab3-8b47-f4220f046c0d_text.gif)](https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-cell-data-to-separate-columns-0-0-0-0-0) [Excel](https://www.inmotionnet.com/blog/tag/excel) ## [Larilyn's Tip of the Week:  Steps Recorder](https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-cell-data-to-separate-columns-0-0-0-0-0) [Larilyn Holt](https://www.inmotionnet.com/blog/author/larilyn-holt) Apr 28, 2022 4:00:00 AM The time has come to switch gears. After many weeks of Excel tips, we are moving on! I'm taking a... [Read more](https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-cell-data-to-separate-columns-0-0-0-0-0) [Uncategorized](https://www.inmotionnet.com/blog/tag/uncategorized) ## [Larilyn’s Tip of the Week: Consent Phishing](https://www.inmotionnet.com/blog/2021/08/larilyns-tip-of-the-week-consent-phishing) [Larilyn Holt](https://www.inmotionnet.com/blog/author/larilyn-holt) Aug 18, 2021 9:30:00 PM When it comes to technology, there are two things that are certain: [Read more](https://www.inmotionnet.com/blog/2021/08/larilyns-tip-of-the-week-consent-phishing) [Uncategorized](https://www.inmotionnet.com/blog/tag/uncategorized) ## [Larilyn’s Tip of the Week: Windows 10](https://www.inmotionnet.com/blog/2018/01/272) [Larilyn Holt](https://www.inmotionnet.com/blog/author/larilyn-holt) Jan 11, 2018 12:46:36 AM Guys. Let’s get serious for a second. [Read more](https://www.inmotionnet.com/blog/2018/01/272) [![](https://www.inmotionnet.com/hs-fs/hubfs/InMotionLogoNEW_RGB%20copy.png?width=600&height=350&name=InMotionLogoNEW_RGB%20copy.png)](https://inmotionnet.com) 24930 Washington Ave Unit #157 Murrieta, CA  92564 (951) 894-8809 This is a search field with an auto-suggest feature attached. - There are no suggestions because the search field is empty. - [Home](https://www.inmotionnet.com) - [Blog](https://www.inmotionnet.com/blog) - [Contact](https://www.inmotionnet.com/contact) - Client Tools - [Client Portal](https://na.myconnectwise.net/v4_6_release/services/system_io/CustomerPortal/Portal.html?company=inmotionnets) - [Payment Portal](https://inmtn.connectboosterportal.com/) - [Privacy](https://www.inmotionnet.com/privacy-policy) - [Terms](https://www.inmotionnet.com/terms-of-service) --- [linkedin-in icon](https://www.linkedin.com/company/in-motion-networks-corporation/) [Twitter icon](https://twitter.com/InMotionNet/) [facebook-f icon](https://www.facebook.com/inmotionnet/) Copyright © 2026, In Motion Networks Corporation ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Larilyn Holt", "url" : "https://www.inmotionnet.com/blog/author/larilyn-holt" }, "dateModified" : "2022-04-15T11:30:00.376Z", "datePublished" : "2022-04-15T11:30:00.000Z", "headline" : "Larilyn's Tip of the Week:  Microsoft Excel - Shortcut Keys", "image" : [ "https://www.inmotionnet.com/hubfs/mario_kart_8_deluxe.jpg" ], "mainEntityOfPage" : { "@id" : "https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-cell-data-to-separate-columns-0-0-0-0", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://www.inmotionnet.com/hubfs/InMotionLogoNEW_RGB%20copy.png" }, "name" : "In Motion Networks" } } ```