Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 176
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 964
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
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



All times are GMT +1. The time now is 05:37 PM.

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"