Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 358
Default change the width of a specific cell

Halo
i would like to change the width but for only 3 specific cells and not to
the entire column , how i can do it?

Thanks in advance
Andrew
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 618
Default change the width of a specific cell

"andrew" wrote in message
...
Halo
i would like to change the width but for only 3 specific cells and not to
the entire column , how i can do it?


You can't.
--
David Biddulph


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default change the width of a specific cell

While it is true that you can't change the width of any cells without
changing the width of the entire column, you can achieve the effect you are
looking for by merging two or more cells. By inserting additional columns and
merging cells, you can pretty much control the width of any cell.



"andrew" wrote:

Halo
i would like to change the width but for only 3 specific cells and not to
the entire column , how i can do it?

Thanks in advance
Andrew

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default change the width of a specific cell

Andrew

Row heights and column widths are properties of the row and column and cannot be
changed throughout.

My fingers are shaking and my heart is racing as I type the following.........

You could use the Merge Cells option and merge several cells together
horizontally or vertically.

Merged cells can cause no end of problems with copying, pasting, filtering,
sorting and a few others I can't think of right now.

They do have their purpose, I guess<g


Gord Dibben MS Excel MVP

On Fri, 13 Oct 2006 00:40:02 -0700, andrew
wrote:

Halo
i would like to change the width but for only 3 specific cells and not to
the entire column , how i can do it?

Thanks in advance
Andrew


Gord Dibben MS Excel MVP
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
change cell color to red & then green when value change in 2 cel Innswood Excel Discussion (Misc queries) 0 July 24th 06 05:07 AM
insert date Larry Excel Worksheet Functions 28 July 15th 06 02:41 AM
Specific cell change for copied sheets..? Olle Svensson Excel Discussion (Misc queries) 1 March 10th 06 11:28 PM
conditional cell shading when a change occurs zooeyhall Excel Discussion (Misc queries) 1 June 6th 05 05:14 PM
Highlight a row if a specific cell is specific numbers/words sea0221 Excel Worksheet Functions 2 March 9th 05 01:06 AM


All times are GMT +1. The time now is 11:55 AM.

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"