Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Margaret
 
Posts: n/a
Default How do you get different column sizes in one sheet? Excel 2000

Want to have different column sizes on the same page/sheet.
Anyone help with how to do this in Excel 2000?
  #2   Report Post  
Posted to microsoft.public.excel.misc
protonLeah
 
Posts: n/a
Default How do you get different column sizes in one sheet? Excel 2000


1) Put the cursor on the desired column indicator, "D" for example:
2) Move cursor slowly to the right until the cross becomes a vertical
bar crossed by a double arrowhead.
3) Left click, hold and drag to the desired width.
- OR -
Put the cursor anywhere in the selected column.
MenubarFormatcolumnWidth, choose a number, say 25 or more.



--
protonLeah
------------------------------------------------------------------------
protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097
View this thread: http://www.excelforum.com/showthread...hreadid=529878

  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default How do you get different column sizes in one sheet? Excel 2000

Margaret

Individual column widths can be set simply by selecting the column and
FormatColumnWidth or by dragging on the column indicator line.

If you wish to have different widths in a single column, this is not possible
without merging cells.

I hesitate to recommend the merging of cells due to problems that can be caused
when copying, pasting, sorting and other functions.


Gord Dibben MS Excel MVP

On Tue, 4 Apr 2006 19:38:01 -0700, Margaret
wrote:

Want to have different column sizes on the same page/sheet.
Anyone help with how to do this in Excel 2000?


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
consolidation of tables in excel with text and figures samenvoegen van sheets Excel Worksheet Functions 8 March 2nd 06 03:27 PM
Combining data from cells from several excel sheets to a new sheet Rik Excel Discussion (Misc queries) 4 February 22nd 06 09:16 AM
Positioning Numeric Values Resulting from 6 Column Array Formula Sam via OfficeKB.com Excel Worksheet Functions 2 January 5th 06 02:03 AM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Excel 2000 - Column labels for forms Abay New Users to Excel 2 August 23rd 05 02:23 AM


All times are GMT +1. The time now is 03:19 AM.

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

About Us

"It's about Microsoft Excel"