To make certain records repeatably easy to go to select the record or range of cells and use Insert\Name\define to give that record a recognisable "label"
Repeat this procedure for each record (perhaps when you enter the data in the first place).
When you next need to go to a particular record use the Name Box at the top left of the worksheet and select the record of your choice.
This method works across sheets in the same workbook so you can easily jumps from say cell A1 of the first worksheet in a book to the final cell in the final worksheet of the workbook.

If you are more concerned with listing records or areas of a workbook in a pick list try creating a front sheet showing all of your linked records or areas as follows:
Insert a blank worksheet at the front of your workbook.
Change the cells to your preferred colour (not blue or purple).
At a convenient position (cell) enter text by which you want to refer to your record.
Return the cursor to the cell containing your new text.
Press Ctrl+k keys
You may be prompted to save the file before proceeding.
In the bottom of the two available fields in the Link dialogue window add the text: sheet3!c5
The resultant link would take the user to sheet 3 cell reference C5. If you had a sheet named Accounts and wished to send the user to cell A15 you would use the text: accounts!A15
Alternatively, if you have used names to refer to your records (as mentioned previously) you could simply add the name in this window.
Selecting OK will save the link in the cell, notice how the text changes to blue and underlined.
By changing the colour of the cells in the first place you can make the front sheet look like your 'splash' screen or form and even add your name as author in say the bottom left of the screen

Suppose you have all the figures you need but every time you try to add the text to the cells to the left or right you just can't quite get the spacing right, so all the results look more like a table. What if you could put the formula in the middle of your conclusion paragraph so it all looks like a nice neat statement or report?
Type the following in any cell:

      ="There are "&24*60&" Minutes in a day and "&24*60*7&" minutes in a week. In a week there are also "&24*60*7*60&" seconds."

The result to this formula should read:

      There are 1440 Minutes in a day and 10080 minutes in a week. In a week there are also 604800 seconds.

If the sums "24*60" and "24*60*7" etcetera were placed in different cells you could replace the sums in the original formula with the cell references.

Before you start this you will need to use Visual Basic editing to complete this tip, but don't worry. The steps are all outlined.
Excel spreadsheets, not so hot on the sorting and filtering unless you are familiar with auto-filter. How's about if you make it easier for your user to just type a name in and then push a button to return all the relevant records. Looks pretty trick on ANY spreadsheet. Here's how:
Starting with a new blank sheet insert a listing in cells I20 to J300. I have used two columns made up of name and tel number.
From the menu bar select Tools\Macro\Macros.
In 'Macro Name' type a new name for your Macro (I used MyFilter), make sure the 'Macros in:' is set to 'This workbook'
Select 'Create'
In the subsequent Visual Basic Editor window type the following text between 'Sub MyFilter()' and 'End Sub'

Close the visual basic window.

Note that at the start of the code we are sending the user to cell referenced by R11C4, this equates to cell D11. Hence, this is where our search text will be.
The line 'Range("J19").Select' sends the cursor position to cell J19 in readiness for moving the window.
The next three lines scroll the window such that J19 is the top left hand cell of the current window.

To position a button on the screen next to the search cell:
Activate the Forms toolbar by selecting View\Toolbars\Forms
From the forms toolbar select the Button Icon and draw a button on the spreadsheet.
In the subsequent dialogue windows make the button activate your new macro.
Once selected you can change the text on the front of your button.

Try it out by typing text into the cell D11 then pressing your new button.

All well and good but how do you get back to where you were, i.e. up at cell D11?

Remove the autofilter by selecting Data\Filter and make sure Auto Filter is not checked.
You could repeat the macro creation process but for a new macro called StopFilter.
This time between the 'Sub StopFilter()' and 'End Sub' type the following text:

The first line unchecks the AutoFilter and the second line sends the user to cell referenced by R11C4, i.e. D11
Now add a new button over cell J19, assign your StopFilter macro to it and label it Clear Filter.

Go to top of page

If you have a particular problem in Excel please feel free to submit a question using the feedback form and we will try and publish the result asap.   Go to feedback form page