Pinterest Pixel

CTRL + 1: Format Cells

John Michaloudis
CTRL + 1: Format Cells.
A keyboard shortcut that I use almost every day is the CTRL + 1 shortcut.
CTRL + 1: Format Cells | MyExcelOnline CTRL + 1: Format Cells | MyExcelOnline

This bring up the Format Cells dialogue box and from in there you can choose to format your Numbers, Dates, Alignment, Font, Border, Fill & Protection.

If you like this Excel tip, please share it
Founder & Chief Inspirational Officer at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  CTRL + SHIFT + ARROWS: Move/Highlight Cells

Steps To Follow

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...