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

excel courses in london - formattimg

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel courses in london - Formattimg

excel courses in london - Formattimg

ResolvedVersion Standard

Della has attended:
Excel Intermediate course

Formattimg

How do I format cells?

RE: Formattimg

Hi Della,
Thanks for your question, to format a single cell or a range of cells, select (highlight) the cells you wish to format, then choose the menu command Format, Cells, from the dialog box which opens you can choose to apply formatting to the cell/s from any of the options available.
For quick formatting select the cell or cells and choose from the formatting options available on the Formatting Toolbar.

Excel tip:

Autonumber in Excel

To create an autonumber field, can use the Offset() function.

In cell A1, enter the number 1.
Then in cell A2, enter this formula:

=OFFSET(A2,-1,0)+1

Then copy the formula from cell A2, down as far as you need.

See also: Autonumber in Excel forum post.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.