Best keyboard shortcuts for excel - Do Tech Blog
SEO Guide Window Android Security Technology Science Programming Blogger Mobile Earning Mobile Application Tips & Tricks

Thursday, February 13, 2020

Best keyboard shortcuts for excel

Today, in this post, you will get the key to the computer's best keyboard shortcuts for excel. So that you can work on your computer more quickly.
In which you have been told about General Program Shortcuts, Using Function Keys, Most Frequently Used Shortcuts in Excel, Moving Around in a Worksheet or Cell.

Best keyboard shortcuts for excel 

Best keyboard shortcuts for excel

General Program Shortcuts

Ctrl + C      ⇒  Copy
Ctrl + X      ⇒   Cut
Ctrl + V      ⇒   Paste
Ctrl + N      ⇒  New Workbook
Ctrl + O      ⇒  Open Workbook
Ctrl + S      ⇒  Save Workbook
Ctrl + Z      ⇒   Undo
Ctrl + Y      ⇒   Redo
Ctrl + P      ⇒  Print File
Ctrl + F      ⇒  Find Box
Ctrl + H      ⇒   Find and Replace
Alt              ⇒  Activate Access Keys
Tab     ⇒   Move to next control on Ribbon
  
 Using Function Keys


F1                  ⇒  Open Help
Alt + F + T     ⇒  Open Options
Ctrl + F1        ⇒  Expand or close Ribbon
Alt + F1         ⇒  Create an Embedded Chart
Ctrl + F2       ⇒  Open Print Preview
F4                 ⇒  Repeat Last Actions
Ctrl + F4       ⇒  Close Workbook
Alt + F4        ⇒  Close Excel
F11               ⇒  Create Chart in new Worksheet
F12              ⇒  Save As


Most frequently used shortcuts in Excel.

Best keyboard shortcuts for excel
//Most Frequently used                                                                                                  To do this                                Press

  • Close a workbook             ⇒  Ctrl+W
  • Open a workbook             ⇒  Ctrl+O
  • Go to the Home tab          ⇒  Alt+H
  • Save a workbook             ⇒  Ctrl+S
  • Copy             ⇒  Ctrl+C
  • Paste             ⇒  Ctrl+V
  • Undo             ⇒  Ctrl+Z
  • Remove cell contents   ⇒  Delete
  • Choose a fill color         ⇒  Alt+H, H
  • Cut                                  ⇒  Ctrl+X
  • Go to Insert tab             ⇒  Alt+N
  • Bold                               ⇒  Ctrl+B
  • Center align cell contents       ⇒  Alt+H, A, C
  • Go to Page Layout tab             ⇒  Alt+P
  • Go to Data tab             ⇒  Alt+A
  • Go to View tab             ⇒  Alt+W
  • Open context menu    ⇒  Shift+F10, or Context key
  • Add borders                ⇒  Alt+H, B
  •  
  • Delete column             ⇒  Alt+H, D, C
  • Go to Formula tab                ⇒  Alt+M
  • Hide the selected rows        ⇒  Ctrl+9
  • Hide the selected columns  ⇒  Ctrl+0



Moving Around in a Worksheet or Cell

//Moving Worksheet
            ⇒   Cell Right
←            ⇒   Cell left
              ⇒   Cell Up
↓              ⇒   Cell down
//Moving Worksheet                                                                                                                      Alt + PgDn             ⇒  Move one screen down

  • Alt + PgUp      ⇒  Move one screen left
  • PgUp               ⇒   Screen Up
  • PgDn               ⇒  Screen Down
  • Ctrl + →           ⇒   Right Edge of Data
  • Ctrl + ←           ⇒   Left Edge of Data
  • Ctrl + ↑             ⇒   Top Edge of Data
  • Ctrl + ↓             ⇒   Bottom Edge of Data
  • Home               ⇒  Beginning of Row

Selecting Cells



Best keyboard shortcuts for excel



  • //Selecting Cells                                                                                                                             Shift+Left/Right Arrow             ⇒  Extend the cell selection to the left or right
  • Shift+Space             ⇒  Select the entire row
  • Ctrl+Space                        ⇒   Select the entire column
  • Ctrl+Shift+Space             ⇒   Select the entire worksheet
  • Esc             ⇒  Cancel an entry in a cell or the formula bar
  • Enter             ⇒   Complete an entry in a cell or the formula ba
  • Delete             ⇒  Remove the contents of a cell, selected data, or selected cell range
  • Alt+Enter             ⇒   Insert a hard return within a cell (while editing a cell)
  • F2             ⇒   Edit a cell
  • Shift+F2             ⇒   Add or edit a cell comment
  • Ctrl+X             ⇒   Cut contents of a cell selected data, or selected cell range
  • Ctrl+C or Ctrl+Insert             ⇒  Copy contents of a cell selected data, or selected cell range
  • Ctrl+V or Shift+Insert             ⇒   Paste contents of a cell selected data, or selected cell range
  • Ctrl+Alt+V             ⇒   Open the Paste Special dialog box
  • F3             ⇒  Paste a cell name (if cells are named in the worksheet)
  • Alt+H+D+C             ⇒  Delete column


Formatting Cells

//Formating Cells

  • Ctrl+B             ⇒   Add or remove bold to the contents of a cell, selected data, or selected cell range
  • Ctrl+I             ⇒   Add or remove italics to the contents of a cell, selected data, or selected cell range
  • Ctrl+U             ⇒   Add or remove underline to the contents of a cell, selected data, or selected cell range
  • Alt+H+H             ⇒   Select a fill color
  • Alt+H+B             ⇒  Add a border
  • Ctrl+Shift+&             ⇒   Apply outline border
  • Ctrl+Shift+_ (Underline)             ⇒   Remove outline border
  • Ctrl+9             ⇒   Hide the selected rows
  • Ctrl+0             ⇒  Hide the selected columns
  • Ctrl+1             ⇒  Open the Format Cells dialog box
  • Ctrl+5             ⇒   Apply or remove strikethrough
  • Ctrl+Shift+$              ⇒   Apply currency format
  • Ctrl+Shift+%             ⇒   Apply percent format



No comments:

Post a Comment