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

excel autofill

ResolvedVersion 2003

Yuan has attended:
Excel Advanced course

Excel Autofill

What is custom autofill in excel?

RE: Excel Autofill

Hi Yuan,

Thank you for your question.

If you mean what is custom Autofilter, then it is used if you want to filter out multiple results from an Excel list based on criteria set for a particular field heading. E.g. you want all the people who live in the counties of Hampshire or Berkshire.

I hope this answers your question.

Regards

Simon

Excel tip:

Change the Value of a Constant

When using a named constant in a worksheet, you may wish to change the value of that constant.

From the 'Insert' menu, select 'Name', then select 'Define'.

In the 'Define Name' dialog box, select the constant that you want to change.
Change the value in the 'Refers To' box.
Click OK.

Wherever that named constant has been used it will now use its new value.

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.14 secs.