Excel shortcuts

20+ Excel Shortcut Keys to Save You Time

If you're like most people, you probably use Microsoft Excel on a daily basis. And if you're like most people, you probably don't know all of the shortcut keys that can save you time. Well, we're here to help! In this article, we'll share with you 20+ Excel shortcut keys that will help you work faster and more efficiently.

Ctrl + N: Create a new workbook

Ctrl + O: Open an existing workbook

Ctrl + S: Save the current workbook

Ctrl + W: Close the current workbook

Ctrl + F: Open the Find dialog box

Ctrl + H: Open the Replace dialog box

Ctrl + G: Open the Go To dialog box

F5: Open the Go To dialog box

Ctrl + P: Open the Print dialog box

Ctrl + Z: Undo the last action

Ctrl + Y: Redo the last action

Ctrl + A: Select the entire worksheet

Ctrl + B: Bold the selected text

Ctrl + I: Italicize the selected text

Ctrl + U: Underline the selected text

Ctrl + 5: Strikethrough the selected text

Ctrl + 1: Open the Format Cells dialog box

Ctrl + 2: Bold the selected text

Ctrl + 3: Italicize the selected text

Ctrl + 4: Underline the selected text

Ctrl + 6: Strikethrough the selected text

Ctrl + 7: Apply or remove the strikethrough format

Ctrl + 8: Apply or remove the outline border

Ctrl + 9: Hide the selected rows

Ctrl + 0: Hide the selected columns

Ctrl + Shift + &: Merge and center the selected cells

Ctrl + Shift + -: Unmerge the selected cells

Ctrl + Shift + *: Select the entire worksheet

Ctrl + Shift + 1: Apply or remove the number format

Ctrl + Shift + 2: Apply or remove the percentage format

Ctrl + Shift + 3: Apply or remove the exponential format

Ctrl + Shift + 4: Apply or remove the currency format

Ctrl + Shift + 5: Apply or remove the date format

Ctrl + Shift + 6: Apply or remove the time format

Ctrl + Shift + 7: Apply or remove the text format

Ctrl + Shift + 8: Apply or remove the cell borders

Ctrl + Shift + 9: Show or hide the row and column headers

Ctrl + Shift + -: Insert or delete a row

Ctrl + Shift + *: Insert or delete a column

Ctrl + Shift + /: Select the entire worksheet

Ctrl + Shift + A: Select the entire column

Ctrl + Shift + B: Select the entire row

Ctrl + Shift + C: Copy the selected cells

Ctrl + Shift + V: Paste the copied cells

Ctrl + Shift + F: Open the Find and Replace dialog box

Ctrl + Shift + G: Open the Go To dialog box

Ctrl + Shift + H: Open the Replace dialog box

Ctrl + Shift + P: Open the Print dialog box

Ctrl + Shift + Z: Undo the last action

Ctrl + Shift + Y: Redo the last action

Ctrl + Shift + : Insert the current date

Ctrl + Shift + ; Insert the current time

Ctrl + Shift + " Insert the current date and time

Ctrl + Shift + +: Insert a new row

Ctrl + Shift + -: Delete the selected row

Ctrl + Shift + *: Insert a new column

Ctrl + Shift + /: Delete the selected column

Ctrl + Shift + ~: Apply or remove the General format

Ctrl + Shift + !: Apply or remove the Number format

Ctrl + Shift + @: Apply or remove the Currency format

Ctrl + Shift + #: Apply or remove the Date format

Ctrl + Shift + $: Apply or remove the Accounting format

Ctrl + Shift + %: Apply or remove the Percentage format

Ctrl + Shift + ^: Apply or remove the Exponential format

Ctrl + Shift + &: Apply or remove the Scientific format

Ctrl + Shift + *: Apply or remove the Text format

Ctrl + Shift + _: Apply or remove the Outline border

Ctrl + Shift + +: Apply or remove the All borders

Ctrl + Shift + |: Apply or remove the Bottom border

Ctrl + Shift + \: Apply or remove the Top border

Ctrl + Shift + ): Apply or remove the Right border

Ctrl + Shift + (: Apply or remove the Left border

Ctrl + Shift + ": Apply or remove the Double bottom border

Ctrl + Shift + #: Apply or remove the Thick bottom border

Ctrl + Shift + $: Apply or remove the Bottom double border

Ctrl + Shift + %: Apply or remove the Bottom thick border

Ctrl + Shift + &: Apply or remove the Top and bottom double border

Ctrl + Shift + ': Apply or remove the Top and bottom thick border

Ctrl + Shift + (: Apply or remove the Top border

Ctrl + Shift + ): Apply or remove the Bottom border

Ctrl + Shift + *: Apply or remove the All borders

Ctrl + Shift + +: Apply or remove the Outside borders

Ctrl + Shift + ,: Apply or remove the Inside borders

Ctrl + Shift + -: Apply or remove the Top and bottom border

Ctrl + Shift + .: Apply or remove the Left and right border

Ctrl + Shift + /: Apply or remove the No border

Ctrl + Shift + 1: Apply or remove the Normal style

Ctrl + Shift + 2: Apply or remove the Row level style

Ctrl + Shift + 3: Apply or remove the Column level style

Ctrl + Shift + 4: Apply or remove the Table style

Ctrl + Shift + 5: Apply or remove the Table style

Ctrl + Shift + 6: Apply or remove the Table style

Ctrl + Shift + 7: Apply or remove the Table style

Ctrl + Shift + 8: Apply or remove the Table style

Ctrl + Shift + 9: Apply or remove the Table style

Ctrl + Shift + 0: Apply or remove the Table style

Ctrl + Shift + !: Apply or remove the Table style

Ctrl + Shift + @: Apply or remove the Table style

Ctrl + Shift + #: Apply or remove the Table style

Ctrl + Shift + $: Apply or remove the Table style

Ctrl + Shift + %: Apply or remove the Table style

Ctrl + Shift + ^: Apply or remove the Table style

Ctrl + Shift + &: Apply or remove the Table style

Ctrl + Shift + *: Apply or remove the Table style

Ctrl + Shift + (: Apply or remove the Table style

Ctrl + Shift + ): Apply or remove the Table style

Ctrl + Shift + -: Apply or remove the Table style

Ctrl + Shift + _: Apply or remove the Table style

Ctrl + Shift + =: Apply or remove the Table style

Ctrl + Shift + +: Apply or remove the Table style

Ctrl + Shift + |: Apply or remove the Table style

Ctrl + Shift + \: Apply or remove the Table style

Ctrl + Shift + ): Apply or remove the Table style

Ctrl + Shift + (: Apply or remove the Table style

Ctrl + Shift + ": Apply or remove the Table style

Ctrl + Shift + #: Apply or remove the Table style

Ctrl + Shift + $: Apply or remove the Table style

Ctrl + Shift + %: Apply or remove the Table style

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.