page layout

  1. O

    Automatic line break instead of moving to next page

    Hi, I am writing a manual in Excel using the page layout view. Some of my instructions are long so the text goes across pages. Instead of using wrapping and merging cells when this happens, is there a setting I can use in Excel instead?
  2. M

    Freeze Unfreeze not available 2016

    Running Office Home and Student 2016 I have a spreadsheet in which months ago I locked (froze?) the top few rows so they'd stay visible as I scrolled down. Now I'd like to add some rows to that and I can find no way to do this. The Freeze Pane icon is grayed out. The workbook is NOT...
  3. D

    Excel print page misses first column

    Hi guys! i made a macros that sorts people's names. it has 2 columns, the names, and the desk number. however, when i go to print it, the print space doesnt include the first column, only shows the desk space column. and the first page that prints is blank. to fix it, i have to go to page layout...
  4. P

    mm grid, column width, row height

    1) Is there any excel 2013 template out there with which it is possible to print a millimeter grid on an A4-sheet of paper? 2) Is it possible in that grid from question 1 to match an (x,y) position on the excel screen with an (x,y) position on an A4-sheet of paper? 3) Can the column width and...
  5. D

    Page Setup and TSPrint

    Hi, sorry if this has been addressed before, but I need help with an issue one of our users is having. She cannot amend the page layout on spreadsheets that she receives. I've read that this may be an issue in regard to not having printers installed, however, she has TSPrint installed as she is...
  6. S

    How to control number of rows printed per page?

    How can I set the number of rows to print per page? I may vary the row height for legibility but want to control the exact number of rows that will be printed on a page (i.e. maximum). I don't want to set page breaks manually.
  7. W

    Resize only one page (tab) in a workbook

    I have a workbook with most pages 8.5x11. I have one sheet that I need to resize 11x17. When I change the size of the one page, all other pages do the same. How can I change just one page or one tab section of a workbook?
  8. J

    Page Layout view differs from print preview

    Hi, Is there a reason why what you see/the order of things in Page Layout view is not what actually will print? I'm creating a survey form in Excel and encounter the following discrepancy: I type a long text in some cell, say A29. In Page Layout View it stretches to to cell L29 but does not...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top