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 colors, 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. 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.Ĭhoose Table > Transpose Rows and Columns (from the Table menu at the top of your screen). Restore an earlier version of a spreadsheet.Save a large spreadsheet as a package file.See the latest activity in a shared spreadsheet.Place objects inside a text box or shape.Format Chinese, Japanese, or Korean text.Use a keyboard shortcut to apply a style.Create, rename, or delete paragraph styles.Bold, italic, underline, and strikethrough.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, donut, 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.
0 kommentar(er)
