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).
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.
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.
Page Layout tab
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.
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.
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.
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.
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.
1 post • Page 1 of 1
Was This Topic Useful?
Last 10 Members Who Visited This Topic
Who is online
Users browsing this forum: No registered users and 1 guest