excel training courses - How to autoformat in Excel 2007

Resolved · Low Priority · Version Standard

Tue 10 Jul 2007, 16:33 Delegate Jenny said...

Jenny has attended:
Excel Introduction course
Excel Intermediate course

How to autoformat in Excel 2007

How to autoformat in excel 2007

Mon 23 Jul 2007, 10:43 Trainer Tracy said...

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

	98.8 % recommend us
	More live stats...

Training information:

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