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

excell

ResolvedVersion 2003

Maryouan has attended:
Excel Introduction course
Word Introduction course
Outlook Introduction course

Excell

How can I extract data from a list

RE: Excell

Hi Maryouan,

Thank you for your question.

You can extract data from an Excel list by using Autofilter.

To access this feature, go to Data - Autofilter.

Filter buttons will appear alongside your column headings and you can use these to filter data.

I hope this answers your question.

Regards

Simon

Excel tip:

Paste a web address into the hyperlink address field

If you copy a web address the only way to paste into the address field of the hyperlink box is to use CTRL + V. Right click paste does not work.

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.