Can I make all columns the same?

Asked By Wayne A Mukai 10 points N/A Posted 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.

• Status: Open
• Question Views: 514
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Darry Hunt 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!

About Darry Hunt

Questions
0

Answers
100

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 04/30/2015
• Question Category: MS Excel