98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Office general help » Headings
Headings
Resolved · Low Priority · Version 2003
Amanda has attended:
Multiple applications course
Headings
How do you give excel documents headings without effecting the column sizes?
RE: Headings
Hi Amanda, thanks for the query. I'd suggest two ways of doing this. The first would be to turn on Word Wrapping for those columns with headings. Select, say, column A and then click Format-Cells and select the Alignment tab. Make sure the wrap text option is ticked and then click OK. The result should be text which wraps within the cell, but doesn't alter the column width. In the alignment tab, also play with the Orientation dial (by clicking a dragging on the "hand of the watch", this will allow you to put text on its side, should you need to.
Secondly, you can give Excel documents a heading by clicking View-Header and Footer and then Custom Header. What you put in here as a heading will have no impact on column widths - but this is more usually used for general "Client Name" headings.
Hope this helps,
Anthony
Tue 16 Jun 2009: Automatically marked as resolved.
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Microsoft Office tip:Renaming or Deleting Files when Saving or OpeningYou can rename and delete files any time you are using a FILE > OPEN or a FILE > SAVE dialog box. |