To see the formulas instead of their results, press Ctrl + {`} or click Formulas → Show Formulas. To show a single formula next to its result, use FORMULATEXT. ShortcutCtrl + ` (the key left of 1) One cellFORMULATEXT Applies toThe active sheet only The data 1. Show Formulas button Formulas → Formula Auditing → … Read more
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
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