MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Shortcuts - Ctrl+1

July 24, 2017 - by Bill Jelen

Excel Shortcuts - Ctrl+1

Excel Keyboard Shortcuts: Ctrl + 1 to format the selection. By far, this was the most popular in our poll of your favorite Excel shortcut.

Ctrl + 1
Ctrl + 1

Ctrl + 1 (the number one) works to format whatever is selected. Whether it is a cell, Smart Art, a picture, a shape, or the March data point in a column chart, press Ctrl + 1.

Thanks to Mitja Bezenšek, Alexa Gardner, Andrej Lapajne, Schmuel Oluwa, Jon Peltier, @ExcelNewss, @JulianExcelTips

Watch Video

Title Photo: qimono / pixabay

Bill Jelen is the author / co-author of
MrExcel LIVe

A book for people who use Excel 40+ hours per week. Illustrated in full color.