Adarsh Madrecha | May 16, 2017 | 0
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.
|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+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+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+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+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+7||Show/Hide Standard toolbar|
|Ctrl+8||Toggle Outline symbols|
|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+â€™||Copy Formula from Cell Above|
|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.