How do I change a single cell size in a spreadsheet
Home > IT Answers > Microsoft Windows > How do I change a single cell size in a sprea...
Cat100
5 pts.
0
Q:
How do I change a single cell size in a spreadsheet
Microsoft Excel, Excel Formatting
I have a spreadsheet and i have set column widths. I would like to change one cell in that spreadsheet without changing the width of all of the rest of the sheet. Is this possible? Also, is there a way to set the page sizes seperately i.e. page 1 legal, page 2 letter
ASKED: Apr 15 2009  6:39 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Philpl1jb
24610 pts.
0
A:
 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0
  • AddThis Social Bookmark Button
When you change the size of a cell, you will necessary change the width of the complete column or the height of the complete row, or both. There is no way to change the size of a cell without affecting other cells.

If you want to change the width/height of a single row or column, just right click the row/column header, and select 'column width' or 'row height' as needed.

I don't think you can set different page sizes in a single document. You can use the 'page break' preview to adjust the page breaks, and excel will adjust the text size as needed to comply with it, but the page size will be the same for the whole sheet.

***********
You can also go to the topmost cell and "drag" the right line over to make that one cell column wider or on the leftmost cell drag the bottom line down to make that one cell row taller. But Carlos is right you can't just change a single cell.

////////////////////////////////////////////
You can merge cells - effectively making the size of a single cell seem wider as in two columns or three columns wide.

Demo: Highlight cells b2-d2
Format
Cells
Alignment
Merge Cells

Phil
Last Answered: Apr 15 2009  9:09 PM GMT by Philpl1jb   24610 pts.
Latest Contributors: Technochic   40210 pts., Carlosdl   29855 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Mshen   23535 pts.  |   Apr 16 2009  3:01AM GMT

I think you will get the best result from merging cells

 

Lakerbrat82   10 pts.  |   Nov 2 2009  5:15PM GMT

I think what you are trying to do is called MERGING CELLS. Try this:

Select the cells that you wish to merge. Right-click and then select “Format Cells” from the popup menu.

When the Format Cells window appears, select the Alignment tab. Check the “Merge cells” checkbox.

Now when you return to the spreadsheet, you will find your selected cells merged into a single cell.

Source:  <a href="http://www.techonthenet.com/excel/cells/merge_cells.php" title="http://www.techonthenet.com/excel/cells/merge_cells.php" target="_blank">http://www.techonthenet.com/excel/cells/…</a>

 
0