excel training courses - how autoformat excel

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training courses - How to autoformat in Excel 2007

excel training courses - How to autoformat in Excel 2007

resolvedResolved · Low Priority · Version Standard

Jenny has attended:
Excel Introduction course
Excel Intermediate course

How to autoformat in Excel 2007

How to autoformat in excel 2007

RE: How to autoformat in excel 2007

Hi Jenny,

To apply the new AutoFormat style to cells in your spreadsheet, simply select the desired cells. Click the Home tab on the ribbon. Click on the Cell Styles option on the ribbon to open the Cell Styles gallery. Then on the new style name at the top of the gallery. The style's formatting is immediately applied to the selected cells.

Hope that helps

Tracy

 

Training courses

 

Training information:

See also:

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.


 

Excel tip:

Quickly create a list of numbers

The fill handle in Excel has many uses. If a number is typed into a cell and then the fill handle is used, the number will be copied from one cell to the next.

If you wish to create a list of numbers that increment by one at a time, hold down Ctrl in conjunction with using the fill handle - this should give you a series of numbers (e.g. 1, 2, 3 etc) rather than copying a single number.

View all Excel hints and tips


Server loaded in 0.08 secs.