headings

Forum home » Delegate support and help forum » Microsoft Office general help » Headings

Headings

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Microsoft Office tip:

Renaming or Deleting Files when Saving or Opening

You can rename and delete files any time you are using a FILE > OPEN or a FILE > SAVE dialog box.
When you see the list of files when browsing in the current folder, you can treat is just like the windows explorer window, by selecting and then editing.

To rename, just give the file a single click to select, then a second to enter the file name. Type the name you want, and press enter.

To delete, a single click and hit the delete key.

View all Microsoft Office hints and tips


Server loaded in 0.05 secs.