How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Excel Paste Values Shortcut: Keys, Options, and FixesIn Excel for Microsoft 365 on Windows, copy the cells, select the destination, then press Ctrl+Alt+V, press V, and press Enter to…
- Excel Fill Color Shortcut: How to Use ItIn Excel for Microsoft 365 on Windows, select the cell or range, then press Alt, H, H in sequence to open the…
- Excel Cut Shortcut: How to Move Cells with Ctrl+XIn Excel for Microsoft 365 on Windows, select the cell or range and press Ctrl+X to cut it; select the destination and…
- Excel Shortcut to Expand All Columns to Fit ContentsIn Excel for Microsoft 365 on Windows, select the whole worksheet and press Alt, H, O, I in sequence to AutoFit the…
- Excel Shortcut to Enter a Cell: F2, Enter, and More ExplainedIf you mean “enter” or edit the contents of the selected cell, press F2 in Excel for Microsoft 365 on Windows; to…
- Excel Shortcut: How to Jump to the End of a ColumnIn Excel for Microsoft 365 on Windows, press Ctrl+Down Arrow to jump to the lower edge of the current block of data…
- Excel Shortcut to the End of Data: Keys and LimitsIn Excel for Microsoft 365 on Windows, press Ctrl+Down Arrow to jump to the edge of the current block of data in…
- Excel Drag Fill: Shortcut Keys and How to Use ThemTo drag-fill in Excel, select a cell, point to the small square at the lower-right corner of its selection, then drag the…
- Excel Shortcut to Edit a Cell: F2 and Other MethodsIn Excel for Microsoft 365 on Windows, select the cell you want to change and press F2 to edit its existing contents.…
- Excel Shortcut Desk Pad: What to Look ForAn Excel shortcut desk pad is a desk mat or reference sheet printed with keyboard shortcuts; it is not a built-in Excel…
- Excel Delete Shortcut: Clear Cells, Rows, and ColumnsIn Excel for Microsoft 365 on Windows, press Delete to clear the contents of selected cells without removing the cells or their…
- Excel Shortcut Desk Mat: What It Is and How to ChooseAn Excel shortcut desk mat is a large mouse-and-keyboard surface printed with keyboard commands for Microsoft Excel. It does not add shortcuts…
- Excel Shortcut Codes: Essential Keys and How They WorkExcel shortcut codes usually means keyboard shortcuts: press a key or combination of keys to run a command without choosing it from…
- Excel Shortcut to Copy the Cell Above Into a CellIn Excel for Microsoft 365 on Windows, select the cell below the one you want to copy, then press Ctrl+D to fill…
- Excel Shortcut to Copy Down: Ctrl+D ExplainedIn Excel for Microsoft 365 on Windows, select the range you want to fill, including the cell at the top that contains…
- Excel Shortcut Cheat Sheet for Windows and MacAn Excel shortcut cheat sheet is a quick reference to keyboard commands for editing cells, moving around worksheets, formatting data, and working…
- Excel Shortcut to Center Text: Windows, Mac, and WebIn Excel for Microsoft 365 on Windows, select the cell or cells and press Alt, H, A, then C to center text…
- Excel Shortcut to Change Sheets in Windows and MacIn Excel for Microsoft 365 on Windows, press Ctrl+Page Down to move to the next worksheet tab, or Ctrl+Page Up to move…
- Excel Bullet Point Shortcut: Windows, Mac, and WebIn Excel for Microsoft 365 on Windows, press Alt+7 on the numeric keypad to type a bullet (•) while editing a cell;…
- Excel Border Shortcut: Apply All or Outline BordersIn Excel for Microsoft 365 on Windows, select the cells and press Ctrl+Shift+& to apply an outline border. To put borders around…
- Excel Shortcut to Go to the Bottom of a Data ColumnIn Excel for Microsoft 365 on Windows, press Ctrl+Down Arrow to jump to the bottom edge of the contiguous block of data…
- Excel AutoSum Shortcut: How to Use Alt+=In Excel for Microsoft 365 on Windows, the AutoSum shortcut is Alt+=: select the blank cell where you want the total, press…
- Excel Shortcut Between Sheets: Windows, Mac, and WebIn Excel for Microsoft 365 on Windows, press Ctrl+Page Up to move to the previous sheet tab, or Ctrl+Page Down to move…
- Excel Alt+H,O,I: AutoFit Column Width Shortcut GuideIn Excel for Microsoft 365 on Windows, Alt, H, O, I runs AutoFit Column Width for the selected column or columns. Press…
- Excel AutoFit Shortcut: Fit Columns and Rows QuicklyIn Excel for Microsoft 365 on Windows, select the column or columns and press Alt, H, O, I in sequence to AutoFit…
- Excel AutoFit Column Width Shortcut and How It WorksIn Excel for Microsoft 365 on Windows, select the column or columns, then press Alt+H, O, I in sequence to AutoFit their…
- Excel All Caps Shortcut: The Fastest Ways to Change CaseExcel has no built-in keyboard shortcut that changes selected text to all caps. To convert text reliably, enter =UPPER(A2) in a helper…
- Excel Stacked Bar Total Labels: Show the Full Sum EasilyTo show a total at the end of each stacked bar in Excel for Microsoft 365 on Windows, calculate the totals in…
- Excel Table Styles: How to Apply and Customize ThemAn Excel table style is a coordinated set of formatting applied to an Excel table, such as a colored header row and…
- Cut, Copy, and Paste in Excel: Shortcuts and StepsTo cut, copy, or paste in Excel for Microsoft 365 on Windows, select the cell or range and press Ctrl+X to cut,…