Multiple row resizing or automatic height fit

Question

Level 1

5 points

Multiple row resizing or automatic height fit

Hi,

I have just opened a very simple excel file in Numbers. The workbook consists of only 1 sheet and one table with 3 columns and around 30 rows; is just a list. The problem is that, when I Opened, the text didn't fit the height of the rows, so I had to manually change the row heigh.

Is there any way to change the heigh of multiple rows or just something like the "autoFit" feature in excel?

iPad, Other OS, iPad wifi 16G

Posted on Jun 22, 2010 6:11 AM

Reply

Answer 1

jaxjason

Level 5

5,063 points

Jun 22, 2010 6:17 AM in response to Gsmrules

I am not sure if this is what your asking or not, but if you select a single column or row, then use the little blue dot to extend the selection. now you can grab the right/bottom edge where you see the gripper markings and you can change the width/height of all the selected columns/rows.

Autofit for columns is not there (That I can find it). but rows are automatically autofit in height. If you have some text that wraps in the cell, if you make the column wide enough, you will notice that all the rows get smaller in height to fir the unwrapped text.

Hope this is even close to what your asking 🙂

Jason

Reply

Answer 2

May 8, 2013 7:12 AM in response to Gsmrules

All you have to do is type Command-A to highlight the entire document. Then, hover your cursor on the far far left column where the numbers appear automatically in the dark grey column. Hover your cursor over any line between any two numbers, and you will see that the cursor turns into a line with an up and down arrow. Now, here is the trick. Quickly "double-click". This will auto-adjust the column height of every row in the entire document.

Problem Solved.

Reply

Answer 3

May 9, 2013 6:09 AM in response to Taylor Richards

Did you check the date of this thread? Its almost three years old.
The topic is Numbers for iOS (iPad, iPhone). What you are recomending does not apply.

Reply

Answer 4

Gsmrules Author

Level 1

5 points

Jun 22, 2010 7:56 AM in response to jaxjason

Excellent, this is just what i needed.

Thanks!

Reply

Answer 5

Sep 19, 2013 8:05 AM in response to Taylor Richards

You're awesome.

Reply