Can I make all columns the same?

Asked By 10 points N/A Posted on -

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.

Answered By 0 points N/A #177595

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.

Best Regards!

Login/Register to Answer

Related Questions