Hi,
Is it possible to have Excel automatically adjust a column to the widest width immediately after I move to the next cell?
It's very annoying to enter text and only see part of it until I manually double-click the column line at the top and then review what I entered.
Mike
Hi Mike,
You would need VBA to do this.
HTH
Regards, Jeff
Thank you for the quick reply.
If you want to use VBA
Paste code in a Sheet module
Please Login or Register to view this content.
- Where to paste code
- Highlight macro to copy >> Ctrl + C >> Open your workbook
- Right click on sheet tab >> View Code >> opens the Visual Basic Editor (VBE)
- Ctrl + R >> opens the Project Explorer (if not already open on left side of screen)
- Paste code >> Ctrl + V (right side of screen)
- Alt + Q >> exits VBE and returns to Excel
- Now simply make a change in worksheet
Last edited by jeffreybrown; 10-29-2018 at 10:32 AM.
Awesome jeffreybrown - thank you.
You're welcome. Glad it helped and thanks for the rep+.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks