Formatting

Resolved · Low Priority · Version 2003

Mon 16 Mar 2009, 16:52 Delegate Nathalie said...

Nathalie has attended:
Excel Introduction course
PowerPoint Introduction course

Formatting

How do I clear formatting?

Mon 16 Mar 2009, 16:56 Trainer Rajeev said...

RE: Formatting

Dear Nathalie

Thank you for attending Excel Introduction course!! I hope you enjoyed the course and benefited from it.

To clear the formatting simply select all the cells that you wish to remove the formatting for.

Choose Edit > Clear > Formats from the Menu Bar!

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Mon 23 Mar 2009: Automatically marked as resolved.

Excel tip:

Autofit column width – Excel (all versions)

a. Highlight the column or columns you wish to alter the width of. You do this by clicking on the grey button at the top of the column showing the column letter. Click and drag on these letters to select more than one column.
b. Double click the dividing line between the columns. This dividing line is the break between the columns on the column headers (grey buttons showing the column letter at the top of each column). When you hover your mouse over one of these dividing lines the point will change and show an arrow pulling a line in two directions. When you have this mouse pointer you should double click to get Excel to automatically set the column width to fit the contents of the column (autofit)

View all Excel hints and tips

Formatting

Formatting

RE: Formatting

Excel articles

Excel tip:

Autofit column width – Excel (all versions)