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
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
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
