25 MS Excel Shortcuts You Must Know Before Using It! | Infographic

Microsoft Excel is one of the best of the bests creation by Microsoft. It made the accountant’s life easier and made the whole mathematical and administrative workloads minimum. You can now run a Macro on Excel and it will do everything automatically.

Besides, you want to calculate a math? need a invoice? or a balance sheet of the whole year? Some shortcuts of MS Word will do everything for you.

Here are some basic shortcut keys of Excel that you must know to use the Excel software efficiently.

MS Excel Shortcuts

Here are 50 more MS Excel Shortcut Keys:

Close a spreadsheetCtrl+W
Open a spreadsheetCtrl+O
Go to the Home tabAlt+H
Save a spreadsheetCtrl+S
CopyCtrl+C
PasteCtrl+V
UndoCtrl+Z
Remove cell contentsDelete key
Choose a fill colorAlt+H, H
CutCtrl+X
Go to Insert tabAlt+N
BoldCtrl+B
Center align cell contentsAlt+H, A, then C
Go to Page Layout tabAlt+P
Go to Data tabAlt+A
Go to View tabAlt+W
Open context menuShift+F10, or
Context key
Add bordersAlt+H, B
Delete columnAlt+H,D, then C
Go to Formula tabAlt+M
Hide the selected rowsCtrl+9
Hide the selected columnsCtrl+0
Open the Tell me box on the Ribbon and type a search term for assistance or Help content.Alt+Q, and then enter the search term.
Open the File page and use Backstage view.Alt+F
Open the Home tab and format text and numbers and use the Find tool.Alt+H
Open the Insert tab and insert PivotTables, charts, add-ins, Sparklines, pictures, shapes, headers, or text boxes.Alt+N
Open the Page Layout tab and work with themes, page setup, scale, and alignment.Alt+P
Open the Formulas tab and insert, trace, and customize functions and calculations.Alt+M
Open the Data tab and connect to, sort, filter, analyze, and work with data.Alt+A
Open the Review tab and check spelling, add comments, and protect sheets and workbooks.Alt+R
Open the View tab and preview page breaks and layouts, show and hide gridlines and headings, set zoom magnification, manage windows and panes, and view macros.Alt+W

If you really liked this collection of shortcut keys of Excel, share it with your friends and families who love using Microsoft Excel or going to use.

Thanks.

Leave a Reply

Your email address will not be published. Required fields are marked *