Your rows and columns will go back to their original locations. If you decide you want to revert the transposition on either Mac or iOS, just follow the same steps to access and select the Transpose Rows and Columns option. Open the Numbers app on your iPhone or iPad and access the spreadsheet you want to change.ġ) Like on Mac, select the table by tapping on it.Ģ) Tap the circle on the upper left corner of the table.ģ) The Table Actions button will display at the bottom in green.Ĥ) Tap that button and select Transpose Rows and Columns. Transposing rows and columns in Numbers on iPhone and iPad Your spreadsheet will automatically update reflecting this change. The transpose tool will not be clickable unless your table is selected by clicking on it. Pop open Numbers on your Mac and open the spreadsheet you want to change.ġ) Select the table. Transposing rows and columns in Numbers on Mac Here’s how to transpose rows and columns in Numbers with just a couple of clicks. But, you no longer have to do that and it’s even easier than the method in Microsoft Excel. This used to be a tedious task of sorts because you had to insert a formula.

You might want to convert your rows to columns or vice versa. So, when you are working with your spreadsheet data, you may decide part of the way through that you want to format that sheet differently.

Numbers has tons of templates to get you started, hundreds of functions you can use, methods for collaboration, and so much more. If Numbers is your spreadsheet application of choice, then you likely know about its terrific features.

Numbers for mac help