Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Cell Size?
I'm trying to change the height and width of "one" cell, without changing the
size of the row and column that it falls within (ex: I want to change the size of cell "C3", but I don't want to change the size of cells "C1,C2,C4,etc." nor the size of cell "A3,B3,D3,etc."... is there a way to do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Cell Size?
Not sure what is wanted.
Selected C3:D3 and use the Merge & Center tool best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "excelhelp" wrote in message ... I'm trying to change the height and width of "one" cell, without changing the size of the row and column that it falls within (ex: I want to change the size of cell "C3", but I don't want to change the size of cells "C1,C2,C4,etc." nor the size of cell "A3,B3,D3,etc."... is there a way to do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Cell Size?
Thank you for your help... I understand how to merge cells, but I want each
cell to have its own height and width without affecting the entire row or column "Bernard Liengme" wrote: Not sure what is wanted. Selected C3:D3 and use the Merge & Center tool best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "excelhelp" wrote in message ... I'm trying to change the height and width of "one" cell, without changing the size of the row and column that it falls within (ex: I want to change the size of cell "C3", but I don't want to change the size of cells "C1,C2,C4,etc." nor the size of cell "A3,B3,D3,etc."... is there a way to do this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Cell Size?
No way to do this without....shudder.......merging two or more cells.
But if you merge C3 and D3 you won't have a D3 anymore. If you merge C3 and C4.......no C4 anymore. So, back to line 1..........no way. Gord Dibben MS Excel MVP On Wed, 17 Jan 2007 15:26:00 -0800, excelhelp wrote: I'm trying to change the height and width of "one" cell, without changing the size of the row and column that it falls within (ex: I want to change the size of cell "C3", but I don't want to change the size of cells "C1,C2,C4,etc." nor the size of cell "A3,B3,D3,etc."... is there a way to do this? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Cell Size?
Simple. Can't be done. The width of a column and the height of a row must
be the same. It is a bit of dilemma in presentation when trying to fit information onto a page. Is your problem viewing information on the screen without having to scroll up / down / left / right? You could try 'wrapping' text (<Format<Cells). This will reduce the width of an over-long column (at the expense of increasing the height of the row). Another trick is to reduce the font size. A reduction of 0.5 might be just enough to reduce the area without having too much of a visual effect. Sometimes changing from 'portrait to 'landscape' is all that is necessary. If the problem is getting information onto a printed page you could also try reducing the margins. All these measures help to shoe-horn information. If, however you have a lot of information it may need a re-think, re-design. Regards. Bill Ridgeway Computer Solutions "excelhelp" wrote in message ... I'm trying to change the height and width of "one" cell, without changing the size of the row and column that it falls within (ex: I want to change the size of cell "C3", but I don't want to change the size of cells "C1,C2,C4,etc." nor the size of cell "A3,B3,D3,etc."... is there a way to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert date | Excel Worksheet Functions | |||
Single Cell change size | Excel Discussion (Misc queries) | |||
change cell size from page to page on the same worksheet | Excel Worksheet Functions | |||
change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) | |||
conditional cell shading when a change occurs | Excel Discussion (Misc queries) |