Ms Excel Shortcuts Keys, Most Useful Ms Excel Shortcut Keys

Ms Excel or Microsoft Excel is a spreadsheet. Ms excel developed by 'Microsoft' for Windows, macOS,  iOS & Android. All Shortcut Keys are very useful for typing, working in sheet and many other works.

(Image Credit - pixabay.com)

Most Useful & Very Important Ms Excel Shortcut Keys :-

   Shortcut        Description

● Ctrl+A -       Select all

● Ctrl+B -       Bold

● Ctrl+C -       Copy all cells in the highlighted section

● Ctrl+D -        Fill down

● Ctrl+F -        Search the current sheet

● Ctrl+G -        Go to certain area

● Ctrl+H -       Find & replace

● Ctrl+I -         Italic

● Ctrl+K -       Inserts a hyperlink

● Ctrl+L -       Open the create table dialog box

● Ctrl+M -      Indent the paragraph

● Ctrl+N -       Open new or blank document

● Ctrl+O -       Opens a workbook

● Ctrl+P -       Print

● Ctrl+R -       Fill right
 
● Ctrl+S -       Saves open worksheet

● Ctrl+T -       Open create table dialog box

● Ctrl+U -       Underline

● Ctrl+V -       Paste

● Ctrl+W -      Close window

● Ctrl+X -       Cut cells in the highlighted section

● Ctrl+Y -      Redo

● Ctrl+Z -      Undo

■ Read Also : Ms Word Shortcuts Keys

Shortcut    Description

Ctrl+0 -     Hide columns
Ctrl+1 -     Changes format of the selected cells
Ctrl+2 -     Bold
Ctrl+3 -     Italic
Ctrl+4 -     Underline
Ctrl+5 -     Strikethrough
Ctrl+6 -     Show or hide the object
Ctrl+7 -     Show or hide the toolbar
Ctrl+8 -     Toggles outline symbol
Ctrl+9 -     Hide row

Selecting Cells :-

    Shortcut               Description

Shift+Space -          Select entire row
Ctrl+Space -            Select the entire column
Ctrl+Shift+Space -  Select the entire worksheet
Shift+Left/Right Arrow -  Extend cell selection to the left or right

Function Keys :-

Shortcut     Description

● F1   -   Open help
● F2   -   Selected cell edit
● F3   -   After name created 'f3' will paste name
● F4   -   Repeat last action
● F5   -   Goes specific cell
● F6   -   Move to the next pane
● F7   -   Spell check selected document & text
● F8   -   Enter extend mode
● F9   -   Recalculate
● F10 -   Activate menu bar
● F11 -   Create a chart from selected data
● F12 -   Save As

(Image Credit - pixabay.com)

Shortcut     Description

Alt+F1 :-      Insert chart

Alt+F2 :-      Save as

Alt+F4 :-      Exits excel

Alt+F8 :-      Open macro dialog box

Alt+F11 :-    Open visual basic editor

Alt+Shift+F1 :-  Create new worksheet

Alt+Shift+F2 :-  Save current worksheet

■ Read Also : Details of Operating System

   Shortcut         Description

 Ctrl+Shift+:    - Enter the current time

 Ctrl+;              - Enter current date

 Ctrl++             - Insert

 Ctrl+-              - Delete

 Ctrl+Shift+(   - Unhide rows

 Ctrl+Shift+)   - Unhide columns

 Ctrl+/             - Selects the array

 Ctrl+\             - Select the cells static value

 Ctrl+Enter - Fill selected cells with current entry

 Ctrl+Spacebar - Select entire column

 Ctrl+Shift+Spacebar - Selects entire worksheet

 Ctrl+Home      - Move to cell A1

 Ctrl+End          - Move to last cell

 Ctrl+Tab          - Move between two or more open files

Shift & Functions Keys :-

     Shortcut         Description

  ● Shift+F1 -   Opens the 'What's This?' window

  ● Shift+F2 -   Allow user to edit a cell comment

  ● Shift+F3 -    Opens excel formula window

  ● Shift+F5 -    Brings up a search box
 
  ● Shift+F6 -    Move to the previous pane

  ● Shift+F8 -    Add to selection

  ● Shift+F9 -    Performs calculate function


Thank you so much for read this article ...
Subscribe Our Blog For More Latest and Interesting Post.