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 keyAction
Ctrl+ASelects 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+BApplies or removes bold formatting.
Ctrl+CCopies the selected cells.
Ctrl+DUses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.
Ctrl+EAdds more values to the active column by using data surrounding that column.
Ctrl+FDisplays 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+GDisplays the Go To dialog box. F5 also displays this dialog box.
Ctrl+HDisplays the Find and Replace dialog box, with the Replace tab selected.
Ctrl+IApplies or removes italic formatting.
Ctrl+J#
Ctrl+KDisplays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.
Ctrl+LDisplays the Create Table dialog box. Ctrl+T also does same.
Ctrl+M#
Ctrl+NCreates a new, blank workbook.
Ctrl+ODisplays the Open dialog box to open or find a file.
Ctrl+PDisplays the Print tab in Microsoft Office Backstage view.
Ctrl+QDisplays the Quick Analysis options for your data when you have cells that contain that data selected.
Ctrl+RUses 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+SSaves the active file with its current file name, location, and file format.
Ctrl+TDisplays the Create Table dialog box. Ctrl+L also does same.
Ctrl+UApplies or removes underlining.
Ctrl+VInserts 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 WCloses the selected workbook window.
Ctrl+XCuts the selected cells.
Ctrl+YRepeats the last command or action, if possible.
Ctrl+ZUses the Undo command to reverse the last command or to delete the last entry that you typed.
Ctrl+F1Displays or hides the ribbon
Ctrl+F2Displays the print preview area on the Print tab in the Backstage view.
Ctrl+F3Displays name manager
Ctrl+F4Close excel
Ctrl+F5XL, Restore window size
Ctrl+F6Next workbook window
Ctrl+F7Performs 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+F8Performs the Size command (on the Control menu for the workbook window) when a workbook is not maximized.
Ctrl+F9Minimize workbook
Ctrl+F10Maximizes or restores the selected workbook window
Ctrl+F11Inset 4.0 Macro sheet
Ctrl+F12File Open dialog box
Ctrl+1Format cells dialog box
Ctrl+2Bold
Ctrl+3Italic
Ctrl+4Underline
Ctrl+5Strikethrough
Ctrl+6Show/Hide objects
Ctrl+7Show/Hide Standard toolbar
Ctrl+8Toggle Outline symbols
Ctrl+9Hide rows
Ctrl+0Hide 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+EndMoves 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+EnterFills the selected cell range with the current entry
Ctrl+HomeMoves to the beginning of a worksheet
Ctrl+Page DownMoves to the next sheet in a workbook
Ctrl+Page UpMoves to the previous sheet in a workbook
Ctrl+TabSwitches to the next tab in dialog box
Ctrl+SpacebarSelects 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

Adarsh Madrecha

CA, ISA, BCAF

1 Comment

  1. Anonymous

    Nice Post, Thanks for sharing

    Reply

Leave a reply

Your email address will not be published. Required fields are marked *

Pin It on Pinterest

Share This
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!