Ctrl+1: Format cells in Excel
This week we’ll cover Microsoft Excel tips.
One of the most useful Excel shortcuts is Ctrl+1 (that’s the number one), which brings up the format cell dialog box. Once there, recall you can press Ctrl+Tab to cycle between tabs on the dialog box (Number, Alignment, Font, etc.).
To use the keyboard with the dialog box, you may want to review keyboard navigation of dialog boxes.
on April 9th, 2007 at 11:25 pm
I KNEW there had to be a way to do this more easily!
on August 14th, 2010 at 4:17 pm
Ctrl+1 does not work for me. Am I doing it wrong?