Hi,
I've been quite interested in keyboard shortcuts lately.
Amazing how fast you get with these.
Now I know quite a lot, but there's one I never could find:
How to adjust automatically the width of a column?
(Same as when you double click with the mouse on edges of column headers to fit them, but without the mouse).
Thanks a lot.
Select the range that contains data in the desired column to be auto-adjusted.
Now press Alt + H
Leave the keys.
Now press O and then finally I.
Last edited by sourabhg98; 02-23-2016 at 12:55 PM.
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks