Warnings indicate any formulas that can’t be updated. Many formulas and functions update automatically when they’re transposed. Sort and filter rules are discarded, and a linked form is unlinked, if transposing results in a table that’s not a valid form. In a few cases, transposing unmerges merged header row cells. Merged cells transpose normally, unless they’re in the header row. The table style and custom style changes you made are preserved, including alternating row colours, gridline settings, table and cell outlines, cell and text style, conditional highlights, hidden rows and columns, and so on.Ĭhart data references update so charts reference the same data, even after it’s transposed. Header rows become header columns and footer rows become the rightmost columns. Rows and columns resize to the default height and width for the table. Tap in the bottom-right corner of the screen, then tap Transpose Rows and Columns. Tap the table, then tap in its top-left corner. Note: If a table provides the source data for a pivot table in your spreadsheet, or if the table is in a spreadsheet that’s shared with others, the table can’t be transposed. Restore an earlier version of a spreadsheet.See the latest activity in a shared spreadsheet.Place objects inside a text box or shape.Format Chinese, Japanese or Korean text.Make characters superscript or subscript.Format a spreadsheet for another language.Select text and place the insertion point.Change the look of chart text and labels.Add a legend, gridlines and other markings.Add column, bar, line, area, pie, doughnut and radar charts.Calculate values using data in table cells.Quickly calculate a sum, average and more.

View the source data for a pivot table value.Change how pivot table data is sorted, grouped and more.Add calculations to summarise group data.Add tickboxes and other controls to cells.Use VoiceOver to create formulas and autofill cells.Intro to images, charts and other objects.

Change excel columns to rows