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).
0 kommentar(er)
