ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do you get different column sizes in one sheet? Excel 2000 (https://www.excelbanter.com/excel-discussion-misc-queries/81547-how-do-you-get-different-column-sizes-one-sheet-excel-2000-a.html)

Margaret

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?

protonLeah

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.
:cool:


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


Gord Dibben

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?




All times are GMT +1. The time now is 12:42 PM.

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