D
Danielle via OfficeKB.com
How do you resize a selection of cells, not in a table or chart, without
having to resize the entire worksheet?
Thank you
having to resize the entire worksheet?
Thank you
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Resizing cells in a selection without resizing entire sheet
T
tim m
hilite the selection and then just use format column width and row height.
C
Chris
Danielle,
Select just the cells you want to resize and you can either do 1)
Format => Row => Height or Column => Width or 2) Drag one of the
highlighted rows or columns to resize and the rest will follow.
Chris
Select just the cells you want to resize and you can either do 1)
Format => Row => Height or Column => Width or 2) Drag one of the
highlighted rows or columns to resize and the rest will follow.
Chris
D
Danielle via OfficeKB.com
I'm sorry, I wasn't very clear. I need to resize only a certain section
cells about half way down the page, but when I try to resize the ways you've
suggested, it only allows to resize the entire column or entire row.
cells about half way down the page, but when I try to resize the ways you've
suggested, it only allows to resize the entire column or entire row.
G
Gord Dibben
Danielle
Row heights and column widths are properties of the row and column.
You cannot have different sizes for each range.
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.
They do have their purpose, I guess<g>
Gord Dibben MS Excel MVP
Row heights and column widths are properties of the row and column.
You cannot have different sizes for each range.
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.
They do have their purpose, I guess<g>
Gord Dibben MS Excel MVP