EXCEL print large wide spreadsheet sideways and continuously


  1. Posts : 11,246
    Windows / Linux : Arch Linux
       #1

    EXCEL print large wide spreadsheet sideways and continuously


    Hi folks

    Anybody know how to get EXCEL (2019) I'm using but any version from 2007 should also be the same - to be able to print a spreadsheet with many columns "Sideways" - In other words the columns will be rotated by 90 degrees decently with out headers page breaks etc.

    What I want basically is say for example a spreadsheet that needs 2 pages for its width but 500 lines long page 1 --- cols A-W with headings and data entries for ist part of the sheet
    then cols X-whatever for page 2 with their headings

    then page 3 - continuation of columns A-W with no headings
    page 4 continuation of col X-?? with no headings -- and so on until 500 lines printed (or whatever the data size is).

    I used to be able to do this years ago on a dot Matrix printer simply with its spreadsheet program on an old PC running MSDOS-- print sideways was an option and it just did it.

    I'm struggling to get EXCEL to do this.

    when I'm done I want to be able to paste the spreadsheet together so it just looks like a "normal" but extra wide spreadsheet i.e displayed as a single ultra wide spreadsheet -- just one set of headers and then all the data sheets.

    Why this is so difficult to do I don't know - or is it just me.


    so on the project display wall it would be:

    headers -----------------------------------------------------------------------------say 50 columns (page 1)
    data on that page for 50 columns ----------------------------------------------------- (page 1 still)
    then (no headers etc) data data data ------------------------------------------------------- next 20 pages

    Cheers
    jimbo
      My Computer


  2. Posts : 2,450
    Windows 10 Pro x64
       #2

    Hey Jimbo,

    If I understand correctly what you want to accomplish, regarding headings don't add the first row to repeat in each page. As for the 2 or more pages with continued columns, I think it can be set (as the columns headings) in Page Setup/Sheet tab, change the Page order to Over, then down.
      My Computer


  3. Posts : 17,049
    Windows 10 Home x64 Version 22H2 Build 19045.4170
       #3

    In the page layout tab, Page setup group:
    [or in the Page setup dialog of Print preview:]
    Page orientation - Landscape
    Sheet - Page order - Over then down.

    And then all you have to check are the other factors such as clearing Header/Footer, Print titles {aka Rows to repeat at top}.

    Denis
      My Computer


  4. Posts : 1,323
    Windows 11 Pro 64-bit
       #4

    Hi Jimbo,

    In the Excel print setup you can try:
    - print selection + fit sheet on one page, in case the total sheet column is larger than 50, you select till 50 columns.
    OR
    - print entire sheet (if that's 50 columns and ok) + fit sheet on one page.

    Check the preview and do a few tests using a PDF / virtual printer, wasting paper is no longer an issue with these tools.
    EXCEL print large  wide spreadsheet sideways and continuously-excel.png
      My Computers


  5. Posts : 1,323
    Windows 11 Pro 64-bit
       #5

    Fit all columns on one page gives best result:
    the rest of the pages have no header; but then 50 columns is the entire length you have; 70 columns will print 70 columns, no less.
    EXCEL print large  wide spreadsheet sideways and continuously-excel2.png
      My Computers


  6. Posts : 1,323
    Windows 11 Pro 64-bit
       #6

    Ah, darn it, I have the column option shown, you need rows... my apologies.
    Fit all rows will loop horizontally then but it needs fixed row count, so I guess it's just like what I shown with the columns but on the rows. The number of shown columns depends on formatting and chosen page size.

    As you said, there is difficulty on these options since it will not always produce what we need.
    Hope someone experienced enough with excel can get it going, worst case via macro / VB script or something.
      My Computers


  7. Posts : 17,049
    Windows 10 Home x64 Version 22H2 Build 19045.4170
       #7

    Hopachi said:
    Hope someone experienced enough with excel can get it going, worst case via macro / VB script or something.
    There is no need for any scripting. The existing print options in the Page layout tab, Page setup group can be set to achieve everything that the OP requires, as explained in post #3.

    Denis
      My Computer


  8. Posts : 1,323
    Windows 11 Pro 64-bit
       #8

    Try3 said:
    There is no need for any scripting. The existing print options in the Page layout tab, Page setup group can be set to achieve everything that the OP requires, as explained in post #3.Denis
    Thank you for this.
    I never actually used the page setup options before, in my basic excel usage.
    'Fit to X wide by Y tall' option opened my eyes.
      My Computers


  9. Posts : 17,049
    Windows 10 Home x64 Version 22H2 Build 19045.4170
       #9

    jimbo45 said:
    … print a spreadsheet with many columns "Sideways" ...
    If you meant that you wanted to transpose the rows & columns then this would be better prepared beforehand on an additional worksheet so that you can set up its formatting.

    I have found that the easiest way of transposing an entire worksheet is to create the new blank sheet, select the required area of the original then on the new sheet use Paste special, Transpose. Then sort out the formatting.

    There is also the Transpose function which would be well suited for long term re-use. The online Transpose - Excel Help page for this is, I think, quite decently explained.

    Denis
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 05:35.
Find Us




Windows 10 Forums