#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default New bar

Id like to adjust culumn width for a bunch of new information...I could just
go to a new page in the workbook, but id like to have all the info on a
single page...to be more clear...the row at the top of a workbook page that
has labeld columns (A B C D E etc) Id like to have 2 (or more) of these on
the same sheet...
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,480
Default New bar

Hi

Hover your cursor over the intersection between 2 columns until you see a
double sided arrow.
At this point hold down the left mouse button and drag the cursor to the
left to narrow the column or to the right to widen the column.

Alternatively FormatcolumnColumn Widthenter a value for the width you
want each column to be.

--

Regards
Roger Govier

"Leprichon" wrote in message
...
Id like to adjust culumn width for a bunch of new information...I could
just
go to a new page in the workbook, but id like to have all the info on a
single page...to be more clear...the row at the top of a workbook page
that
has labeld columns (A B C D E etc) Id like to have 2 (or more) of these on
the same sheet...


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default New bar

This is not possible.

One set of columns and rows per worksheet is all you're allowed.

Row heights and column widths are properties of the entire columns and rows.

You could take a picture of data on another worksheet with different column
width then paste into your original worksheet.

If you use the Camera Tool the pasted picture wil be dynamic.


Gord Dibben MS Excel MVP


On Tue, 8 Jan 2008 16:51:01 -0800, Leprichon
wrote:

Id like to adjust culumn width for a bunch of new information...I could just
go to a new page in the workbook, but id like to have all the info on a
single page...to be more clear...the row at the top of a workbook page that
has labeld columns (A B C D E etc) Id like to have 2 (or more) of these on
the same sheet...


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



All times are GMT +1. The time now is 01:15 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"