ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to adjust the width of a cell and not the entire column (https://www.excelbanter.com/excel-discussion-misc-queries/102970-how-adjust-width-cell-not-entire-column.html)

gabrie ruz

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?


David Billigmeier

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?


Elkar

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?


gabrie ruz

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?



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

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