Forum Discussion
horizontal excel table
hello everyone, tables are by default vertical, i.e. headers are in the columns and the values come below them (top to bottom). How can I insert a table with headers in one column and values inpu...
Just wanted to throw in how much I would like it if tables could be sideways, whenever I want. I can see how everything thinks of Columns as letters and Rows as numbers, so things like formulas would likely need TLC to support the feature. Not sure again on limit for number of rows vs limit for number of columns.
With special limits and product design checkmates out of the conversation, it does seem like a sideways table should be no big deal. I do use Copy > Paste special: Transpose often and it is good for letting me compare some things side by side. Particularly anything in PowerShell where I'd like to be able to do Format-List, but see all the different objects side-by-side - this is that functionality in Excel.