I have a workbook with a ton of sheets, but they all have the same headers. I am wondering if I can somehow make the column widths all the same as the first sheet without having to go through and manually adjust each column. There are a lot of columns and a lot of sheets, so it would be a lot easier to do it automatically.
Right-click on the first sheet tab and select "Select All Sheets"
Make your column adjustments on that first sheet.
Then right-click on the tab again and select "Ungroup Sheets"
The column width should be the same in all sheets now.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks