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.
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.
Posted by: Richard Chapman | June 11, 2007 at 08:34 PM
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.
Posted by: JZA | June 12, 2007 at 03:10 PM
Hi JZA,
Feel free to translate this article as long as you link to this blog as well.
Solveig
Posted by: Solveig | June 15, 2007 at 10:03 AM
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.
Posted by: tower defence | March 30, 2009 at 06:50 AM