N/APosted on - 04/20/2015
I'm using an Excel spreadsheet, and I need to make all the columns the same size on multiple tabs. I know I can go in and change the column width on each individual column, but that will take me a long time. Is there a way that I can just do one tab and transfer it over to every tab on the spreadsheet? Thank you.
Can I make all columns the same?
Follow these steps in order.
Click on sheet tab (right click there and select all sheets if necessary) >> go to home tab >> select the Format option from Cells group >> cell size >> default width >> insert the preferred column width >> ok
Further more, you can simply adjust the column boundaries with mouse drags.