ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Format Entire Sheet Column Widths How? (https://www.excelbanter.com/excel-programming/376509-format-entire-sheet-column-widths-how.html)

Corey

Format Entire Sheet Column Widths How?
 
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



Otto Moehrbach

Format Entire Sheet Column Widths How?
 
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
"Corey" wrote in message
...
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





All times are GMT +1. The time now is 11:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com