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
- 1I have opened my "MONTHLY SALES FIGURES" workbook, and we have the month of May up here. I've named it "May 2015", and it's ready to go. The next thing we want to do is see what it's going to look like whenever I print it into its paper form. To do that, we want to be able to view the page layout.
Advertisement - 2The first thing we're going to do is go to the bottom right-hand corner of the workbook. We'll see that there's a quick access toolbar that has some quick commands that you can get Excel to view. Right now we are in Normal view.
Advertisement - 3We want to take a look at what the Page Layout is going to look like. We 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.
- 4While it's in this form, we can choose to zoom. There's a little bar on the bottom that allows us to zoom. We can click on either the "+" or "-" to zoom in or out.
- 5We can click the "-" symbol to zoom out to see what the sheets would look like if they're printed.
- 6If we want to get a closer look, we can just click on the "+" symbol and that will give us a better look.
- 7We can also grab the zoom bar. To 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.
- 8Another way we can take a look at it is in "Page Break". "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.
- 9We can simply go back to normal view and continue working from there, or if we chose to print it from there, we could do that as well.
- 10That is how you see a layout view of your workbook in Microsoft Excel 2013. I 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.
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
- 1In order to change the orientation, the first thing we're going to do is go up to the ribbon at the top and click on "PAGE LAYOUT". Once we're in this tab, we're going to see several different options.
- 2We're going to click on "Orientation". Here we will have the option between "Portrait" and "Landscape".
- 3Right now it's on "Portrait", but if we wanted to change it to "Landscape", we would simply click on it.
- 4Now it has changed the orientation so that whenever it prints, it will have the information going from left to right. We're going to click on the Page Layout icon at the bottom to show what it will look like.
- 5Now we can see that if we print this, it will have the information going from left to right. In the portrait orientation, the top and bottom are shorter than the sides and the information goes vertically. This is a good idea if we're going to keep adding weeks to our monthly sales figures workbook.
- 6If we want to change this back, we would simply click on "Orientation" again, then click on "Portrait".
- 7Now we can see that the view has changed to the portrait orientation. There 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.
- 8We should always remember to save any changes we make to our workbooks by selecting the save icon which is the floppy disk icon in the upper left-hand corner.
- 9We can also click on "FILE".
- 10Then click on "Save". Another way is to hold the "Ctrl" key and then press the "S" button on the keyboard.
- 11That is how you change the orientation to portrait or landscape in Microsoft Excel 2013. Thank 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.
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
- 1Click on the "PAGE LAYOUT" tab.
- 2Under "Margins" there are some options. We'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.
- 3From there we can select "Normal", which says 1.91cm, 1.78cm for left and Header is set, as well. We can also set this to inches.
- 4Set it for a "Wide" margin, and we can see how it changes here. This would give us a wider margin and not as much room to have our information.
- 5We can go to "Narrow" margin, which would give us more room for our information and less room to have space around that.
- 6We can customize it, as well, which would come in handy when a company is being specific as to what they would want. We would just click on "Custom Margins..."
- 7Then enter the margins manually or click up and down on the arrows to change the margins into what would be needed. That is one way to change margins.
- 8The other place we can do it is in our "Page Setup". We're going to click on the "Page Setup" square in the corner. A box will come up.
- 9We click on the "Margins" tab and again, we can adjust what size we want our margins to be. We can decide if we want it centered horizontally or vertically. It gives us an idea as to what it's going to look like. When we click on the check mark, it gives us a preview.
- 10Once we've done that, simply go to "Print Preview" and it's going to show us what it'll look like when it's printed.
- 11For this particular sales figure sheet, this is what we're going to see on the sheet of paper.
- 12We can also ask it to show the margins so that we can see where they are. I don't normally ask for that, but that is available if we need to see that sort of thing.
- 13That is how you adjust the margins in your workbook using Microsoft Excel 2013. I'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.
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
- 1First, click on "Print Titles" in the "PAGE LAYOUT" tab.
- 2Once the window opens, we have the option to select which rows or columns will repeat. We 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.
- 3We should always remember to save any changes we make to our workbooks by selecting the save icon which is the floppy disk icon in the upper left-hand corner.
- 4We can also click on "FILE".
- 5Then click on "Save". Another way is to hold the "Ctrl" key and then press the "S" button on the keyboard.
- 6That is how you include your title headings for printing purposes when using Microsoft Excel 2013. Thank 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.
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
- 1The first thing we should do is click on the "Page Break Preview" icon in the bottom right-hand corner. This makes it easier to see what we're doing. It will show the area with the information.
- 2Now we need to select the row where we want the page break to be. We can do this with a column as well.
- 3Click on "Breaks" in the "PAGE LAYOUT" tab.
- 4Click on "Insert Page Break".
- 5Now we can see that a new blue line has been created. This means that if we want to print this, the top box will be printed on page 1, and the bottom box will be printed on page 2.
- 6If we zoom in, we can see that it's listed as "Page 1" and "Page 2".
- 7To take that page break away, select the row once again.
- 8Click "Breaks" again and click on "Remove Page Break".
- 9Now page 2 has disappeared. All of this section will be viewed on 1 page. The page numbers will not appear on the printout or PDF, it's just for viewing purposes. We're going to put the break back in. Let's say we want to take a look at the page for printing purposes to see what it would look like.
- 10We would click on "FILE".
- 11Click on "Print" on the left-hand side.
- 12We can see here that it shows page 1 of 2. The top part is the first page.
- 13The bottom part of the page break is the second page. It still says the week numbers because we set it to leave the headers on every page.
- 14We are going to select the row again, click on "Breaks" and click on "Remove Page Break".
- 15If we go back to the print preview, we can see there is only 1 page.
- 16That is how you insert and remove page breaks in Microsoft Excel 2013. Thank you for watching VisiHow. If you have any questions or comments about this video, please feel free to use the comment section below.
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
- 1The first way to create a footer and header is to move the mouse cursor to the bottom right corner of the screen. We have some options there. We need to click on "Page Layout".
- 2In this video, we will zoom in to show a little section.
- 3There is a spot that says "Click to add header" at the top that we can click.
- 4If we move the cursor to the bottom and scroll down, we have a spot where we can click to add a footer, "Click to add footer". That is one easy way to add a header or footer.
- 5We'll go back to the normal view mode by clicking the icon in the bottom-right corner.
- 6Now, the other way we can add a header is to move the cursor over to the ribbon and click the "INSERT" tab.
- 7If we move the cursor over to the right side, we can click the "Header & Footer" area there. This will bring up the design menu.
- 8We can click on the document design menu area.
- 9We type in our header. Let's type "Monthly Sales Figures 2015" for the header.
- 10The header will appear on all of our sheets.
- 11Now, we can add a footer by clicking in the space that says "Click to add footer". We can type "Created by Colette", for example. This will appear in the footer.
- 12The other thing we can do is to insert numbers, if we want to do so. If 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.
- 13If we want to insert the page number, we simply click "Page Number".
- 14The sheet will not show us the number until we click off the cell.
- 15If we want, we can click the footer cell.
- 16We just click "Page Number".
- 17We can type in additional text. We can type "of", for example.
- 18We click "Number of Pages" on the ribbon. The 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.
- 19We can also go to the header or footer and click the "INSERT" tab and insert clip art, designs, or logos that we have created. Then just insert those in the header or footer as well.
- 20Once we have it the way we like it, we can simply click "FILE" and "Print" to preview the spreadsheet. This 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.
- 21We can use our imagination and do it in any way by typing anything in the header or footer. Feel free to explore the menus.
- 22If we do not like anything in the end, we simply click the "Undo" button to cancel the last action.
- 23Always remember to save by moving the cursor over to the menu and click the save icon.
- 24The other way we can do that is by clicking "FILE" and "Save" or "Save As".
- 25We can also hold down "Ctrl" and press "S".
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
