Windows 10: EXCEL print large wide spreadsheet sideways and continuously

Discus and support EXCEL print large wide spreadsheet sideways and continuously in Microsoft Office and 365 to solve the problem; 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... Discussion in 'Microsoft Office and 365' started by jimbo45, Nov 27, 2020.

  1. jimbo45 Win User

    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

    :)
     
    jimbo45, Nov 27, 2020
    #1
  2. PatSzweda Win User

    PRINTING LABEL IN WORD FROM AN EXCEL SPREADSHEET

    We are trying to print labels in word from a spreadsheet in Excel. We have tried copying the spreadsheet to a recipient list but can not get it to work. Is there a way to import the spreadsheet and not retype the information?
     
    PatSzweda, Nov 27, 2020
    #2
  3. Greg Carmack - MVP, Nov 27, 2020
    #3
  4. EXCEL print large wide spreadsheet sideways and continuously

    Printing a spreadsheet

    Will work on this in the morning when I am more fresh. Thanks so much for responding.
     
    DeborahDavis4, Nov 27, 2020
    #4
Thema:

EXCEL print large wide spreadsheet sideways and continuously

Loading...
  1. EXCEL print large wide spreadsheet sideways and continuously - Similar Threads - EXCEL print large

  2. Cant print Excel Spreadsheet after Windows Update - HP0323DD HP Officejet 6600

    in Windows 10 Drivers and Hardware
    Cant print Excel Spreadsheet after Windows Update - HP0323DD HP Officejet 6600: Error Message is Your file could not be print due to an error on HP0323DD HP Officejet 6600 on Eo2. There are several possible reasons: There may not be enough memory available If you use a network for printing, there may be a problem with the network connection. There...
  3. Excel Printing Question

    in Microsoft Office and 365
    Excel Printing Question: I downloaded a Excel chart to keep track of my blood pressure and it is only 1 page. Is there a way to get the same page to print on both sides of the paper in Excel or a way to save it as 2 pages. 151605
  4. Excel spreadsheet prints ONLY gridlines and NOT font or numbers in cells

    in Windows 10 Network and Sharing
    Excel spreadsheet prints ONLY gridlines and NOT font or numbers in cells: When I'm trying to print a spreadsheet with gridlines, all the prints out are the gridlines and none of the font or numbers. I've tried everything like copying to another spreadsheet, checking to make sure all is well in print preview & even tried printing it in Word, and...
  5. Excel Spreadsheet

    in Windows 10 BSOD Crashes and Debugging
    Excel Spreadsheet: A simple xlsm spreadsheet suddenly stopped loading. Clicking on the icon to load, and alternatively clicking on the file itself, the green EXCEL screen shows, It asks to update links, answer as previously is Dont update, then the screen remains blank and nothing happens....
  6. Can't open some excel spreadsheets

    in Windows 10 BSOD Crashes and Debugging
    Can't open some excel spreadsheets: I have Windows 10 and I recently installed Publisher onto my computer now I cannot open some spreadsheets. I don't get any type of error message they just won't open....
  7. Excel spreadsheets open blank.

    in Microsoft Office and 365
    Excel spreadsheets open blank.: Recently my Excel programs began to open with a blank Excel screen. I can go to Open in the blank sheet and open the spreadsheet from there. This happening on my Dell Latitude E5500 Laptop. This has been working fine for years. My PC is opening my Excel spreadsheets...
  8. Printing a spreadsheet

    in Windows 10 Drivers and Hardware
    Printing a spreadsheet: I can print anything EXCEPT an EXCEL spreadsheet. Please help me print the spreadsheet. https://answers.microsoft.com/en-us/windows/forum/all/printing-a-spreadsheet/cd3f68eb-3bb0-4c5c-9988-5aae170554fc
  9. BSOD Usually happens when using Excel spreadsheet.

    in Windows 10 BSOD Crashes and Debugging
    BSOD Usually happens when using Excel spreadsheet.: Hello, I've been experiencing BSOD over the past month. Just ignored as it was random but i've now realised that it's usually happening when I'm using Excel. I have attached the dump files following the instructions on the forum. I've tried to use the debugging tool...
  10. Excel spreadsheet prints differently than what is on screen.

    in Microsoft Office and 365
    Excel spreadsheet prints differently than what is on screen.: I keep my checkbook on an Excel spreadsheet. I have a balance column that I use formulas =sum(A1:A6) etc to keep a running balance. Everything looks fine on the spreadsheet. But when I ask for a print preview those cells it show the formula rather than the amounts. What...