Debbie has attended:
Excel Intermediate course
Excel - all versions
When working with a spreadhseet, I like to expand the columns so that the full wording of the headings and cell content below can be viewed.
I currently click on the right-hand side of each heading cell in turn but believe there is a way to make all columns are expanded simultaneously. Please explain how I can do this.
Thank you,
Debbie
RE: Excel - all versions
hi Debbie
Thanks for your question
To auto size all columns you must first select the entire sheet. To do this click the click the "button" that lies at the extreme top left of the worksheet; immediately to the left of column label A and above row number 1.
You can then auto size the whole sheet by auto sizing any of the individual columns
Hope this helps
Regards
Stephen
