Modify Page Layout in Microsoft Excel 2013

Edited by Colette Cole, Catch21chuck, vc, Crystal and 3 others

Ad

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.

Was this helpful? Yes | No | I need help

How to Modify Page Layout in MS Excel 2013 part 1 of 6 layout.mp4-canvas1 04.jpg

Steps

  1. 1
    I 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.
    How to Modify Page Layout in MS Excel 2013 part 1 of 6 layout.mp4-canvas56 320003.jpg
    Advertisement
    Was this step helpful? Yes | No | I need help

  2. 2
    The 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.
    How to Modify Page Layout in MS Excel 2013 part 1 of 6 layout.mp4-canvas73 291.jpg
    Advertisement
    Was this step helpful? Yes | No | I need help

  3. 3
    We 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.
    How to Modify Page Layout in MS Excel 2013 part 1 of 6 layout.mp4-canvas84 900003.jpg
    Was this step helpful? Yes | No | I need help

  4. 4
    While 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.
    How to Modify Page Layout in MS Excel 2013 part 1 of 6 layout.mp4-canvas123 761003.jpg
    Was this step helpful? Yes | No | I need help

  5. 5
    We can click the "-" symbol to zoom out to see what the sheets would look like if they're printed.
    How to Modify Page Layout in MS Excel 2013 part 1 of 6 layout.mp4-canvas133 520003.jpg
    Was this step helpful? Yes | No | I need help

  6. 6
    If we want to get a closer look, we can just click on the "+" symbol and that will give us a better look.
    How to Modify Page Layout in MS Excel 2013 part 1 of 6 layout.mp4-canvas135 900003.jpg
    Was this step helpful? Yes | No | I need help

  7. 7
    We 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.
    How to Modify Page Layout in MS Excel 2013 part 1 of 6 layout.mp4-canvas145 760003.jpg
    Was this step helpful? Yes | No | I need help

  8. 8
    Another 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.
    How to Modify Page Layout in MS Excel 2013 part 1 of 6 layout.mp4-canvas169 068003.jpg
    Was this step helpful? Yes | No | I need help

  9. 9
    We 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.
    How to Modify Page Layout in MS Excel 2013 part 1 of 6 layout.mp4-canvas193 260003.jpg
    Was this step helpful? Yes | No | I need help

  10. 10
    That 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.
    Was this step helpful? Yes | No | I need help

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.

Was this helpful? Yes | No | I need help

How to Modify Page Layout in MS Excel 2013 part 2 of 6 Change Page Orientation1.mp4-canvas0.jpg

Steps

  1. 1
    In 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.
    How to Modify Page Layout in MS Excel 2013 part 2 of 6 Change Page Orientation1.mp4-canvas71 817015.jpg
    Was this step helpful? Yes | No | I need help

  2. 2
    We're going to click on "Orientation".
    Here we will have the option between "Portrait" and "Landscape".
    How to Modify Page Layout in MS Excel 2013 part 2 of 6 Change Page Orientation1.mp4-canvas84 500477.jpg
    Was this step helpful? Yes | No | I need help

  3. 3
    Right now it's on "Portrait", but if we wanted to change it to "Landscape", we would simply click on it.
    How to Modify Page Layout in MS Excel 2013 part 2 of 6 Change Page Orientation1.mp4-canvas92 661133.jpg
    Was this step helpful? Yes | No | I need help

  4. 4
    Now 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.
    How to Modify Page Layout in MS Excel 2013 part 2 of 6 Change Page Orientation1.mp4-canvas123 084564.jpg
    Was this step helpful? Yes | No | I need help

  5. 5
    Now 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.
    How to Modify Page Layout in MS Excel 2013 part 2 of 6 Change Page Orientation1.mp4-canvas168 1108.jpg
    Was this step helpful? Yes | No | I need help

  6. 6
    If we want to change this back, we would simply click on "Orientation" again, then click on "Portrait".
    How to Modify Page Layout in MS Excel 2013 part 2 of 6 Change Page Orientation1.mp4-canvas191 698996.jpg
    Was this step helpful? Yes | No | I need help

  7. 7
    Now 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.
    How to Modify Page Layout in MS Excel 2013 part 2 of 6 Change Page Orientation1.mp4-canvas211 380765.jpg
    Was this step helpful? Yes | No | I need help

  8. 8
    We 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.
    How to Modify Page Layout in MS Excel 2013 part 2 of 6 Change Page Orientation1.mp4-canvas269 244511.jpg
    Was this step helpful? Yes | No | I need help

  9. 9
    We can also click on "FILE".
    How to Modify Page Layout in MS Excel 2013 part 2 of 6 Change Page Orientation1.mp4-canvas274 393335.jpg
    Was this step helpful? Yes | No | I need help

  10. 10
    Then click on "Save".
    Another way is to hold the "Ctrl" key and then press the "S" button on the keyboard.
    How to Modify Page Layout in MS Excel 2013 part 2 of 6 Change Page Orientation1.mp4-canvas276 914198.jpg
    Was this step helpful? Yes | No | I need help

  11. 11
    That 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.
    Was this step helpful? Yes | No | I need help

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.

Was this helpful? Yes | No | I need help

How To Modify Page Layout In Ms Excel 2013 Part 3 Of 6 Adjusting Margins.mp4-canvas158 317019.jpg

Steps

  1. 1
    Click on the "PAGE LAYOUT" tab.
    How To Modify Page Layout In Ms Excel 2013 Part 3 Of 6 Adjusting Margins.mp4-canvas35 195678.jpg
    Was this step helpful? Yes | No | I need help

  2. 2
    Under "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.
    How To Modify Page Layout In Ms Excel 2013 Part 3 Of 6 Adjusting Margins.mp4-canvas41 096678.jpg
    Was this step helpful? Yes | No | I need help

  3. 3
    From 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.
    How To Modify Page Layout In Ms Excel 2013 Part 3 Of 6 Adjusting Margins.mp4-canvas80 459678.jpg
    Was this step helpful? Yes | No | I need help

  4. 4
    Set 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.
    How To Modify Page Layout In Ms Excel 2013 Part 3 Of 6 Adjusting Margins.mp4-canvas103 280678.jpg
    Was this step helpful? Yes | No | I need help

  5. 5
    We can go to "Narrow" margin, which would give us more room for our information and less room to have space around that.
    How To Modify Page Layout In Ms Excel 2013 Part 3 Of 6 Adjusting Margins.mp4-canvas123 522678.jpg
    Was this step helpful? Yes | No | I need help

  6. 6
    We 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..."
    How To Modify Page Layout In Ms Excel 2013 Part 3 Of 6 Adjusting Margins.mp4-canvas124 242678.jpg
    Was this step helpful? Yes | No | I need help

  7. 7
    Then 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.
    How To Modify Page Layout In Ms Excel 2013 Part 3 Of 6 Adjusting Margins.mp4-canvas129 922678.jpg
    Was this step helpful? Yes | No | I need help

  8. 8
    The 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.
    How To Modify Page Layout In Ms Excel 2013 Part 3 Of 6 Adjusting Margins.mp4-canvas158 202678.jpg
    Was this step helpful? Yes | No | I need help

  9. 9
    We 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.
    How To Modify Page Layout In Ms Excel 2013 Part 3 Of 6 Adjusting Margins.mp4-canvas171 682678.jpg
    Was this step helpful? Yes | No | I need help

  10. 10
    Once 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.
    How To Modify Page Layout In Ms Excel 2013 Part 3 Of 6 Adjusting Margins.mp4-canvas191 591678.jpg
    Was this step helpful? Yes | No | I need help

  11. 11
    For this particular sales figure sheet, this is what we're going to see on the sheet of paper.
    How To Modify Page Layout In Ms Excel 2013 Part 3 Of 6 Adjusting Margins.mp4-canvas196 243678.jpg
    Was this step helpful? Yes | No | I need help

  12. 12
    We 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.
    How To Modify Page Layout In Ms Excel 2013 Part 3 Of 6 Adjusting Margins.mp4-canvas207 565678.jpg
    Was this step helpful? Yes | No | I need help

  13. 13
    That 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.
    Was this step helpful? Yes | No | I need help

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.

Was this helpful? Yes | No | I need help

How To Modify Page Layout In Ms Excel 2013 Part 4 Of 6 Title Headings.mp4-canvas0.jpg

Steps

  1. 1
    First, click on "Print Titles" in the "PAGE LAYOUT" tab.
    How To Modify Page Layout In Ms Excel 2013 Part 4 Of 6 Title Headings.mp4-canvas50 525969.jpg
    Was this step helpful? Yes | No | I need help

  2. 2
    Once 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.
    How To Modify Page Layout In Ms Excel 2013 Part 4 Of 6 Title Headings.mp4-canvas147 085861.jpg
    Was this step helpful? Yes | No | I need help

  3. 3
    We 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.
    How To Modify Page Layout In Ms Excel 2013 Part 4 Of 6 Title Headings.mp4-canvas151 99591.jpg
    Was this step helpful? Yes | No | I need help

  4. 4
    We can also click on "FILE".
    How To Modify Page Layout In Ms Excel 2013 Part 4 Of 6 Title Headings.mp4-canvas154 92906.jpg
    Was this step helpful? Yes | No | I need help

  5. 5
    Then click on "Save".
    Another way is to hold the "Ctrl" key and then press the "S" button on the keyboard.
    How To Modify Page Layout In Ms Excel 2013 Part 4 Of 6 Title Headings.mp4-canvas157 030262.jpg
    Was this step helpful? Yes | No | I need help

  6. 6
    That 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.
    Was this step helpful? Yes | No | I need help

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.

Was this helpful? Yes | No | I need help

How To Modify Page Layout In Ms Excel 2015 Part 5 Of 6 Page Breaks.mp4-canvas0.jpg

Steps

  1. 1
    The 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.
    How To Modify Page Layout In Ms Excel 2015 Part 5 Of 6 Page Breaks.mp4-canvas51 77347.jpg
    Was this step helpful? Yes | No | I need help

  2. 2
    Now we need to select the row where we want the page break to be.
    We can do this with a column as well.
    How To Modify Page Layout In Ms Excel 2015 Part 5 Of 6 Page Breaks.mp4-canvas77 486102.jpg
    Was this step helpful? Yes | No | I need help

  3. 3
    Click on "Breaks" in the "PAGE LAYOUT" tab.
    How To Modify Page Layout In Ms Excel 2015 Part 5 Of 6 Page Breaks.mp4-canvas99 186102.jpg
    Was this step helpful? Yes | No | I need help

  4. 4
    Click on "Insert Page Break".
    How To Modify Page Layout In Ms Excel 2015 Part 5 Of 6 Page Breaks.mp4-canvas101 084989.jpg
    Was this step helpful? Yes | No | I need help

  5. 5
    Now 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.
    How To Modify Page Layout In Ms Excel 2015 Part 5 Of 6 Page Breaks.mp4-canvas109 397489.jpg
    Was this step helpful? Yes | No | I need help

  6. 6
    If we zoom in, we can see that it's listed as "Page 1" and "Page 2".
    How To Modify Page Layout In Ms Excel 2015 Part 5 Of 6 Page Breaks.mp4-canvas135 476844.jpg
    Was this step helpful? Yes | No | I need help

  7. 7
    To take that page break away, select the row once again.
    How To Modify Page Layout In Ms Excel 2015 Part 5 Of 6 Page Breaks.mp4-canvas148 024392.jpg
    Was this step helpful? Yes | No | I need help

  8. 8
    Click "Breaks" again and click on "Remove Page Break".
    How To Modify Page Layout In Ms Excel 2015 Part 5 Of 6 Page Breaks.mp4-canvas152 971744.jpg
    Was this step helpful? Yes | No | I need help

  9. 9
    Now 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.
    How To Modify Page Layout In Ms Excel 2015 Part 5 Of 6 Page Breaks.mp4-canvas166 62791.jpg
    Was this step helpful? Yes | No | I need help

  10. 10
    We would click on "FILE".
    How To Modify Page Layout In Ms Excel 2015 Part 5 Of 6 Page Breaks.mp4-canvas214 883076.jpg
    Was this step helpful? Yes | No | I need help

  11. 11
    Click on "Print" on the left-hand side.
    How To Modify Page Layout In Ms Excel 2015 Part 5 Of 6 Page Breaks.mp4-canvas216 819963.jpg
    Was this step helpful? Yes | No | I need help

  12. 12
    We can see here that it shows page 1 of 2.
    The top part is the first page.
    How To Modify Page Layout In Ms Excel 2015 Part 5 Of 6 Page Breaks.mp4-canvas222 477608.jpg
    Was this step helpful? Yes | No | I need help

  13. 13
    The 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.
    How To Modify Page Layout In Ms Excel 2015 Part 5 Of 6 Page Breaks.mp4-canvas235 521147.jpg
    Was this step helpful? Yes | No | I need help

  14. 14
    We are going to select the row again, click on "Breaks" and click on "Remove Page Break".
    How To Modify Page Layout In Ms Excel 2015 Part 5 Of 6 Page Breaks.mp4-canvas253 502677.jpg
    Was this step helpful? Yes | No | I need help

  15. 15
    If we go back to the print preview, we can see there is only 1 page.
    How To Modify Page Layout In Ms Excel 2015 Part 5 Of 6 Page Breaks.mp4-canvas266 69833.jpg
    Was this step helpful? Yes | No | I need help

  16. 16
    That 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.
    Was this step helpful? Yes | No | I need help

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.

Was this helpful? Yes | No | I need help

How To Modify Page Layout In Ms Excel 2013 Part 6 Of 6 Insert Header, Footer And Page Number.mp4-canvas251 646531.jpg

Steps

  1. 1
    The 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".
    How To Modify Page Layout In Ms Excel 2013 Part 6 Of 6 Insert Header, Footer And Page Number.mp4-canvas50 518968.jpg
    Was this step helpful? Yes | No | I need help

  2. 2
    In this video, we will zoom in to show a little section.
    How To Modify Page Layout In Ms Excel 2013 Part 6 Of 6 Insert Header, Footer And Page Number.mp4-canvas60 210102.jpg
    Was this step helpful? Yes | No | I need help

  3. 3
    There is a spot that says "Click to add header" at the top that we can click.
    How To Modify Page Layout In Ms Excel 2013 Part 6 Of 6 Insert Header, Footer And Page Number.mp4-canvas64 704642.jpg
    Was this step helpful? Yes | No | I need help

  4. 4
    If 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.
    How To Modify Page Layout In Ms Excel 2013 Part 6 Of 6 Insert Header, Footer And Page Number.mp4-canvas71 899009.jpg
    Was this step helpful? Yes | No | I need help

  5. 5
    We'll go back to the normal view mode by clicking the icon in the bottom-right corner.
    How To Modify Page Layout In Ms Excel 2013 Part 6 Of 6 Insert Header, Footer And Page Number.mp4-canvas80 161762.jpg
    Was this step helpful? Yes | No | I need help

  6. 6
    Now, the other way we can add a header is to move the cursor over to the ribbon and click the "INSERT" tab.
    How To Modify Page Layout In Ms Excel 2013 Part 6 Of 6 Insert Header, Footer And Page Number.mp4-canvas85 272952.jpg
    Was this step helpful? Yes | No | I need help

  7. 7
    If we move the cursor over to the right side, we can click the "Header & Footer" area there.
    This will bring up the design menu.
    How To Modify Page Layout In Ms Excel 2013 Part 6 Of 6 Insert Header, Footer And Page Number.mp4-canvas90 536312.jpg
    Was this step helpful? Yes | No | I need help

  8. 8
    We can click on the document design menu area.
    How To Modify Page Layout In Ms Excel 2013 Part 6 Of 6 Insert Header, Footer And Page Number.mp4-canvas100 981178.jpg
    Was this step helpful? Yes | No | I need help

  9. 9
    We type in our header.
    Let's type "Monthly Sales Figures 2015" for the header.
    How To Modify Page Layout In Ms Excel 2013 Part 6 Of 6 Insert Header, Footer And Page Number.mp4-canvas103 555264.jpg
    Was this step helpful? Yes | No | I need help

  10. 10
    The header will appear on all of our sheets.
    How To Modify Page Layout In Ms Excel 2013 Part 6 Of 6 Insert Header, Footer And Page Number.mp4-canvas110 500589.jpg
    Was this step helpful? Yes | No | I need help

  11. 11
    Now, 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.
    How To Modify Page Layout In Ms Excel 2013 Part 6 Of 6 Insert Header, Footer And Page Number.mp4-canvas122 915356.jpg
    Was this step helpful? Yes | No | I need help

  12. 12
    The 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.
    How To Modify Page Layout In Ms Excel 2013 Part 6 Of 6 Insert Header, Footer And Page Number.mp4-canvas132 162851.jpg
    Was this step helpful? Yes | No | I need help

  13. 13
    If we want to insert the page number, we simply click "Page Number".
    How To Modify Page Layout In Ms Excel 2013 Part 6 Of 6 Insert Header, Footer And Page Number.mp4-canvas157 571654.jpg
    Was this step helpful? Yes | No | I need help

  14. 14
    The sheet will not show us the number until we click off the cell.
    How To Modify Page Layout In Ms Excel 2013 Part 6 Of 6 Insert Header, Footer And Page Number.mp4-canvas163 214614.jpg
    Was this step helpful? Yes | No | I need help

  15. 15
    If we want, we can click the footer cell.
    How To Modify Page Layout In Ms Excel 2013 Part 6 Of 6 Insert Header, Footer And Page Number.mp4-canvas170 05921.jpg
    Was this step helpful? Yes | No | I need help

  16. 16
    We just click "Page Number".
    How To Modify Page Layout In Ms Excel 2013 Part 6 Of 6 Insert Header, Footer And Page Number.mp4-canvas177 002081.jpg
    Was this step helpful? Yes | No | I need help

  17. 17
    We can type in additional text.
    We can type "of", for example.
    How To Modify Page Layout In Ms Excel 2013 Part 6 Of 6 Insert Header, Footer And Page Number.mp4-canvas178 917641.jpg
    Was this step helpful? Yes | No | I need help

  18. 18
    We 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.
    How To Modify Page Layout In Ms Excel 2013 Part 6 Of 6 Insert Header, Footer And Page Number.mp4-canvas181 221514.jpg
    Was this step helpful? Yes | No | I need help

  19. 19
    We 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.
    How To Modify Page Layout In Ms Excel 2013 Part 6 Of 6 Insert Header, Footer And Page Number.mp4-canvas215 419982.jpg
    Was this step helpful? Yes | No | I need help

  20. 20
    Once 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.
    How To Modify Page Layout In Ms Excel 2013 Part 6 Of 6 Insert Header, Footer And Page Number.mp4-canvas228 635258.jpg
    Was this step helpful? Yes | No | I need help

  21. 21
    We can use our imagination and do it in any way by typing anything in the header or footer.
    Feel free to explore the menus.
    How To Modify Page Layout In Ms Excel 2013 Part 6 Of 6 Insert Header, Footer And Page Number.mp4-canvas255 53512.jpg
    Was this step helpful? Yes | No | I need help

  22. 22
    If we do not like anything in the end, we simply click the "Undo" button to cancel the last action.
    How To Modify Page Layout In Ms Excel 2013 Part 6 Of 6 Insert Header, Footer And Page Number.mp4-canvas259 798961.jpg
    Was this step helpful? Yes | No | I need help

  23. 23
    Always remember to save by moving the cursor over to the menu and click the save icon.
    How To Modify Page Layout In Ms Excel 2013 Part 6 Of 6 Insert Header, Footer And Page Number.mp4-canvas270 542296.jpg
    Was this step helpful? Yes | No | I need help

  24. 24
    The other way we can do that is by clicking "FILE" and "Save" or "Save As".
    How To Modify Page Layout In Ms Excel 2013 Part 6 Of 6 Insert Header, Footer And Page Number.mp4-canvas274 237666.jpg
    Was this step helpful? Yes | No | I need help

  25. 25
    We can also hold down "Ctrl" and press "S".
    How To Modify Page Layout In Ms Excel 2013 Part 6 Of 6 Insert Header, Footer And Page Number.mp4-canvas278 667259.jpg
    Was this step helpful? Yes | No | I need help

    Advertisement

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!

Was this helpful? Yes | No | I need help

Video: Modify Page Layout in Microsoft Excel 2013 Insert Header Footer and Page Number

Comments

VisiHow welcomes all comments. If you do not want to be anonymous, register or log in. It is free.




Creachhigher
Featured Author
34 Articles Started
1,088 Article Edits
6,075 Points
Creachhigher is a featured author with VisiHow. Creachhigher has achieved the level of "Sergeant" with 6,075 points. Creachhigher has started 34 articles (including this one) and has also made 1,088 article edits. 17,300 people have read Creachhigher's article contributions.
Creachhigher's Message Board
Creachhigher: Hi, my name is Creachhigher.
Creachhigher: Can I help you with your problem about "Modify Page Layout in Microsoft Excel 2013"?
 

Article Info

Categories : Windows

Recent edits by: Alexander Avdeev, Eng, Crystal

Share this Article:

Thanks to all authors for creating a page that has been read 466 times.

Do you have a question not answered in this article?
Click here to ask one of the writers of this article
x

Thank Our Volunteer Authors.

Would you like to give back to the community by fixing a spelling mistake? Yes | No