Excel Shortcuts Archives

AutoFit Rows and Columns in Excel (4 Ways)

October 26, 2026March 21, 2022 by Ajay Anand

AutoFit resizes columns and rows to fit their contents, so text stops spilling over and #### turns back into numbers. The fastest way: select the sheet with Ctrl + A and double-click any column border. Column shortcutAlt, H, O, I Row shortcutAlt, H, O, A Works inAll Excel versions The data 1. Double-click a border … Read more

12 Lesser-Known Excel Shortcuts

October 26, 2026November 11, 2020 by Ajay Anand

Everyone knows Ctrl + C. These are the shortcuts even regular Excel users often miss, from opening a function's help dialog to jumping back to the active cell after a long selection. Shortcuts12 Works inExcel for Windows VideoIncluded Video Quick list Shortcut What it does Ctrl + L Create a table (same as Ctrl + … Read more