When creating a navigation bar in any program, it greatly enhances the user experience. And, it is even better if you do it in Excel.
You see, if your app is easy to navigate, then that makes it more efficient. In the end, that is what you want.
Therefore, this quick tip focuses on creating a navbar in Excel that links to different sheets within your document. In this instance, we put the navbar on the top of each page. Overall, it will be similar to what you would see on many websites.
For the purpose of this lesson, we suggest you use Microsoft Excel 2007 or higher or compatible. In addition, we expect you to have at least a beginner level knowledge of Excel.
Steps to creating a navigation bar in Excel
Below are the steps to create a top navbar in Excel.
Start with a blank canvas
It always feels good to start off with a blank canvas. So, go ahead and start a new Excel document. Pressing Ctrl-N should do that for you. Otherwise, do it the long way, with File...New from the menu.
After that, here we go...
Insert and name your new sheets
Create four sheets by clicking on the plus sign next to the sheet at the bottom of the screen. Also, you can press Shift-F11.
Now, you will have four sheets (Sheet1, Sheet2, Sheet3, and Sheet4), as shown below.
Next, name your sheets.
Double-click on each sheet, and give each sheet a unique name. In our case, we chose Home, Summary, Data, and References.
Creating a navigation bar background row for each sheet