It might not seem wildly useful to be able to search for data in a spreadsheet, especially if your spreadsheet is small.

However, spreadsheets can grow to many hundreds (and even thousands) of cells.  Finding someone«s name in the spreadsheet which contains the names of all students doing this course can be very timeconsuming - especially if you need to do it hundreds of times.

Excel allows us to search for cells which contain given data.  Here«s how:

First, press CTRL+F  This brings up the search dialog box.

Then enter the text (or number etc) you«re looking for.

Finally, click "Find Next".

Notice that you have some say over how Excel must search, such as where to look, whether or not to match case and so on.

search 

 

Searching for data
Home
Revision
Functions (1)
Functions (2)
Editing
Charting
Customize