Excel 2024: Favorite Keyboard Shortcuts


March 10, 2025 - by

Excel 2024: Favorite Keyboard Shortcuts

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 plus the number one.
Ctrl plus the number one.

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.

continue reading »

More Reading


Excel 2024: Customize the Quick Access Toolbar

Excel 2024: Customize the Quick Access Toolbar »

March 3, 2025 - by Bill Jelen


Even though the Excel team does not think many features are Home-tab-worthy, you can add your favorite features to the Quick Access Toolbar (QAT).

Excel 2024: Unhide One Specific Column Without Unhiding Others

Excel 2024: Unhide One Specific Column Without Unhiding Others »

February 24, 2025 - by Bill Jelen


You are presenting on a Zoom call. You've hidden columns in your spreadsheet that contain Salary, Manager, and Bonus. You need to unhide the Manager data in E but not unhide the Salary in D or the Bonus in F. Normally, you would select from column D to column G and unhide.

Excel 2024: Generate All Combinations Using BASE Function

Excel 2024: Generate All Combinations Using BASE Function »

February 20, 2025 - by Bill Jelen


I occassionaly have a model where I need to test all possible combinations of several outcomes. For example, lets say that you have four different manufacturing lines and three scenarios that could happen per line.

read more articles »

Featured Products


MrExcel 2022 Boosting Excel

April 2022

The 6th Edition of MrExcel XL, updated with new functions released for Microsoft 365.


Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365)

April 2022

Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful.


Power Query Beyond the User Interface

February 2025

You've already transformed your data (along with your life) by learning Power Query. This book will take that transformation a lot further by teaching you the M language that sits behind Power Query's User Interface.


Microsoft 365 Excel: The Only App That Matters

June 2022

Excel Worksheet, Power Query, Power Pivot, Power BI. Calculations, Analytics, Modeling, Data Analysis and Dashboard Reporting for the New Era of Dynamic Data Driven Decision Making & Insight!


see more products »