Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change the column width in only one cell at a time?
I don't want the column width in the cells above or below to move. I only
want to move the width of one cell at a time. Someone said to right click the cell and choose autofit, but I don't have autofit as a choice. I am using Excel 2003. Cathi |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change the column width in only one cell at a time?
You can only change a column width not the width of individual cells.
"Cathi" wrote: I don't want the column width in the cells above or below to move. I only want to move the width of one cell at a time. Someone said to right click the cell and choose autofit, but I don't have autofit as a choice. I am using Excel 2003. Cathi |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change the column width in only one cell at a time?
Just adjust the column width by moving the mouse to the edge of the column on
the column bar (the bar with the column letters). The mouse will change from a pointer to a line with arrows and will allow you adjust the width of the column "Cathi" wrote: I don't want the column width in the cells above or below to move. I only want to move the width of one cell at a time. Someone said to right click the cell and choose autofit, but I don't have autofit as a choice. I am using Excel 2003. Cathi |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change the column width in only one cell at a time?
if you want to have cells of different sizes, you have to merge multiple
cells. This can allow you to have a cell that is larger than the cell below. I recommend against using the merge cells features, as it disrupts some of the cutting and pasting functionlity, so will become more trouble than benefit. Another way to make the spreadsheet look good is to use the cell boarders and underlines to adjust the format without actually changing the layout of the cells "ExcelGuru" wrote: Just adjust the column width by moving the mouse to the edge of the column on the column bar (the bar with the column letters). The mouse will change from a pointer to a line with arrows and will allow you adjust the width of the column "Cathi" wrote: I don't want the column width in the cells above or below to move. I only want to move the width of one cell at a time. Someone said to right click the cell and choose autofit, but I don't have autofit as a choice. I am using Excel 2003. Cathi |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change the column width in only one cell at a time?
On Jun 14, 12:31 am, ExcelGuru
wrote: if you want to have cells of different sizes, you have to merge multiple cells. This can allow you to have a cell that is larger than the cell below. I recommend against using the merge cells features, as it disrupts some of the cutting and pasting functionlity, so will become more trouble than benefit. Another way to make the spreadsheet look good is to use the cell boarders and underlines to adjust the format without actually changing the layout of the cells "ExcelGuru" wrote: Just adjust the column width by moving the mouse to the edge of the column on the column bar (the bar with the column letters). The mouse will change from a pointer to a line with arrows and will allow you adjust the width of the column "Cathi" wrote: I don't want the column width in the cells above or below to move. I only want to move the width of one cell at a time. Someone said to right click the cell and choose autofit, but I don't have autofit as a choice. I am using Excel 2003. Cathi Another option is to use the "Center across selection" - Select two cells and format cells and select alignment as "Center across selection". This will make the cell look as though it has been merged. it will retain its individual cell properties however. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why can't i change column width? | Excel Discussion (Misc queries) | |||
How to make cell width different than the column width it lies in | Excel Discussion (Misc queries) | |||
Change the width of a column by using a cell reference | Excel Worksheet Functions | |||
Why can't I Change column width? | Excel Discussion (Misc queries) | |||
Change the width of a single column in a column chart | Charts and Charting in Excel |