How do you format cell size in numbers for multiple cells at the same time?
How do you format the cell size of multiple cells at once in numbers?
MacBook Pro, OS X Mountain Lion (10.8.2), numbers
Want to highlight a helpful answer? Upvote!
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
How do you format the cell size of multiple cells at once in numbers?
MacBook Pro, OS X Mountain Lion (10.8.2), numbers
select the cells you want to format by clicking at the top-left most cell, then shift click the bottom-right most cell.
Then open the inspector by selecting the menu item "View > Show Inspector", then click the table inspector segment:
now use the row height and column width fields to adjust as needed.
You can also select multiple rows and columns by clicking in an active tables row/column header, then dragging to select rows (or column), then hover the cursor on the line the separates rows (or columns) until the cursor changes to a bar with arrows, then click, hold, and drag as needed.
select the cells you want to format by clicking at the top-left most cell, then shift click the bottom-right most cell.
Then open the inspector by selecting the menu item "View > Show Inspector", then click the table inspector segment:
now use the row height and column width fields to adjust as needed.
You can also select multiple rows and columns by clicking in an active tables row/column header, then dragging to select rows (or column), then hover the cursor on the line the separates rows (or columns) until the cursor changes to a bar with arrows, then click, hold, and drag as needed.
Hi When I use the instructions i select my four cells open inspector try to reduce the four cells and the whole column reduces.
Hi ww,
Yes it does. A column is the same width from top to bottom. A row is the same height from side to side of the table. If you reduce the height of four cells in a row, that will reduce the height of the whole row. If you reduce the width of those four cells, that will reduce the width of those four columns.
Are you expecting something like this?
Possible, but kind of ugly, and it requires using two tables.
Regards,
Barry
"You can come up with all kinds of sizes my Merging cells and changing column/row sizes"
True, but generally that advice here has been to avoid merging cells as doing so can cause unexpected difficulties with the table. If what you want is a static display, it will probably work. If you plan to sort the table, hide some rows or columns, or use some functions in formulas on the table, don't merge or split cells.
Regards,
Barry
How do you format cell size in numbers for multiple cells at the same time?