Can I make all columns the same?

Asked By 10 points N/A Posted on -
qa-featured

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.

  • Answer Accepted: No
  • Question Category:
SHARE
Answered By 0 points N/A #177595

Can I make all columns the same?

qa-featured
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!
About Darry Hunt
Questions
0
Answers
100
Best Answers
0
  • Posted on -
  • Question Category:

What is the process for using pivot table?

Previous

Inserting a picture into Excel

Next

Related Questions