Forum Discussion
Autofit Columns to Data Not Headings
Hello, I have a large table with some long headers, but small data e.g. header = "Suggested Order Quantity", data = single figures. I would like to wrap the text in the headers, and then autofit ...
Thanks, I didn't know you could do that! How is it done?
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!)
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.