Microsoft Excel is a wonderful tool that makes our work easier when it comes to keeping records, creating forms , making statistical graphics, and much more. For them, it has a multitude of options that allow us to adapt each spreadsheet to our liking. But do you know what the page layout view is for or is used in Excel and its parts? In this article we explain it to you.
What is page layout view for in Excel?
Surely you have ever been using Microsoft Excel and have noticed that in the ribbon there is a tab called ‘View’. When you click on it, a series of options appears that modify the way we see the spreadsheet we are working on. These are also organized in groups.
This time we are interested in the first group, called ‘Book Views’. In this, you will see the option ‘Page layout’, and if you click on it you will get a preview of how your document will look when printed . This will prevent you from printing your spreadsheet with a formatting error, because in addition to showing the preview, it will let you edit it.
What can I see in page layout view in Excel?
In this preview you will be able to see the margins of the pages that are going to be printed, as well as the headers or footers, if any. You can take advantage of setting the margins here. If you want to add a header or a footer, click on the top or bottom of your spreadsheet, as the case may be, and then again on the text box for it.
Another detail of the page layout view is that two rulers appear at the top and left of the screen that indicate the margin measurements. If you do not see them useful, you can remove them very easily.
You just have to go to the second group of view options that says ‘Sheet options’ and remove the check mark from the rule. Here you can also turn on the grid lines to make sure your sheet is aligned properly.
What other views does Excel offer?
The page layout view isn’t the only one you can select to see how your spreadsheet will print. You can also select the ‘Page break ‘ view , which shows you a reduced view of your sheet with a series of blue marks where the page breaks will be made on printing. If these breaks are not where you would like, you can modify your document so that the information is not abruptly cut off.
If the above happens to you, keep in mind that you can adjust your data to a single page , or a specific number of pages, to avoid unexpected cuts. This process is very simple and you will find all the steps on the Microsoft Support page.
On the other hand, there is also the ‘Custom’ view. As its name implies, it allows you to customize the guidelines of your spreadsheet: for example, you can change the color of the sheet and the type of font, among other things; and save those settings to apply them to other sheets later. So you can create your own format and apply it whenever you want.
Other tools that could be very useful to you are those found in the ‘Window’ group. Among those that seem more practical to us is the option ‘Split window’, with which you will get a view in which your screen is divided into several adjustable panels so that you can see several parts of your spreadsheet at the same time.
On the other hand, with the option ‘View in parallel’ you can review two active books simultaneously . For this, it is best that both have a horizontal organization that facilitates a good vision in the two files.
As you can see, Microsoft Excel is an extremely versatile program, which allows you to edit and adjust your spreadsheet to your needs. We hope this article on the uses of the page layout view in Excel and its parts has been helpful to you . And don’t forget to share it if you liked it!