Page Layout Tab and Formulas Tab in Excel

MS Excel Page Layout Tab

In this tutorial, we will tell you about the Page Layout Tab of MS Excel. You can activate the Page Layout Tab of MS Excel by pressing Alt + P from the keyboard. Or you can also use it by mouse.

Page Layout Tab is divided into several groups. Each group has commands related to a specific task. You can use these commands by pressing the mouse. Below we will tell you how many groups are there in the Page Layout Tab? And what is the function of the commands available in each group.

Page Layout Tab Groups Names and Their Functions

There are total 5 groups in the Page Layout Tab. You can see them in the screen shot shown above. These groups are named Themes, Page Setup, Scale to Fit, Sheet Options and Arrange respectively. Now you have become familiar with the Groups of the Page Layout Tab. Let us now know the work of each group.

Themes In MS Excel

Themes are applied to Excel Sheets in the Themes Group. There are already many themes in Excel. Font, Font Style is set differently in each theme. You can choose themes as per your requirement. If you want, you can also modify that theme according to your need. Or you can also create a new theme for yourself.

Page Setup In MS Excel

The Page Setup Group contains the commands related to the Settings of the Page Margins, Orientation, Size of the Excel Document. Apart from these, the settings of Print Area, and Page Breaks are done by the commands available in this group. Sheet background is also changed from this.

Scale to Fit In MS Excel

Settings related to printing Excel Sheets are done through the commands available in this group. You can set the Width and Height of the Sheet according to you. How many areas do you want to print? Accordingly, the settings of the sheet can be done. You can also set it Automatic.

Sheet Options In MS Excel

There are two commands in the Sheet Options Group. The first command Gridlines is used to show or not show Gridlines in the Sheet. You can also print gridlines. Aura can’t even print. The second command Headings is used to Show/Hide Sheet Headings. And you can also do settings related to printing them.

Arrange In MS Excel

Arrange Group is used to arrange Insert Graphics in Excel Sheets. You can set the position of the picture, its alignment, grouping etc. through the commands present in this group.

MS Excel Formulas Tab

In this tutorial, we will tell you about the Formulas Tab of MS Excel. The Formulas tab is used to insert functions, define names, and review formulas. You can activate the Formulas Tab of MS Excel by pressing Alt+M from the keyboard. Or you can also use it by mouse.

The Formulas tab is divided into several groups. Each group has commands related to a specific task. You can use these commands by pressing the mouse. Below we will tell you how many groups are there in the Formulas Tab? And what is the function of the commands available in each group.

Names and Functions of Groups in the Formulas Tab

There are total 4 groups in the Formulas tab. You can see them in the screen shot shown above. The names of these groups are Function Library, Defined Names, Formula Auditing and Calculation respectively. Now you have become familiar with the Groups of the Formulas Tab. Let us now know the work of each group.

1- Function Library

Excel Formulas are included in this group. You can access all Excel Formulas from this group. Here the formulas are classified categorically.

2- Defined Names

The commands available in this group are used for cells. You can name the cell, edit its name. If you have already defined Cell Name then you can see all of them from here.

3- Formula Auditing

The commands available in this group have a very important function. You can do Auditing of Excel Formulas by this Commands. Trace Precedent tells us on which cells the current formula is based. From Trace Dependents, we get to know which rows are being affected by the selected cell. It is the opposite of Trace Precedent. From Show Formula, we see the formulas used in the sheet. We can find out the Errors in Formulas by Error Checking. And can evaluate any formula step by step by Evaluate Formula.

4- Calculation

Calculations are controlled by the commands available in this group. You can set Automatically to Manually and Manually to Automatically Calculation by Calculation Options. If Automatically Calculation is off then you can calculate by Calculate New and Calculate Sheet Command.

What have you learned?

In this tutorial, we have told you in detail about the Page Layout Tab and Formulas Tab of MS Excel. You have also learned about the working of each group available in Page Layout Tab and Formulas Tab. We hope that you will be able to use the Formulas Tab easily after reading this tutorial. And this tutorial will prove useful for you.

• What is MS Excel | Best Way To Learn Excel

• How to install microsoft office in Computer

• How to Open MS Excel In Computer Step by Step

• How to Open and Close Workbook in MS Excel

• How to Save and Cut MS Excel Workbook

• How to Use Copy and Paste in Excel

• Home Tab and Insert Tab in Microsoft Excel