Breaking

Excel, Keyboard Shortcuts using CTRL Combination

Shortcut Description
CTRL + A Select all contents of a worksheet.
CTRL + B Bold all cells in the highlighted section.
CTRL + C Copy all cells in the highlighted section.
CTRL + D Fill down.
CTRL + E Adds more values to the active column by using data surrounding that column.
CTRL + F Displays the Find & Replace dialog box, with the Find tab selected.
CTRL + G Go to a certain area.
CTRL + H Find and replace.
CTRL + I Puts italics on all cells in the highlighted section.
CTRL + K Inserts a hyperlink.
CTRL + N Creates a new workbook.
CTRL + O Opens a workbook.
CTRL + P Print the current sheet.
CTRL + R Fill Right.
CTRL + S Saves the open worksheet.
CTRL + U Underlines all cells in the highlighted section.
CTRL + V Pastes everything copied onto the clipboard.
CTRL + W Closes the current workbook.
CTRL + X Cuts all cells within the highlighted section.
CTRL + Y Repeats the last entry.
CTRL + Z Undo the last action.
CTRL + 1 Changes the format of the selected cells.
CTRL + 2 Bolds all cells in the highlighted section.
CTRL + 3 Puts italics all cells in the highlighted section.
CTRL + 4 Underlines all cells in highlighted section.
CTRL + 5 Puts a strikethrough all cells in the highlighted section.
CTRL + 6 Shows or hides objects.
CTRL + 7 Shows or hides the toolbar.
CTRL + 8 Toggles the outline symbols.
CTRL + 9 Hides rows.
CTRL + 0 Hides columns.
Ctrl + ; Enters the current date.
Ctrl + ` Changes between displaying cell values or formulas in the worksheet.
Ctrl + - Deletes the selected column or row.
Ctrl + + Insert.
Ctrl + - Deletes the selected column or row.
Ctrl + / Selects the array containing the active cell.
Ctrl + \ Selects the cells that have a static value or don’t match the formula in the active cell.
Ctrl + [ Selects all cells referenced by formulas in the highlighted section.
Ctrl + ] Selects cells that contain formulas that reference the active cell.
Ctrl + Enter Fills the selected cells with the current entry.
Ctrl + Spacebar Selects the entire column.
Ctrl + Home Move to cell A1.
Ctrl + End Move to last cell on worksheet.
Ctrl + Tab Move between Two or more open Excel files.
Ctrl + F3 Open Excel Name Manager.
Ctrl + F4 Closes current Window.
Ctrl + F5 Restores window size.
Ctrl + F6 Next workbook.
Ctrl + F7 Moves the window.
Ctrl + F8 Resizes the window.
Ctrl + F9 Minimize current window.
Ctrl + F10 Maximize currently selected window.
Ctrl + F11 Inserts a macro sheet.
Ctrl + F12 Opens a file.


No comments:

Post a Comment