Home Videos Exercises MCQ Q&A Quiz E-Store Services Blog Sign in Appointment Payment

Excel Shortcut Keys

SOOPRO provides Excel Shortcuts keys.


CTRL + A

Select all contents of a worksheet


CTRL + B

Bold all cells in the highlighted section


CTRL + C

Copy all cells the highlighted section


CTRL + D

Fills Down


CTRL + F

Search current sheet


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

Create a new workbook


CTRL + O

Opens a workbook


CTRL + P

Print the current sheet


CTRL + R

Fill them with the contents of the original cell


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 + SHIFT + :

Enters the current time


Shift + ;

Enters the current date


F1

Open paint help


CTRL + -

Deletes the selected column or row


CTRL + SHIFT +=

Inserts a new column or row


CTRL + SHIFT + ~

Switches between showing Excel formulas or their value


CTRL + SHIFT + @

Applies time formatting


CTRL +SHIFT + !

Applies comma formatting


CTRL +SHIFT +$

Apply currency formatting


CTRL + SHIFT + #

Applies date formatting


CTRL + SHIFT +%

Applies percentage formatting


CTRL + SHIFT + ^

Applies exponential formatting


CTRL + SHIFT + *

Selects the current region around the active cell


CTRL + SHIFT + &

Places border around selected cells


CTRL + SHIFT + _

Removes a border


CTRL ++

Insert


CTRL +-

Delete


CTRL +Spacebar

Selects the entire column


CTRL + SHIFT + Spacebar

Selects theh entire worksheet


CTRL + HOME

Move to cell A1


CTRL + END

Move to last cel on worksheet


CTRL + TAB

Move between two or more excel files


CTRL + SHIFT + TAB

Activates the previous workbook


CTRL + SHIFT +F

Opens the drop-down menu for fonts


CTRL + SHIFT +O

Selects all of the cells that contain comments.


CTRL + SHIFT + P

Opens the drop-down menu for paint size


SHIFT + INSERT

Pastes what is stored on the clipboard


F1

Opens the help menu


F2

Edits the selected cell


F3

After a name has been created, F3 will paste names


F4

Repeats last action


F5

Goes to a specific cell


F6

Move to the next pane


F7

Spell check selected text or document


F8

Enters Extend Mode


F9

Racalculates every workbook


F10

Activates the menu bar


F11

Opens the help menu


F12

Edits the selected cell


SHIFT + F3

Opens the excel formula window


SHIFT + F5

Brings up a search box


SHIFT + F6

Move to previous pane


SHIFT + F8

Add a selection


SHIFT + F9

Performs calculate function on active sheet


CTRL + F3

Open excel name manager


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


CTRL + SHIFT + F6

Moves to the previous worksheet window


CTRL + SHIFT + F12

Prints the current worksheet


Alt + F1

Inserts a chart


Alt + F2

Save as option


Alt + F4

Exits Excel


Alt+ F8

Opens the macro dialog box


Alt + F11

Opens the visual basic editor


Alt + Shift + F1

Creates a new worksheet


Alt + Shift + F2

Saves the current worksheet