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 >

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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

Posted on Nov 29, 2012 4:44 PM

Reply
Question marked as Best reply

Posted on Nov 29, 2012 4:52 PM

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:

User uploaded file




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.

7 replies
Question marked as Best reply

Nov 29, 2012 4:52 PM in response to BlueintheBlood

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:

User uploaded file




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.

Nov 23, 2016 11:20 PM in response to waggerwoo1

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.

User uploaded file

Are you expecting something like this?

User uploaded file

Possible, but kind of ugly, and it requires using two tables.


Regards,

Barry

Dec 5, 2016 12:07 AM in response to chchchScott

"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?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.