Format Entire Sheet Column Widths How?

C

Corey

I need to have an entire worksheet formatted to specific column widths(But
not the same).
I can manually do 1 page formatting, but is there a way to code the entire
sheet to be the same widths?



Regards

Corey
 
O

Otto Moehrbach

You say "not the same widths". Then you ask how to set all columns to the
same width. To do all columns to the same width, click on the small
rectangle immediately above the 1 of the row numbers. This selects the
whole sheet. Now do Format - Column - Width and set the width you want.
HTH Otto
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adjusting row heights and column widths to align with another sheet 1
Determine width of entire visible area and width of labels 2
Column Width Problem 8
VBA code for copying part of a sheet to another, with column widthsand formats 1
Copy Column Width 1
Copy Excel Sheet to another sheet and preserve formatting? 4
Data Validation Pop-downs 3
different formats on one sheet 1

Top