Excel Shortcuts For Data Set Up
Watch the 15-second video below to see if you can figure out the 5 shortcuts I used to set up the data for easier use This is something you can do easily in 15 seconds any time you get a new data file that begins in A1 with a header row in row 1. (Alternatively, you can also create a Table with Ctrl+T — which will do much of the same, but much more — and maybe some features and formatting you don’t want).
See if you can do it in under 15 seconds.
Scroll down for my solution.
Here are the tasks (starting point is cell D8):
- bold top row
- freeze top row
- add filters
CLICK ON THE GRAPHIC TO BEGIN THE 15-SECOND VIDEO CLIP
Scroll down for solution
↓
↓
↓
↓
↓
↓
↓
↓
↓
↓
↓
Here are the Excel shortcuts – how fast can you do it?
- Ctrl+Home to get to cell A1
- Shift+Space to select the row (row 1)
- Ctrl+B for Bold
- Alt-W-F-R to Freeze Top Row
- Alt-A-T to add filters
Do you have a better solution? Do you prefer Tables?
Leave a Reply