excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

Excel

resolvedResolved · Low Priority · Version 2007

Chris has attended:
Excel Advanced course

Excel

How do you clear formats?

RE: Excel

Hi Chris
You can clear all the formats of a cell by using the Home Ribbon - Editing Group. Select the icon that looks like a rubber and choose Clear Formats.

Best wishes
Tanya

Sat 31 Jul 2010: Automatically marked as resolved.


 

Excel tip:

Quickly hide and unhide rows and columns

Use the keyboard shortcut Ctrl+9 to hide selected rows and Ctrl+0 to hide selected columns. The good thing about this shortcut is that you do not need to select entire rows or columns. For example, select B3:D3 then press Ctrl+0 to hide columns B to D.

Ctrl+Shift+9 unhides rows and Ctrl+Shift+0 unhides columns.

View all Excel hints and tips


Server loaded in 0.1 secs.