Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,090
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to set number format for the entire excel sheet CodeKracker Excel Worksheet Functions 0 March 25th 08 07:01 PM
Can a column have different widths on the same sheet? Patrick Setting up and Configuration of Excel 1 October 27th 06 01:06 AM
Set column widths to match specified sheet Sean Bartleet Excel Programming 3 November 15th 05 11:58 AM
copy a sheet with all formats - column widths, etc? Rich Excel Programming 2 April 26th 05 09:10 PM
Maintaining Column Widths in CSV Format File John Boris Excel Programming 1 October 24th 03 10:36 PM


All times are GMT +1. The time now is 07:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"