Cell Formatting Trick
Do you constantly find yourself going to the Format menu, Cells choice to make changes in MS Excel? (You know, for things like data format, text direction, borders, fill color, etc.)
Do you hate using the mouse for all this?
Looking for a faster, keyboard-driven method to access the Format Cells window?
Good, then you’re in the right place.
Next time skip the menu and highlight the cells you need to format. (Don’t forget that holding down the Shift key while using directional keys will highlight cells.)
From there, simply use the key combination of Ctrl + 1.
Poof! You’re instantly taken to the window where you’re free to format to your hearts content.