Skip to content
- Excel Format Painter Shortcut: Keyboard and Ribbon OptionsIn Excel for Microsoft 365 on Windows, use the ribbon key sequence Alt, H, F, P to activate Format Painter; press the…How-to basics
- 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…How-to basics
- 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…How-to basics
- 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…How-to basics
- 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…How-to basics
- 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…How-to basics
- 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…How-to basics
- 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.…How-to basics
- Excel Dollar Sign Shortcut: Fix Cell References in FormulasIn Excel for Microsoft 365 on Windows, press F4 while editing a formula and a cell reference is selected to add or…Errors & fixes
- 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…How-to basics
- 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…How-to basics
- 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…How-to basics
- 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…How-to basics
- 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…How-to basics
- 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…How-to basics
- 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…How-to basics
- 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…How-to basics
- 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…How-to basics
- 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…How-to basics
- 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;…How-to basics
- 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…How-to basics
- 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…How-to basics
- 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…How-to basics
- 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…How-to basics
- 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…How-to basics
- 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…How-to basics
- 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…How-to basics
- 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…How-to basics
- Excel Filter Shortcut: Add, Remove, and Use FiltersIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to add filter dropdowns to a selected data range—or to turn them off…Formulas & functions
- Excel Pivot Tables With Multiple Data Sources: How-ToYes. In Excel for Microsoft 365 on Windows, you can build one PivotTable from multiple tables by adding them to the Data…Charts & pivot tables