Nobody likes to open an Excel e-mail attachment with 30 tabs. While navigation may not be the most essential component of a spreadsheet’s functionality, it is should be considered the anchor of good spreadsheet design.
Part 1 the Spreadsheet Design series focuses on navigation. The emphasis spreadsheet developers should put on navigation depends on the scope and size of their project. Large and complex Excel applications should have robust navigation features, showing users precisely where they are and how to move around the application. Smaller Excel applications may require only simple cues to direct users around a dashboard or data entry form.
While there is no agreed upon consensus on how spreadsheet navigation should be implemented, a good approach may be to mimic desktop software and web-based applications. Given that users are already familiar with web-based navigation standards, implementation in your Excel application will provide users with some familiarity.
As a first step, visit websites you frequently use — think about what you find useful and efficient about their menu setups. Take a look and ask yourself what you like about them, or maybe dislike about them. Can the setups be mimicked in Excel? Another approach is to visit a number of web-design blogs and guides to research web-based design and navigation concepts.
While there are varying opinions on how to implement proper navigation, there seems to be a few consistent themes among most articles and examples. Some of these themes are as follows:
It should be consistent.
Consistency has become the most important rule for website navigation since the mid-2000s. By providing consistent menus and features throughout a website—usually through a horizontal menu at the top of a page—users can access every top-level page within the website, regardless of which page they are currently viewing. Excel’s built in spreadsheet tabs–at the bottom of every Excel file in a toolbar–provide consistency, but the tab toolbar has many drawbacks from a proper design perspective. These drawbacks will be discussed later in the series.
Any alternative to tabs is to have a “home” page or Workbook table of contents. While this may work better in some situations, it’s important to provide the user with consistent methods of navigating to and from the contents page.
The user should always know where they are.
Using the website analogy once again, most web users will have multiple websites in one session through multiple browser tabs or windows. They may later return to a pre-loaded site and will require a visual cue to tell them where they left off. Visual cues through titles or menu highlights can tell users where they are within a site.
Within an Excel application, this can serve two purposes. First, for robust applications with multiple dashboards and data entry forms, a visual cue will quickly remind the user which screen they are looking at. Second, for applications that require multiple data sources and calculation criteria, visual cues can provide guidance as to where they are in the process and remind them what steps are needed to finalize the output.
Ensure that content is properly classified.
Navigation titles and cues should be specific enough to let a user know what part of the application they are going to. This can be better explained by providing an example of what not to do. If a navigation menu contains a link for “Settings”, and another for “Options”, it may not be obvious to the user where to go to, for say, to change screen size or other application attributes. Make sure any top level navigation options will be clear to first time users.
Provide consistent visuals and layout.
This rule is important both in terms of general layout and navigation — it is important that users see a consistent layout and design standards throughout your Excel application. This helps provide familiarity with features and ease of use. Attributes like width of content or theme colors are essential for providing consistent visuals.
The following navigation exercises provide three methods of developing a horizontal menu bars. While other navigation methods to exist, the menu bar is the most effective approach for addressing each of the rules mentioned in this post.
Navigating through an Excel workbook should be like navigating through a well designed website. By approaching projects with this mindset, you will be on the way to producing a quality product.
“We have always been taught that navigation is the result of civilization, but modern archaeology has demonstrated very clearly that this is not so.” – Thor Heyerdahl