Shrinking lots of coulumns and enlarging text | Excel forum

Resolved · Low Priority · Version 2003

Wed 8 Apr 2009, 16:10 Delegate Kerry said...

Kerry has attended:
Excel Introduction course
Excel Intermediate course

Shrinking lots of coulumns and enlarging text

Eg if you have 50+ columns and only 3 rows, is there a way to get this printed on to an A3 sheet at a readable size... i hope that makes sense

Thu 9 Apr 2009, 14:59 Trainer Amanda said...

RE: shrinking lots of coulumns and enlarging text

Hello Kerry

Thank you for your question and welcome to the forum.

What I would suggest is changing the page setup settings to try to get as much on one page as possible...so for example, change your paper size to A3, then make your margins smaller, remove any data you might have in the header or footer, change the orientation to landscape and also play around with the scaling.

Kind regards
Amanda

Wed 15 Apr 2009, 13:46 Trainer Rajeev said...

RE: shrinking lots of coulumns and enlarging text

Dear Kerry

Thank you for your question!
In addition to what my colleague has suggested I believe it also depends on how much data is in each column. I mean that may be you can adjust the column width.

Another alternative solution to this could be to use copy and paste special and chose the transpose. This feature makes your columns to rows and Rows to column. Again this all depends on how much data you have in each cell. If there is too much data in each cell you may think of using a Wrap text feature in Format > Cells... in the Alignment tab.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT