Tuesday's Tip #92: Excel Tricks that even Wowed my college son!
SUPER SIMPLE Time Saving Excel Tricks!
So excited to have my 2 college boys home from college. Even MORE excited when they ask me for help with something I know - EXCEL! I was helping my son with a spreadsheet, and was happy to be able to teach him so TRICKS he didn't know.
These are the kind of Excel tips that are hard to learn - because you don't know you need them. But here they are :)
Trick #1 - Keyboard Shortcuts
Rule of thumb. Let me preface this by saying - use keyboard shortcuts to navigate a set of data anytime you can't see the destination in the same screen. For example if you are in row 1 - you can probably see 30 rows, if you want to navigate to row 40 or higher - a keyboard shortcut will save time. If you can see where you want to go - just click with your mouse.
CTRL + DOWN ARROW -
CTRL + UP ARROW -
CTRL + SHIFT + UP ARROW
CTRL + SHIFT + DOWN ARROW
Trick #2 - Preserve your original sort
When you get an Excel file, often times you sort it to see what you're working with - sometimes though - you realize you need to sort it as it originally came to you for a variety of reasons. If you don't know that sort - or can't tell - you might want to preserve it.
- Add a new column called sort at the end of your data set.
- Type 1,2 in the first 2 rows and select.
- Double click the handle (lower right hand corner) to fill down for all rows.
- Now you can always use this column to sort back to original. This can also save you from having to create a copy of the spreadsheet.
