show margins in excel 2013 print preview

Gridlines - Toggles the display of gridlines on the active worksheet. These units can be either inches, centimeters or millimeters. By default the ruler displays the default units that are specified in the control panel, regional settings. You can change the units displayed from the (Excel Options, Advanced tab)(Display, Ruler Units). This is only available when you are in the Page Layout view. Ruler - Toggles the display of the horizontal and vertical rulers. Press Esc to return to the normal screen.

Displays the workbook in full screen mode.

There is also a shortcut to this view in the bottom right corner of the status bar.Ĭustom Views - Displays the 'Custom Views' dialog box.įull Screen - (Removed in 2013). Page Layout - Displays the worksheet as it will appear on a printed page.Displays a very useful horizontal and vertical ruler plus you can add/change headers and footers, check margins, row/column headings and scaling options. There is also a shortcut to this view in the bottom right corner of the status bar. Normal - Displays the worksheet in the normal view. Only enabled in Excel online or on the Desktop when your workbook has been saved in OneDrive. Lets you create different views of the same worksheet when you are collaborating with others. The commands for hiding and showing workbooks (and windows) can be found on this tab. The commands for hiding and showing worksheets are on the Home Tab under (Format > Unhide). It also provides options for viewing different windows in Excel, for enlarging or reducing the size of the worksheet while it is being viewed, and what elements in the Excel window should be displayed. This bar provides different options for viewing the sheets in an Excel workbook. In this article, we will learn What is VIEW Tab in Microsoft Excel & It's Uses.

Show margins in excel 2013 print preview