Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JoChain
 
Posts: n/a
Default Can individual cell boundaries be changed?

As an example, I want ONLY cell D22 to be narrower than all cells around it.
I haven't found a way to do it or if it's possible. There are no cell
contents to manipulate at this point. It is just an empty cell that I want
maybe half the size of those around it. To make the entire column narrower
would alter the contents of cells above cell D22 and I don't want this.
Thanks for your help.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elkar
 
Posts: n/a
Default Can individual cell boundaries be changed?

The short answer to your question is No, all cells in a column must have the
same width.

However, there is a way around this by using Merged Cells. Add a new column
to the right of column D (or use E if it isn't already in use). Merge cells
D1 and E1, D2 and E2, D3 and E3 etc., etc., etc... but don't merge D22 and
E22. This will in effect give you a new column D with just cell D22
remaining smaller.

By getting creative with adding and merging several columns and rows its
possible to create an entire sheet that looks like all cells are individually
sized.

HTH,
Elkar

"JoChain" wrote:

As an example, I want ONLY cell D22 to be narrower than all cells around it.
I haven't found a way to do it or if it's possible. There are no cell
contents to manipulate at this point. It is just an empty cell that I want
maybe half the size of those around it. To make the entire column narrower
would alter the contents of cells above cell D22 and I don't want this.
Thanks for your help.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default Can individual cell boundaries be changed?

Hi!

You can't set the width or height of an individual cell. Each cell in a row
or column must be the same dimensions.

The only thing you could do is to merge cells but this usually leads to
other problems that you didn't anticipate when you merged the cells.

Biff

"JoChain" wrote in message
...
As an example, I want ONLY cell D22 to be narrower than all cells around
it.
I haven't found a way to do it or if it's possible. There are no cell
contents to manipulate at this point. It is just an empty cell that I
want
maybe half the size of those around it. To make the entire column
narrower
would alter the contents of cells above cell D22 and I don't want this.
Thanks for your help.



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
How circle an individual number in a cell? Chet Excel Worksheet Functions 3 January 27th 06 12:39 AM
if cell has been changed... user Excel Worksheet Functions 2 January 11th 06 08:18 PM
Cell color based upon cell value My View Excel Discussion (Misc queries) 11 July 6th 05 03:59 AM
cell color index comparison MINAL ZUNKE New Users to Excel 1 June 30th 05 07:11 AM
Warn when a cell value has changed LesLdh Excel Worksheet Functions 6 February 16th 05 07:19 PM


All times are GMT +1. The time now is 05:18 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"