How do I change a single cell size in a spreadsheet

5 pts.
Tags:
Excel Formatting
Microsoft Excel
Microsoft 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 separately i.e. page 1 legal, page 2 letter?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • mshen
    I think you will get the best result from merging cells
    27,385 pointsBadges:
    report
  • Lakerbrat82
    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: http://www.techonthenet.com/excel/cells/merge_cells.php
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following