Efficient Navigation in Excel Workbooks
When I saw the signs in this shop window, I laughed, and snapped this picture.
How confused are your customers, if you need a sign that says, "This is the door", and another sign that points to the door handle?
Later, I realized that it’s not a customer problem – it’s a design problem. A substantial number of people had trouble finding the handle, which looks more like a box. And I don’t remember exactly what the front of the store looked like, but the door must have been hard to identify too.
How about your Excel workbooks – are they easy to understand and navigate? I’ll admit that some of the spreadsheets I’ve built might have similar navigation problems. I’ve added arrows that point to data entry cells, and text boxes with user instructions. Not much different from that door!
Navigating a Workbook
What can you do to make Excel navigation easier?
On a large worksheet, you can add a menu at the top of the sheet, linking to the sections below.
If users can enter data on some sheets, group all the data entry cells in one area, and use colour coding, to make the cells easy to identify.
Worksheet Design Resources
Where do you get your worksheet design ideas? From your own experiments? From sample workbooks that you’ve found online? Somewhere else?
Even though it’s focused on web site design, rather than spreadsheets, I found plenty to think about in Don’t Make Me Think, by Steve Krug.
There are good tips in Professional Excel Development, by Rob Bovey, et al.
What books or other resources would you recommend?