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
Excel Dynamic Arrays Straight to the Point

The new Dynamic Array Functions are just one side-effect of an effort to completely rewrite the Calculation Engine in Excel. Joe McDaid and the rest of the CALC team have the laid the groundwork for all future functions in Excel. Yes, the first crop of SORT, SORTBY, FILTER, UNIQUE, SEQUENCE and RANDARRAY are awesome and powerful, but they are just the first of many new functions that will come to Office 365 over the coming years.