How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Excel Text Upside Down: What Works and What Doesn’tIn Excel for Microsoft 365 on Windows, you cannot rotate text inside a worksheet cell a full 180 degrees using the standard…
- Excel Certifications: The Current Options ExplainedThe main Microsoft Excel certifications are Microsoft Office Specialist (MOS) Excel Associate for Microsoft 365 Apps (exam MO-210) and Excel Expert for…
- Excel Text Underline Shortcut: Windows, Mac, and WebIn Excel for Windows, select the cell or text you want to underline and press Ctrl+U. On a Mac, use Command+U; the…
- Excel You Can’t Paste This Here: Causes and Fixes ExplainedExcel’s “You can’t paste this here” message usually means the destination does not match the copied cells or cannot accept them—for example,…
- Excel This Action Won’t Work on Multiple SelectionsThe Excel message “This action won’t work on multiple selections” usually means the command needs one continuous, rectangular range, but the current…
- Excel Spill Range Is Too Big: Causes and FixesExcel’s “Spill range is too big” message means a dynamic-array formula is trying to return more rows or columns than fit between…
- Excel Sharing Violation: Causes and FixesAn Excel sharing violation usually means Excel cannot save to the workbook because another user, program, or file-system rule is blocking access.…
- Excel Number Stored as Text: Causes and FixesExcel’s “Number stored as text” message is an error-checking warning, not a calculation error: a cell contains digits that Excel is treating…
- Excel Ran Out of Resources: Causes and FixesWhen Excel says it ran out of resources, it could not get enough memory or another system resource to finish the requested…
- Excel Format Cells Shortcut: Open the Dialog in SecondsIn Excel for Windows, select a cell or range and press Ctrl+1 to open the Format Cells dialog box. On a Mac,…
- Word and Excel Keyboard Shortcuts: Essential Keys to KnowFor Microsoft Word and Excel on Windows, the most useful shortcuts to start with are Ctrl+C to copy, Ctrl+V to paste, Ctrl+Z…
- Excel Keyboard Shortcuts to Know for Faster WorkThe most useful Excel keyboard shortcuts are Ctrl+C, Ctrl+V and Ctrl+Z for copying, pasting and undoing; Ctrl+Arrow keys for moving through data;…
- Excel Keyboard Shortcut to Select an Entire Row FastIn Excel for Microsoft 365 on Windows, press Shift+Space to select the entire worksheet row containing the active cell. If the cell…
- Excel Keyboard Shortcuts: Settings and CustomizationExcel for Microsoft 365 on Windows does not provide one settings page where you can remap every built-in keyboard shortcut. You can,…
- Excel Keyboard Shortcuts to Select Cells and RangesIn Excel for Microsoft 365 on Windows, use Ctrl+A to select the current data region, then press it again to select the…
- Excel Keyboard Shortcuts to Select an Entire ColumnIn Excel for Microsoft 365 on Windows, select a cell in the column you want and press Ctrl+Space to select the entire…
- Excel Keyboard Shortcut to Hide a Row (and Unhide It)In Excel for Microsoft 365 on Windows, select a cell in the row—or select the whole row—and press Ctrl+9 to hide it.…
- Excel Keyboard Shortcuts: How to Work Without a MouseYes. In Excel for Microsoft 365 on Windows, you can navigate worksheets, select cells, enter and format data, open commands, and manage…
- Excel Keyboard Shortcuts to Delete a RowIn Excel for Microsoft 365 on Windows, press Shift+Space to select the current row, then press Ctrl+- (Ctrl and the minus key)…
- Excel Keyboard Shortcut to Hide a ColumnIn Excel for Microsoft 365 on Windows, select one or more column headers and press Ctrl+0 to hide those columns. On a…
- Excel Ctrl Shortcuts: Essential Keys ExplainedIn Excel for Microsoft 365 on Windows, Ctrl shortcuts are key combinations that speed up common tasks: press Ctrl+C to copy, Ctrl+V…
- Excel Keyboard Shortcuts: What You Can Customize in ExcelIn Excel for Microsoft 365 on Windows, you cannot directly remap most built-in keyboard shortcuts through an Excel settings screen. You can…
- Excel Keyboard Shortcut to Resize a Column or AutoFitIn Excel for Microsoft 365 on Windows, select a cell in the column and press Alt, H, O, I to AutoFit its…
- Excel Checkmark Keyboard Shortcuts: Windows, Mac, and WebIn Excel for Microsoft 365 on Windows, the quickest keyboard method is to select a cell, choose the Wingdings font, then hold…
- Excel Keyboard Shortcut to Remove Decimal PlacesIn Excel for Microsoft 365 on Windows, select the cells and press Alt+H, 9 to show one fewer decimal place; repeat until…
- Excel Refresh All Shortcut for Windows and MacIn Excel for Microsoft 365 on Windows, press Ctrl+Alt+F5 to refresh all data connections in the workbook. On Mac, use Control+Option+F5 where…
- Excel Keyboard Shortcuts: Options for Every TaskExcel keyboard shortcut options include built-in key combinations, ribbon Key Tips, the Search box, and commands added to the Quick Access Toolbar.…
- Excel Keyboard Shortcut to Reduce Decimal Places in CellsIn Excel for Microsoft 365 for Windows, select the cells and press Alt+H, 9 to reduce the number of decimal places shown.…
- Excel PivotTable Shortcut: Insert One from Your DataIn Excel for Microsoft 365 on Windows, select a cell in your data and press Alt, N, V, T in sequence to…
- Excel Keyboard Shortcut to Jump to the TopIn Excel for Microsoft 365 on Windows, press Ctrl+Home to jump to the beginning of the worksheet, normally cell A1. If you…