Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formatting

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Formatting

Resolved · Low Priority · Version 2007

Reply Tue 13 Jan 2009, 16:58Delegate Nick said...

Nick has attended:
Excel Intermediate course
Excel Advanced course
Powerpoint Intermediate Advanced course

Formatting

How do you remove conditional formatting?

For upcoming training course dates see: Pricing & availability

Reply Wed 14 Jan 2009, 16:13Trainer Amanda said...

RE: Formatting

Hello Nick

Thank you for your question, and welcome to the forum.

To remove conditional formatting:

1. If removing formatting from only a certain collection of cells, then select that area of the spreadsheet. If you want the formatting removed from the whole sheet, you don't need to select anything.

2. Click on the Conditional Formatting button in the Styles group of the Home ribbon.

3. Select Clear Rules and then make an additional selection based on what the conditional formatting should be removed from.

Kind regards
Amanda

Reply Wed 14 Jan 2009, 16:17Delegate Nick said...

RE: Formatting

Thanks Amanda, I enjoyed the course and found it very helpful, already been using IF function today and tables!

Reply Wed 14 Jan 2009, 16:24Trainer Amanda said...

RE: Formatting

Hi Nick

Great, I'm glad you have been able to use some of what you've learned straight away. Should you have any other questions relating to what we covered on the training course, please feel free to post further questions on the forum.

Kind regards
Amanda

Excel articles

· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Reasons Why VBA for Excel Training Fails
· From the Classroom to the Corporate World
· Reporting and Analysis with Excel
· Plug Into The Big Grid

Please browse our web site to find out more about
advanced excel courses and other Microsoft training courses.

Excel tip:

Multiple Lines of Text in a Cell

As an alternative to the Text Wrapping facility, type a word or two, press Alt+Enter to get a new line, type more text, and continue the process for as many lines as you need. Enter as normal when you have finished.

The line break is not affected by changing the column width, as text wrapping. To remove this you must edit the cell and remove the invisible character and replace with a normal space.

View all Excel hints and tips