I've been talking about using the Navigator in Writer. Here are a few ways to use the Navigator in OpenOffice.org Calc spreadsheets.
Press F5, and you'll see the Navigator. It's got sections for the different standard things you might want to look for. I'm going over the navigation items this time rather than the dragging and database items.
Click the graphic to see a bigger version.
If you have a lot of sheets, you might prefer to switch between using the Navigator's list. Just double-click on a sheet to go to that sheet.
This is just a way to name a particular range of one or more cells. To create the ranges, just select the cells and choose Insert > Names > Define. Name the range (no spaces) and click OK.
Then when you doubleclick the name in the Navigator, you'll go to that range.
Notes, Charts, Graphics, Drawing Objects, Etc.
Insert a note under Insert > Note.
Insert a chart under Insert > Chart.
Insert a graphic under Insert > Picture > From File.
Insert a drawing object by using the toolbar under View > Toolbars > Drawing.
Then the items you insert show up in the Navigator. Double-click any item listed to go to it.