Home Gadget Bridge Ace 15 Microsoft Excel keyboard shortcuts every beginner should know

15 Microsoft Excel keyboard shortcuts every beginner should know

Do you find working with MS Excel challenging? These keyboard shortcuts will make this task simple.

Working with Microsoft Excel can be a daunting experience for some people. Prior knowledge of Tables and Mathematics is required before you can handle any task on MS Excel. Without using keyboard shortcuts, handling tables can become troublesome.  Here is a list of 15 MS Excel keyboard shortcuts that you should get handy with to make working with MS Excel hassle-free.

1) To create or open an existing MS Excel workbook, you can use the following shortcuts rather than going to the File Menu.

- Advertisement -

Ctrl+N: Create a new workbook

Ctrl+O: Open an existing workbook

2) Saving a workbook cannot be easier than using the following shortcuts.

Ctrl+S: Save a workbook

F12: Open the Save As dialog box

Save

3) As soon as you close a workbook, you will get a dialog box to choose to save or discard the workbook.

Ctrl+W: Close a workbook

Ctrl+F4: Close Excel

Close

4) F4: It’s the shortcut to repeat the last command. For instance, if the last action you did was to type in a cell, clicking another cell and pressing F4 repeats that action in the new cell.

5) Shift+F11: This keyboard shortcut allows you to insert a new worksheet within the same workbook.

Insert Worksheet

6) The Undo and Redo shortcuts give you flexibility while correcting errors done on your part.

Ctrl+Z: Undo an action

Ctrl+Y: Redo an action

7) Ctrl+F2: By this shortcut, you can switch to the Print Preview

Print

8) F1: This keyboard shortcut will open the Help pane to know about the features and how to use them in your workbook.

9) Alt+Q: It will take you to the “Tell me what you want to do” where you can search for a feature you want to use but can’t locate.

10) F7: By this shortcut, you can check the spelling by comparing it with the suggestions

Spelling

11) F9: This keyboard shortcut allows you to calculate all worksheets in all open workbooks.

Shift+F9: By this, you can calculate only in the active worksheets.

12) Alt or F10: Utilizing this shortcut, you can simply turn the tips on or off.

13) Ctrl+F1: Using this keyboard shortcut, you can show or hide the ribbon

14) Ctrl+Shift+U: You can expand or collapse the formula bar

15) F11: It enables you to make a bar chart on the selected data in a separate sheet.

Alt+F1: By this, you can make an embedded bar chart on select data in the same sheet.

Bar chart

For the latest gadget and tech news, and gadget reviews, follow us on TwitterFacebook and Instagram. For newest tech & gadget videos subscribe to our YouTube Channel. You can also stay up to date with the Gadget Bridge Android App.

- Advertisement -

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisement -

Follow Us

120,852FansLike
8,924FollowersFollow
4,826FollowersFollow
5,090SubscribersSubscribe

Must Read

SHARP-QNET SmartAir IoT enabled Air Purifier launched in India

SHARP-QNET SmartAir IoT enabled Air Purifier launched in India

0
QNET in collaboration with Sharp today announced the launch of a digitally advanced room air purifier - SHARP-QNET SmartAir in India. The device is...
- Advertisement -