Modify Page Layout in Microsoft Excel 2013
Edited by Colette Cole, Catch21chuck, VC, Crystal and 3 others
Layout
Hello and welcome to VisiHow. In this video, I'm going to start a new series on modifying the page layout in Microsoft Excel 2013. This is the first of a six-part series. If you've never used Microsoft Excel 2013 before, I strongly recommend going back to the site and doing a search for navigating, as well as the other starting series. That way, you can get familiar with the environment and how to do some basic functions.
Steps
- 1
- 2
- 3We simply need to left click on "Page Layout". This is going to give us an idea of what it's going to look like as a sheet. It would tell us if the orientation is the right one or if we need to focus on a certain portion of this sheet. If we want to make changes, this view would be a good one to look at.We want to take a look at what the Page Layout is going to look like.
- 4
- 5
- 6
- 7To grab it, we just put our cursor above it, left click and hold. Don't let go and we simply drag the mouse left or right. If we want to zoom in, we just drag the mouse towards the "+" symbol. To zoom out, we simply go to the left. If we're happy, we just leave it there.We can also grab the zoom bar.
- 8"Page Break" will take out everything around the page and just focus on a certain area. We're going to take a look at it on "Page Break Preview" and we will see that particular section has been cut out. We can also insert page breaks and take a look at the page break view as well, but we haven't covered that yet. That is for a later video.Another way we can take a look at it is in "Page Break".
- 9
- 10I would like to thank you for watching VisiHow. If you have any questions or comments about this video or any of the others in this series, please feel free to leave them in the "Comments" section below. You've been watching VisiHow. Have a great day.That is how you see a layout view of your workbook in Microsoft Excel 2013.
Video: Modify Page Layout in Microsoft Excel 2013 Layout
Change Page Orientation
Hello and welcome to VisiHow. We are going to continue the six-part series on how to modify the page layout in Microsoft Excel 2013. In this tutorial, we are going to focus on how to change the orientation of the page. You would want to do this if you wanted to print it or send it someone else in PDF form. You would want to check which orientation is best. There are two types of orientation. There's the portrait orientation and the landscape orientation. Portrait would be best if you had more rows than columns because it's going to have a lot of information going from up to down, whereas landscape would be best if you had more columns than rows because you have more information going from left to right.
Steps
- 1
- 2
- 3
- 4
- 5
- 6
- 7There is more information going from top to bottom instead of left to right. This is good if we need more room for names than weeks. Excel will always be in the portrait orientation by default. If, for some reason, it does accidentally get switched, we can change it that way.Now we can see that the view has changed to the portrait orientation.
- 8
- 9
- 10
- 11Thank you for watching VisiHow. If you have any questions or comments, please feel free to leave them in the comment section below. Have a great day.That is how you change the orientation to portrait or landscape in Microsoft Excel 2013.
Video: Modify Page Layout in Microsoft Excel 2013 Change Page Orientation
Adjusting Margins
Hello and welcome to VisiHow. In this video, we are continuing our six-part series on how to modify page layout in Microsoft Excel 2013. This video is part three of six, and we are going to focus on how to adjust and create the margins in a workbook for Microsoft Excel 2013. There are a couple of ways we can do this. We have our monthly sales figures workbook open right now. What we'd like to do is to look at the margins.
Steps
- 1
- 2We'll see here, some of our options for adjusting the margins. Usually, by default, it's a one-inch margin setup. Sometimes we'll need to change them because, for example, perhaps we may have slightly more content than what we've anticipated, and it's going to cut off as it prints. We're going to need to make more use of the page. Or in many companies, they will require the margins to be a certain size and might need to adjust margins, according to our company's specifications. What we need to do is click on the "Margins" menu.Under "Margins" there are some options.
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13I'd like to thank you for watching VisiHow. If you have any questions or comments about this or any of the other videos, feel free to leave them in the comments section below. You have been watching VisiHow. Take care.That is how you adjust the margins in your workbook using Microsoft Excel 2013.
Video: Modify Page Layout in Microsoft Excel 2013 Adjusting Margins
Title Headings
Hello and welcome to VisiHow. We are continuing our six-part series on how to modify the page layout in Microsoft Excel 2013. In this tutorial, we are going to look at how to include the title headings for printing purposes. If you have a series of pages where we would like to have the titles (either columns or rows) repeated on each page, this can be very helpful.
Steps
- 1
- 2We have set it to repeat row 2 and column A, to keep the weeks and names available. Now when we print more than one page, the week numbers and the names will repeat on all of the pages. This could have a number of different uses. Click "OK" to close that window.Once the window opens, we have the option to select which rows or columns will repeat.
- 3
- 4
- 5
- 6Thank you for watching VisiHow. If you have any questions or comments about this video, please feel free to leave them in the comment section below.That is how you include your title headings for printing purposes when using Microsoft Excel 2013.
Video: Modify Page Layout in Microsoft Excel 2013 Title Headings
Insert or Remove Page Breaks
Hello and welcome to VisiHow. We are going to continue our six-part series on how to modify the page layout in Microsoft Excel 2013. In this tutorial, we are going to show you how to enter a page break. We currently have our Monthly Sales Figures workbook open and we are going to insert a page break. The reason we would want to enter a page break is to split up the views. For example, if we're going to save it as a PDF or we're going to print it and we want the information to be separate.
Steps
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16Thank you for watching VisiHow. If you have any questions or comments about this video, please feel free to use the comment section below.That is how you insert and remove page breaks in Microsoft Excel 2013.
Video: Modify Page Layout in Microsoft Excel 2013 Insert or Remove Page Breaks
Insert Header Footer and Page Number
Hello! Welcome to VisiHow! This is video number six in our six-part series of modifying page layout in Microsoft Excel 2013. In this video, we are going to discuss how to insert a header and footer in our workbook for printing or sending and exporting purposes. Labeling footer and header with numbers and letters, our company logo, or anything like that will come very handy. We can insert them once, and then they will just be repeated on each document page.
Steps
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12If we want page numbers, we do not simply click a cell and enter the numbers, because we want the numbers to go in some sort of a consecutive order. Let's say there were 50 pages. We might want to number them as page 1 of 50 or something like that.The other thing we can do is to insert numbers, if we want to do so.
- 13
- 14
- 15
- 16
- 17
- 18The footer will change to "1 of 1". If we have or add more pages, Excel will automatically show how many pages there are from this point. Excel will just keep adding or subtracting the pages. For example, if we have in the end 50 pages, Excel will show "1 of 50" on the first page, "2 of 50" on the second page, and so on if we number them in consecutively. In this case, we only have one set up right now. So, Excel is just saying that it is page "1 of 1". It depends on how we like to see that set up.We click "Number of Pages" on the ribbon.
- 19
- 20This will automatically bring up the preview without having to print it. When we look at the preview, there will be the header and footer shown with the page numbering. We have the title, the footer that says, "Created by Collete", and page number "1 of 1" in this example.Once we have it the way we like it, we can simply click "FILE" and "Print" to preview the spreadsheet.
- 21
- 22
- 23
- 24
- 25
That is how we insert a header and footer in Microsoft Excel 2013. The rest of the Microsoft Office operates the same way when it comes to inserting page numbers, headers, and footers. I would like to thank you for watching VisiHow. If you have any questions or comments about this video, please feel free to use the comment section below. You have been watching VisiHow. Take care!
If you have problems with any of the steps in this article, please ask a question for more help, or post in the comments section below.
Comments
Article Info
Categories : Windows
Recent edits by: Alexander Avdeev, Eng, Crystal