Excel 2024: Favorite Keyboard Shortcuts
March 10, 2025 - by Bill Jelen

As I started polling readers about their favorite Excel tips, a large number of them were keyboard shortcuts. Some readers, such as Matt Kellett, Olga Kryuchkova, Mike Dolan Fliss, and @model_citizen, suggested that the book has to include a section on favorite keyboard shortcuts.
These are presented in order of popularity. If a lot of readers suggested a tip, it is at the top. After the first eight or so, they are then sorted by my subjective sequence.
1. Ctrl+1 to Format a Selection

Ctrl+1 (the number one) works to format whatever is selected. Whether it is a cell, SmartArt, 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, and @JulianExcelTips.