Software

Ask something
Discussion Locked

NAVIGATING A SPREADSHEET

0 helpful
5 replies

by teddy64

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am working on a Ms-Excel 97 spreadsheet contain employee absentism records. I would like to move to a particular employee information by entering either the Personnel number or surname at the top of the spreadsheet to make dayta entry easy. Whatis the easiest way to achieve this?

5 replies

by brian

A fairly easy way to get this type of functionality quickly and easily is to use DATA/Filter/AUTOFILTER
Each Column can then be filtered by using the drop down arrow on right side of the title.

You can jump by pressing the first number or letterof the name you are wanting to filter on.

So if you select the surname range and choose auto filter. It will place a filer only on that column.

You can also choose advanced filters, there is more info in the help system.

This discussion is closed to new replies.