Solutions Through Learning
Callback
Sign in
Basket
Call us on 0207 987 3777 or Search our website
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel - all versions
Resolved · Low Priority · Version 2003
Debbie has attended:
Excel Intermediate course
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
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
Mon 1 Jun 2009: Automatically marked as resolved.
|
|
Excel tip:Deleting cells, Rows & columnsplace your cursor on a cell, row number or column letter and use CTRL + -. |
TrustScore
4.9
/ 5
2224 reviews
Connect with us:
We will call you back
Call for assistance
Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
We'll call during UK business hours
Server loaded in 0.07 secs.
