Handy keyboard shortcuts

User avatar
Site Admin
Posts: 9
Joined: 05 Apr 2020, 03:06
Location: PTP Nagar, Trivandrum

Handy keyboard shortcuts

Postby Administrator 12 Apr 2020, 23:36

File tab

2020-04-12 23_24_08-Performance Dashboard.xlsm - Excel.png
2020-04-12 23_24_08-Performance Dashboard.xlsm - Excel.png (57.7 KiB) Viewed 704 times

The File tab behaves differently than the other Ribbon tabs. Rather than seeing a set of commands on the Ribbon above your workbook, when you click the File tab, you're taken to an area that Microsoft calls "Backstage."

Instead of making changes within a workbook, Backstage lets you work with the workbook and with Excel overall. You'll find common tasks such as opening, saving, printing and sharing a workbook, as well as special screens for managing the workbook (the Info screen), your Office account (the Account screen), and how Excel behaves overall (the Options screen).

FileTab.png (83.82 KiB) Viewed 704 times

Home tab
HomeTab.png (33.94 KiB) Viewed 704 times

The Home tab contains many frequently used Excel features, such as tools for formatting cells; inserting, deleting and formatting rows and columns; sorting and filtering data; changing fonts and font attributes; and copying and pasting text and data.

HomeTabCommands.png (106.25 KiB) Viewed 704 times

Insert tab
Insert Tab.png
Insert Tab.png (30.78 KiB) Viewed 701 times

If you need to insert something into your worksheet, whether it be a chart, table, PivotTable, picture, text box, hyperlink, equation or just about any other “extra,” here’s where to go.
Insert Tab Shortcuts.png
Insert Tab Shortcuts.png (104.7 KiB) Viewed 701 times

Page Layout tab
Page Layout.png
Page Layout.png (24.8 KiB) Viewed 701 times

Go here to change the overall look of your worksheet, including selecting and customizing themes, changing the worksheet’s margins and background, designating whether to use and print gridlines and headings, and similar options.

Page Layout  Shortcut.png
Page Layout Shortcut.png (96.45 KiB) Viewed 701 times

Formulas tab
Formula Tab.png
Formula Tab.png (27.36 KiB) Viewed 701 times
As the name says, the Formulas tab is the place to go for adding and working with formulas, including AutoSum functions as well as logical, financial, math or trigonometry, statistical and others. It also includes tools for auditing formulas and performing calculations.

Formula Bar Shortcut.png
Formula Bar Shortcut.png (118.16 KiB) Viewed 701 times

Data tab
Data Tab.png
Data Tab.png (32.62 KiB) Viewed 701 times

Here’s where to go for all tools related to working with data. You’ll be able to grab data from many different sources, transform it, sort and filter it, validate it, remove duplicate data, perform a what-if analysis and create a forecast worksheet from historical data.
Data Tab Shortcut.png
Data Tab Shortcut.png (147.5 KiB) Viewed 701 times

Review tab
Review Tab.png
Review Tab.png (25.87 KiB) Viewed 701 times

Want to share comments with others in a worksheet, check spelling, work in markup mode, review other people's markups, compare documents or protect workbooks and worksheets? This is the tab for you.
Review Tab Shortcuts.png
Review Tab Shortcuts.png (118.63 KiB) Viewed 701 times

View tab
View Tab.png
View Tab.png (24.82 KiB) Viewed 701 times

Go here to change the view, including displaying a ruler, grid lines, the formula bar and headings; zooming in and out; splitting a window; changing between views (normal, page break, etc.); and so on. It’s also the place to view and record macros.
View Tab Shortcuts.png
View Tab Shortcuts.png (142.36 KiB) Viewed 701 times
Thanks & Regards
Saran BL


Was This Topic Useful?

Last 10 Members Who Visited This Topic

Zelenawtd, austin, magdalena, User avatar Administrator

Return to “Basic Excel Training”

Who is online

Users browsing this forum: No registered users and 1 guest