Numbers for iPad: Working with Rows and Columns in Spreadsheets on iPad

For the Complete book, App Your Way to Numbers, visit www.YourMacHelpers.com/Books
The basic elements of a spreadsheet are rows and columns. What you use rows and columns for will be determined by what data you are entering. Once your data has been entered, you may need to change the size and width of your spreadsheet. This can be done in a couple of different ways. Numbers makes it easy to add and hide rows and columns and also adjust the total size and width of the spreadsheet to fit your needs. Make a spreadsheet big or small.
If you find you have run out of room to add elements to your spreadsheet or you want a separate page with a different spreadsheet simply add an additional sheet to your project. This is found by tapping the ( + ) located on the top left of the project. Tapping this will add an additional sheet or form creating a more in depth spreadsheet.
Once you have some data in your rows and columns you may want to add some extra detail or adjust the formatting. This could be things like changing the entire row or columns text alignment, size or font, or even changing the color of the entire row or column. This is done by selecting the entire row(s) or column(s) and using the paint brush tool.
For the Complete book, App Your Way to Numbers, visit www.YourMacHelpers.com/Books OR to ask specific questions go to www.YourMacHelpers.com/Help

[@sharonspringman9861]

Thank you so much for this video. It is well explained for those new to Numbers or refresher for those who haven’t done a formatting for some time…

[@rismsalsabil]

Thank you for the tutorial. Tbis help me to freeze row 😊

[@Lana-ro6cb]

Thanks a million, Happy New Year. Bless you 🥳🥂🥂

[@tinmanjc]

I like your videos. There are a lot of people making videos that irritate me, going off on tangents and pause frequently. Yours are concise and to the point and you don't waste time getting your point across. Just a tip on this particular video where you delete columns or rows, that you can select the = in the corners to crop out unneeded cells. I also like that you have a series of videos and they are organized, consistent and progress at a good pace. Thanks!

[@Bobo-jy5mg]

How do you only unhide a single row though and not all of them…?

[@neelamshinde4273]

Can you help me I trying to shift horizontally to one cell to other through keyboard but I am unable to do so its just toggles on the upper function ribbon how to make it work in the sheet for cell shift?

[@abdulsathart5302]

Nice and informative.
I have a question as to how to manipulate the size of a sheet in my iPhone or iPad ?

[@nixypixels6440]

I just love your intro music! I want my computer to play that on startup! Anyway! Thanks so much for the awesome vid! :-)

[@nadinewench7850]

Hi

[@jwes029]

Thanks, for the video... I really needed to see how to freeze headers and columns but didn't know the menu command I was looking for till I saw your video

[@YourMacHelpers]

***** Great! Glad it was helpful!

[@lawrencediggs7957]

How does one move columns and rows in Mac Numbers?

[@ajcomposer2517]

If your columns are currently different widths and you want them to all become the same width, is there a way to accomplish this without manually resizing each column? In the Mac OS version, you can specify an exact measurement and all of the highlighted columns or rows will snap to this measurement. I’m having a terribly difficult time figuring out how to do this in the iOS version.

[@alejandromerli]

I would love to know how to make a multi selection of cells that are not close to each other. Same as in windows you press crl and click on the cells. Is there any special way to do it in numbers. Thanks

[@yqma1964]

How to adjust the columns using pts?

[@nyk3334]

After resizing a row, how do you make it repeat so every row is the same size and you're not manually doing it for every row? Thanks.

[@YourMacHelpers]

Ricky Bachman , Once you resize one row or column, every time you drag from the top right of the spreadsheet or bottom left to add more rows/colmumns, the new rows and columns should automatically match the same size.
Does that help?

[@nyk3334]

Very kind to respond. I'll have to check. Thanks.

[@emil3711]

Can you change the border color?

[@robodog8435]

G