Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to adjust the width of a cell and not the entire column
does anyone know how to adjust the width of a cell and not affec the width of
the entire column? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to adjust the width of a cell and not the entire column
This is impossible. You can, however, merge cells to make it seem like the
cell is wider than the column. For example select A1 and B1 and do the following: <Format <Cells... Click on the "Alignment" tab Check "Merge Cells" -- Regards, Dave "gabrie ruz" wrote: does anyone know how to adjust the width of a cell and not affec the width of the entire column? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to adjust the width of a cell and not the entire column
All cells within a column must have the same width. However, you can use
"Merged Cells" to create the appearance of different width cells in a column. Insert a new column adjacent to your existing column. Merge the cells of this new column with your original column for each row that will NOT be a special width. The remaining rows will now appear to have different widths from the others in the column. WARNING: Using merged cells can cause problems with formulas, sorting, and copy/paste actions. HTH, Elkar "gabrie ruz" wrote: does anyone know how to adjust the width of a cell and not affec the width of the entire column? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to adjust the width of a cell and not the entire column
"Thanks thats exactly what i needed...
"David Billigmeier" wrote: This is impossible. You can, however, merge cells to make it seem like the cell is wider than the column. For example select A1 and B1 and do the following: <Format <Cells... Click on the "Alignment" tab Check "Merge Cells" -- Regards, Dave "gabrie ruz" wrote: does anyone know how to adjust the width of a cell and not affec the width of the entire column? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|