reaktorblue
Board Regular
- Joined
- Aug 8, 2007
- Messages
- 87
- Office Version
- 365
- Platform
- Windows
Wow, where to begin. I think the biggest issue I'm running into is I have no idea what to call this. The previous place where I worked has a reporting team that had this enabled somehow and I'm looking to accomplish the same.
They had all of the tabs hidden. Instead of navigating by tabs, they had basically a sidebar navigation. There were links to various reports (which were basically direct links to the other tabs) but this sidebar navigation did not scroll with the page. It had its own scroll bar.
I'm working on a project and I'm trying to attempt something similar. My navigation menu currently looks like the following.
Excel 2010
Is there any way to get this to appear on every worksheet and enabled in it's own scrolling section? I think the biggest issue I'm running into is I'm not sure what this is called. I've tried splitting the panes, but that doesn't really seem to be correct. I've tried freezing the panes too, which is a silly workaround (it works, but it's sure not pretty and sure not what I'm attempting to do.)
I was thinking I could create the navigation menu in a worksheet all of it's own and use view side by side with all of the rest of the worksheets. Creating the navigation in it's own sheet would save a bunch of time with updates to the sheet but after attempting this, it's still not exactly what I was looking for.
Does anyone happen to have any insight as to a solution to what I'm looking for?
They had all of the tabs hidden. Instead of navigating by tabs, they had basically a sidebar navigation. There were links to various reports (which were basically direct links to the other tabs) but this sidebar navigation did not scroll with the page. It had its own scroll bar.
I'm working on a project and I'm trying to attempt something similar. My navigation menu currently looks like the following.
| Excel Workbook | ||||
|---|---|---|---|---|
| B | C | |||
| 2 | Shortcut Panel | |||
| 3 | My Home | Market Add Item | ||
| 4 | My Bazaar | Bazaar Add Item | ||
| 5 | My Display Case | Display Case Add Item | ||
| 6 | My Vault | My Events | ||
| 7 | My Warbase | My Faction Attacks | ||
| 8 | My Company Specials | My Items | ||
| 9 | Advanced Friends List | Advanced Blacklist | ||
| 10 | Stock Portfolio | Race | ||
| 11 | ||||
| 12 | Player ID | |||
| 13 | ||||
| 14 | Travel Qty | 22 | ||
| 15 | ||||
| 16 | Seconds Remaining | 1104 | ||
| 17 | Time Remaining | 0:18:24 | ||
| 18 | ||||
| 19 | Total Value | |||
| 20 | Total Profit | |||
Format Test | ||||
Is there any way to get this to appear on every worksheet and enabled in it's own scrolling section? I think the biggest issue I'm running into is I'm not sure what this is called. I've tried splitting the panes, but that doesn't really seem to be correct. I've tried freezing the panes too, which is a silly workaround (it works, but it's sure not pretty and sure not what I'm attempting to do.)
I was thinking I could create the navigation menu in a worksheet all of it's own and use view side by side with all of the rest of the worksheets. Creating the navigation in it's own sheet would save a bunch of time with updates to the sheet but after attempting this, it's still not exactly what I was looking for.
Does anyone happen to have any insight as to a solution to what I'm looking for?
