Forum Discussion
Autofit Columns to Data Not Headings
How about re-orienting the headers as shown here?
Just out of curiosity, how many columns are there in this sheet? I'm wondering about whether a different design altogether might be in order
There are 45 columns and about 4-5k rows of data. We will never be able to see it all in one page but the most important data is near the start (The users asked for all these columns otherwise I would leave many out!)
Thanks, I didn't know you could do that! How is it done?
It's done by using the menu under Format....Cells...Alignment
(Presumably that's where you set it to "Wrap text"--just another of the choices. Off there in the top right corner, you can set the angle of the text)
There's another feature, and I think it might be useful (if you're not aware of it). You can freeze the header rows so they always appear even as you scroll down the screen toward the bottom of the table. Similarly, if applicable, you can freeze the left-most column. It's all there under the "View" toolbar. Off to the right in this screen capture.