Computer All Shortcut Keys (MS Excel)

Simple Explanation Edu:

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. Fills the Cell Beneath with the Contents of the Selected Cell. To fill more than one Cell, Select the Source cell and Press Ctrl+Shift+Down to Select Multiple Cells. Then Press Ctrl+D fill them with the Contents of the Original Cell.

Ctrl+F:- Search Current Sheet

Ctrl+G:- Go to Certain Area

Ctrl+H:- Find & 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 . Fills the Cell to the Right with the Contents of the Selected Cell. To fill more than one Cell, Select the Source Cell and Press Ctrl+Shift+Right to Select Multiple cells. Then Press Ctrl+R to fill them with the Contents of the Original Cell.

Ctrl+S:- Save the Open Worksheet

Ctrl+U:- Underlines all Cells in the Highlighted Section

Ctrl+V:- Pastes Everything Copies 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

SHORTCUTS KEYS IN THE NUMBERS

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+:(Colon):- Enter the Current Time

Ctrl+; (Semicolon):- Enters the Current Date

Ctrl+` (Back Quote):- Changes Between Displaying Cell Values or Formula in the Worksheet

Ctrl+' (Apostrophe/single Quote sign):- Copies a Formula from the Cell Above

Ctrl+Shift+" (Inverted Commas/Quotation Mark):- Copies Value from Cell Above

Ctrl+- (Minus):- Deletes the Selected Column or Row

Ctrl+Shift+= (Is Equal to):- Inserts a New Column or Row

Ctrl+Shift+~ (Tilde):- Switches Between Showing Excel Formulas or their Values in Cells

Ctrl+Shift+@ (At Sign):- Applies Time Formatting

Ctrl+Shift+! (Exclamation Mark):- Applies Comma Formatting

Ctrl+Shift+$ (Dollar):- Applies Currency Formatting

Ctrl+Shift+# (Hash):- Applies Date Formatting

Ctrl+Shift+% (Percent):- Applies Percentage Formatting

Ctrl+Shift +^ (Caret):- Applies Exponential Formatting

Ctrl+Shift+* (Asterisk):- Select the Current Region Around the Active Cell

Ctrl+Shift+& (Ampersand):- Places Border Around Selected Cells

Ctrl+Shift+_ (UnderScore):- Removes a Border

Ctrl++ (Plus):- Insert

Ctrl+- (Minus):- Delete

Ctrl+Shift+( (Open Parentheses):- Unhide Rows

Ctrl+Shift+) (Close Parentheses):- Unhide Columns

Ctrl+/ (Forward Slash) :- Selects the Array Containing the Active Cell

Ctrl+\ (Backward Slash):- Selected the Cells that have a Static Value or Don't Match the Formula in the Active Cell

Ctrl+[ (Open Bracket/Square Bracket):- Selects all Cells References by Formulas in the Highlighted Section

Ctrl+] (Close Bracket/Square Bracket):- Selects Cells that Contain Formulas that Reference the Active Cell

Ctrl+Shift+{ (Open Curly Braces/Curly Bracket):- Selects all Cells Directly or Indirectly Referenced by Formulas in the Highlighted Section

Ctrl+Shift+} (Close Curly Braces/Curly Bracket):- Selects Cells which Contain Formulas that Directly or Indirectly Reference the Active Cell

Ctrl+Shift+| (Pipe):- Selects the Cells within a Column that Don't Match the Formula or Static Value in the Active Cell

Ctrl+Enter:- Fills the Selected Cells with the Current Entry

Ctrl+Spacebar:- Selects the Entire Column

Ctrl+Shift+Spacebar:- Selects the Entire Worksheet

Ctrl+Home:- Move to Cell A1

Ctrl+End:- Move to Last Cell on Worksheet

Ctrl+Tab:- Move Between Two or More Open Excel File

Ctrl+Shift+Tab:- Activates the Previous Workbook

Ctrl+Shift+A:- Inserts Argument Names into a Formula

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 Point Size

Shift+Insert:- Paste what is Stored on the Clipboard

Shift+Page Up:- In a Single Column, Highlights all Cells above that are Selected

Shift+Page Down:- In a Single Column, Highlights all Cells above that are Selected

Shift+Home:- Highlights all Text to the Left of the Cursor

Shift+End:- Highlights all Text to the Right of the Cursor

Shift+Up Arrow:- Extends the Highlighted Area Up one Cell

Shift+Down Arrow:- Extends the Highlighted Area Down one Cell

Shift+Left Arrow:- Extends the Highlighted Area Left one Character

Shift+Right Arrow:- Extends the Highlighted area Right one Character

Alt+Tab:- Cycle Through Applications

Alt+Spacebar:- Opens the System Menu

Alt+BackSpace:- Undo

Alt+Enter:- While Typing Text in a Cell, Pressing Alt + Enter will move to the Text Next Line, Allowing for Multiple Lines of Text in one Cell.

Alt+= (Is Equal to):- Create a Formula to Sum all of the above Cells

Alt+' (Apostrophe/Single Quote Mark):- Allows Formatting on a Dialog Box

F1:- Opens the Help Menu

F2:- Edits the Selected Cell

F3:- After a Name has been Created, F3 will Paste Names

F4:- Repeated Last Action. For Example, If you Changed the Color of Text in Another Cell, Pressing F4 will Change the text in Cell to the Same Color

F5:- Goes to a Specific Cell. For example, C6

F6:- Move to the Next Pane

F7:- Spell Check Selected Text or Document

F8:- Enters Extend Mode

F9:- Recalculates Every Workbook

F10:- Activates the Menu Bar

F11:- Creates a = Chart from Selected Data

F12:- =Save As Option

Shift+F1:- Opens the "What 's This" Window

Shift+F2:- Allows the User to Edit a Cell Comment

Shift+F3:- Opens the Excel Formula Window

Shift+F5:- Brings Up a Search Box