Using the Navigator to get around in an OpenOffice Calc spreadsheet

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.

Switching Sheets
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.

Range Names
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.

---

---

Comments

[Richard Chapman]

Thanks. That's a handy tip. I plan to experiment with these little gems so that I'll at least know they exist when the time comes for them to make my life easier.

[JZA]

Excellent article I want to know if you content is Creative Commons since I want to republish it in spanish for the OOoES community.

I am not a Spreadsheet power user and even if I know this tools as a OOo community guy I really don't see the exploit of all this features working together.

[Solveig]

Hi JZA,

Feel free to translate this article as long as you link to this blog as well.

Solveig

[tower defence]

That's a handy tip. I plan to experiment with these little gems so that I'll at least know they exist when the time comes for them to make my life easier.