Excel shortcuts

19 Excel Keyboard Shortcuts for Formatting Cells & Data

If you work with data in Microsoft Excel, you know how important it is to be able to format that data quickly and efficiently. Fortunately, there are a number of keyboard shortcuts that can help you with this task. In this article, we'll share 19 of the best Excel keyboard shortcuts for formatting cells and data.

1. Ctrl + 1: Open the Format Cells dialog box

2. Ctrl + 2: Bold selected text

3. Ctrl + 3: Italicize selected text

4. Ctrl + 4: Underline selected text

5. Ctrl + 5: Strikethrough selected text

6. Ctrl + 6: Superscript selected text

7. Ctrl + 7: Subscript selected text

8. Ctrl + 8: Apply or remove cell borders

9. Ctrl + 9: Hide selected rows

10. Ctrl + 0: Hide selected columns

11. Ctrl + A: Select all cells in the worksheet

12. Ctrl + B: Bold selected cells

13. Ctrl + I: Italicize selected cells

14. Ctrl + U: Underline selected cells

15. Ctrl + F: Apply or remove cell fill color

16. Ctrl + G: Go to a specific cell

17. Ctrl + H: Replace text in cells

18. Ctrl + K: Insert a hyperlink

19. Ctrl + Z: Undo the last action

These are just a few of the many keyboard shortcuts that can save you time when formatting cells and data in Excel. For a complete list of shortcuts, consult the Excel help documentation or ask your IT department for assistance.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.