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

microsoft excel course - list

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel course - List

microsoft excel course - List

ResolvedVersion Standard

Ben has attended:
Excel Intermediate course
PowerPoint Intermediate Advanced course

List

How do i de-activate a list?

RE: List

Hi Ben,

Thanks for the question.

If you mean the AutoFilter, with the little arrows and dropdown lists, you can take it off by going into the Data menu and down to Filter and click AutoFilter.

Ta

Tracy

Excel tip:

Separate the year from a date

To separate the year from a date use the =year() function, eg a date is in cell A1 and in A2 you wish to display the year enter the function =year(A1)

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