In this article, we will learn What is Page Layout Tab in Microsoft Excel & It's Uses.
Many of the commands we use in preparing our workbook for printing and PDF export can be found on the Page Layout tab. These commands let us control the way our content will appear on a printed page, including the page orientation and margin size. Other page layout options, such as print titles and page breaks, can help make your workbook easier to read.
Themes
Themes - Drop-Down. Changes the overall look and feel of your workbook including colours, fonts and effects. The drop-down contains the commands: Built-in, More Themes on Microsoft Office Articles , Browse for Themes and Save Current Theme. The built-in themes are: Office, Facet, Integral, Ion, Boardroom, Organic, Retrospect, Slice, Wisp, Berlin and Frame. Tooltip indicates the current theme. The default theme is "Office".
Colors - Drop-Down. Displays a list of all the available colours and lets you change the colour component of the active theme. The drop-down contains the commands: Built-in and Customize Colors.
Fonts - Drop-Down. Displays a list of all the available fonts and lets you change the font component of the active theme. The drop-down contains the commands: Built-in and Customize Fonts.
Effects - Drop-Down. Displays a list of all the available effects and lets you change the effect component of the active theme. The drop-down contains the commands: Office, Office 2007-2010, Subtle Solids, Banded Edges, Smokey Glass, Glow Edge, Grunge Texture, Frosted Glass, Top Shadow, Inset, Milk Glass, Riblet, Reflection, Extreme Shadow, Glossy.
Page Setup
You can quickly display the "Page Setup" dialog box, Page tab, by clicking on the launcher in the bottom right corner of this group.
Margins - Drop-Down. Lets you choose from one of your built-in margin settings or lets you customise your own. The drop-down contains the commands: Normal, Wide, Narrow and Custom Margins. The Custom Margins displays the "Page Setup" dialog box, Margins tab.
Orientation - Drop-Down. Lets you switch between Portrait and Landscape.
Size - Drop-Down. Lets you select from all the different available paper sizes. The More Paper Sizes displays the "Page Setup" dialog box, Page tab.
Print Area - Drop-Down. This drop-down contains the commands: Set Print Area and Clear Print Area.
Breaks - Drop-Down. This drop-down contains the commands: Insert Page Break, Remove Page Break and Reset All Page Breaks.
Background - Displays the "Sheet Background" dialog box to let you add a background image to the back of a worksheet. This caption changes to 'Delete Background' if an image is assigned to the active worksheet.
Print Titles - Displays the "Page Setup" dialog box, Sheet tab. This allows you to enter rows or columns to repeat.
Scale to Fit
You can quickly display the "Page Setup" dialog box, Page tab, by clicking on the launcher in the bottom right corner of this group.
Width - Choice of 1 to 9 pages. The combo box contains Automatic, 1 to 9 pages and More Pages. The More Pages displays the "Page Setup" dialog box, Page tab. Provides a shortcut to (Page Setup)(Page tab, Scaling).
Height - Choice of 1 to 9 pages. The combo box contains Automatic, 1 to 9 pages and More Pages. The More Pages displays the "Page Setup" dialog box, Page tab. Provides a shortcut to (Page Setup)(Page tab, Scaling).
Scale - Changes the page scale in increments of 5%. Provides a shortcut to the (Page Setup)(Page tab, Scaling).
Sheet Options
You can quickly display the "Page Setup" dialog box, Sheet tab, by clicking on the launcher in the bottom right corner of this group.
Gridlines View - Toggles the display of gridlines on the active worksheet. Provides a shortcut to (Page Setup)(Sheet tab, "Gridlines").
Gridlines Print - Toggles whether the gridlines are printed. Provides a shortcut to (Excel Options)(Advanced tab, "Show gridlines").
Headings View - Toggles the displays of row and column headers on the active worksheet. Provides a shortcut to (Excel Options)(Advanced tab, "Show row and column headers").
Headings Print - Toggles whether the row and column headers are printed. Provides a shortcut to (Page Setup)(Sheet tab, "Row and column headings").
Arrange
This whole group also appears on the Drawing Tools - Format Tab, Picture Tools - Format Tab.
Bring Forward - Button with Drop-Down. The button brings the selected object forward one level. The drop-down contains the commands: Bring to Front and Bring Forward. Bring to Front will bring the selected object in front of all the other objects.
Send Backward - Button with Drop-Down. The button brings the selected object back one level. The drop-down contains the commands: Send to Back and Send Backward. Send to Back will send the selected object to the back of all the other objects.
Selection Pane - Drop-Down. Displays the Selection Task Pane.
Align - Drop-Down. This drop-down contains the commands: Align Left, Align Center, Align Right, Align Top, Align Middle, Align Bottom, Distribute Horizontally, Distribute Vertically, Snap to Grid, Snap to Shape, View Gridlines.
Align (Word extras) Align to Page, Align to Margin, Align Selected Objects, View Gridlines and Grid Settings.
Align (PowerPoint extras) Align to Slide, Align Selected Objects, View Gridlines and View Settings.
Group - Drop-Down. This drop-down contains the commands: Group, Regroup and Ungroup.
Rotate - Rotate or flip the selected object. Drop-Down. This drop-down contains the commands: Rotate Right 90, Rotate Left 90, Flip Vertical, Flip Horizontal and More Rotation Options.
Hope this article about What is Page Layout Tab in Microsoft Excel & Its use is explanatory. Find more articles on calculating values and related Excel formulas here. If you liked our blogs, share them with your friends on Facebook. And also you can follow us on Twitter and Facebook. We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write to us at info@exceltip.com.
Useful Articles :
10+ Creative Advanced Excel Charts to Rock Your Dashboard : These creative charts can make you stand apart from the crowd. These charts can be used for different types of reports. Your dashboard will be more expressive than ever.
How to Save and Use an Excel Chart Template : It is important to save chart templates for repetitive charts to save time and energy. To save chart templates in excel follow these steps.
Best Charts in Excel and How To Use Them : These are some of the best charts that Excel provides. You should know how to use these charts and how they are interpreted. The line, column and pie chart are some common and but effective charts that have been used since the inception of the charts in excel. But Excel has more charts to explore.
Excel Sparklines : The Tiny Charts in Cell : These small charts reside in the cells of Excel. They are new to excel and not much explored. There are three types of Excel Sparkline charts in Excel. These 3 have sub categories, let's explore them.
Change Chart Data as Per Selected Cell : To change data as we select different cells we use worksheet events of Excel VBA. We change the data source of the chart as we change the selection or the cell. Here's how you do it.
Popular Articles :
50 Excel Shortcuts to Increase Your Productivity : Get faster at your tasks in Excel. These shortcuts will help you increase your work efficiency in Excel.
How to use the VLOOKUP Function in Excel : This is one of the most used and popular functions of excel that is used to lookup a value from different ranges and sheets.
How to use the IF Function in Excel : The IF statement in Excel checks the condition and returns a specific value if the condition is TRUE or returns another specific value if FALSE.
How to use the SUMIF Function in Excel : This is another dashboard essential function. This helps you sum up values on specific conditions.
How to use the COUNTIF Function in Excel : Count values with conditions using this amazing function. You don't need to filter your data to count specific values. Countif function is essential to prepare your dashboard.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
Here is all I needed
All of the item that I need is in here