Windows 10: 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

:)

 

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?

 

Printing a spreadsheet

Hi Deborah. I'm Greg, an installation specialist and 9 year Windows MVP, here to help you.

See these guides to print Excel spreadsheets:

https://www.makeuseof.com/tag/excel-secrets-dis...

http://www.gorainmaker.com/rainmaker/quick-tip-...

How to Print an Excel Spreadsheet like a Pro [8 Actionable Tips]

I hope this helps. Feel free to ask back any questions and let us know how it goes. I will keep working with you until it's resolved.

 

Printing a spreadsheet

Will work on this in the morning when I am more fresh. Thanks so much for responding.