I can’t find a macro that will enable automatically adjusting column and row widths in an excel workbook.
I have found previous macros that will complete this; however, the undo function for instance (control + z) doesn’t function once this macro is enabled.
I actually first contacted Microsoft; here is a link to the discussion forum when I contacted Microsoft representatives:
https://answers.microsoft.com/en-us/msoffice/forum/all/how-to-automatically-adjust-column-widths-in-excel/f88abb8b-7e65-40e6-8a03-83decab25420?messageId=24299486-63c2-4fa7-b693-a6ecd94d576d
CONCLUSION
I am curious about a code that will automatically (and permanently) adjust column AND row widths, and simultaneously, ensure all traditional keyboard shortcuts still function (such as control + Z).
Warias1 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.