Select Page

Excel Shortcuts – Ctrl combination


Excel shortcut with Control Key. You will be surprised there are so many shortcuts with just Ctrl key.
The below table lists down every possible shortcut key using Just Ctrl key. Will be soon posting Excel shortcuts using Shift, Ctrl+Shift and other shortcuts.

Shortcut key Action
Ctrl+A Selects the entire worksheet.
If the worksheet contains data, Ctrl+A selects the current region. Pressing Ctrl+A a second time selects the entire worksheet.
When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box.
Ctrl+Shift+A inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula.
Ctrl+B Applies or removes bold formatting.
Ctrl+C Copies the selected cells.
Ctrl+D Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.
Ctrl+E Adds more values to the active column by using data surrounding that column.
Ctrl+F Displays the Find and Replace dialog box, with the Find tab selected.
Shift+F5 also displays this tab, while Shift+F4 repeats the last Find action.
Ctrl+Shift+F opens the Format Cells dialog box with the Font tab selected.
Ctrl+G Displays the Go To dialog box. F5 also displays this dialog box.
Ctrl+H Displays the Find and Replace dialog box, with the Replace tab selected.
Ctrl+I Applies or removes italic formatting.
Ctrl+J #
Ctrl+K Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.
Ctrl+L Displays the Create Table dialog box. Ctrl+T also does same.
Ctrl+M #
Ctrl+N Creates a new, blank workbook.
Ctrl+O Displays the Open dialog box to open or find a file.
Ctrl+P Displays the Print tab in Microsoft Office Backstage view.
Ctrl+Q Displays the Quick Analysis options for your data when you have cells that contain that data selected.
Ctrl+R Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.
Ctrl+S Saves the active file with its current file name, location, and file format.
Ctrl+T Displays the Create Table dialog box. Ctrl+L also does same.
Ctrl+U Applies or removes underlining.
Ctrl+V Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell contents.
Ctrl W Closes the selected workbook window.
Ctrl+X Cuts the selected cells.
Ctrl+Y Repeats the last command or action, if possible.
Ctrl+Z Uses the Undo command to reverse the last command or to delete the last entry that you typed.
Ctrl+F1 Displays or hides the ribbon
Ctrl+F2 Displays the print preview area on the Print tab in the Backstage view.
Ctrl+F3 Displays name manager
Ctrl+F4 Close excel
Ctrl+F5 XL, Restore window size
Ctrl+F6 Next workbook window
Ctrl+F7 Performs the Move command on the workbook window when it is not maximized. Use the arrow keys to move the window, and when finished press Enter, or Esc to cancel.
Ctrl+F8 Performs the Size command (on the Control menu for the workbook window) when a workbook is not maximized.
Ctrl+F9 Minimize workbook
Ctrl+F10 Maximizes or restores the selected workbook window
Ctrl+F11 Inset 4.0 Macro sheet
Ctrl+F12 File Open dialog box
Ctrl+1 Format cells dialog box
Ctrl+2 Bold
Ctrl+3 Italic
Ctrl+4 Underline
Ctrl+5 Strikethrough
Ctrl+6 Show/Hide objects
Ctrl+7 Show/Hide Standard toolbar
Ctrl+8 Toggle Outline symbols
Ctrl+9 Hide rows
Ctrl+0 Hide columns
CTRL+/ Select the array containing the active cell.
CTRL+ In a selected row, select the cells that don’t match the formula or static value in the active cell.
CTRL+[ Select all cells directly referenced by formulas in the selection.
CTRL+] Select cells that contain formulas that directly reference the active cell.
Ctrl+: Insert Current Time
Ctrl+; Insert Current Date
Ctrl+” Copy Value from Cell Above
Ctrl++ Insert
Ctrl+- Delete
Ctrl+’ Copy Formula from Cell Above
Ctrl+. #
Ctrl+, #
Ctrl+< #
Ctrl+> #
Ctrl+End Moves to the last cell on a worksheet, to the lowest used row of the rightmost used column. If the cursor is in the formula bar, Ctrl+End moves the cursor to the end of the text
Ctrl+Enter Fills the selected cell range with the current entry
Ctrl+Home Moves to the beginning of a worksheet
Ctrl+Page Down Moves to the next sheet in a workbook
Ctrl+Page Up Moves to the previous sheet in a workbook
Ctrl+Tab Switches to the next tab in dialog box
Ctrl+Spacebar Selects an entire column in a worksheet
Ctrl+Arrow Key  Moves to the edge of the current data region in a worksheet

If you feel I have missed out something, please mention it in comments below.

This blog is owned by CA Adarsh Madrecha. All rights reserved.

About The Author

CA, ISA, CISA, BCAF. Friends call me Techno Savvy Chartered Accountant. I work at EY in System Audit

1 Comment

  1. Nice Post, Thanks for sharing

Archives

Subscribe To my Newsletter

Subscribe To my Newsletter

Join the mailing list to receive the latest news and updates from the blog

You have Successfully Subscribed!