Forum home » Delegate support and help forum » Microsoft Excel Training and help » Advanced formatting

Advanced formatting

ResolvedVersion 2003

Mon 28 Jul 2008, 16:30 Delegate Niamh said...

Niamh has attended:
Excel Intermediate course

Advanced formatting

How to wrap text in th Format cells option

Tue 29 Jul 2008, 10:40 Trainer Pete said...

RE: Advanced formatting

Hi Naimh,

Thank you for your post, welcome to the forum;

Wrapping text within the width of a cell, follow these steps:
Select the column to be affected. (Click on the column header ie A,B,C or which ever column) Go to Format>Cells, select the Alignment Tab and check the box Wrap Text.

I hope that has answered your question, regards Pete

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Conditional formatting for cells that return text , not picked up by Go to command

If you have tried to format all cells containing text even those that display text as a result of a formula you may have had difficulty. As Go to command with constant selected does not pick up formulas that result in text.

Then try this. Select the range the formula cells appear in on your sheet. Format, select Conditional Formatting menu. In the dialog box under Condition 1, select "Formula Is" from drop down. Next to it in the Formula Box, enter the formula =Istext(A1. Click Format button , choose desired formatting settings and click OK. To go ahead and apply the conditional formatting click OK to accept

View all Excel hints and tips

Advanced formatting

Advanced formatting

RE: Advanced formatting

Excel articles

Excel tip:

Conditional formatting for cells that return text , not picked up by Go to command