Bring the Power of AI to Excel:
➤ https://www.pinexl.com/pineaiexcel...
Protop: If you are going to hide or delete rows in the document, this could also impact the navigation menu sheet names. To avoid that, you can try using rectangular shapes with text in them, instead of writing in the actual cells. Just add shapes with the same size as the cells and with the same colour, as the navigation menu background, write the sheet names in them, and link them to the respective places in the document. To lock them in place and to avoid hiding them when filtering data, rightclick on a shape, select Format Shape..., go to Size & Properties, Properties and select Don't move or size with cells. This way, the navigation menu items won't get hidden when you hide or delete rows.
Create this Navigation Menu Pane in seconds with our AddIn Pine BI:
➤ https://www.pinexl.com/pinebiexcel...
Learn how to create a navigation menu pane in Microsoft Excel. Perfect for organizing your Spreadsheets and Dashboards in a modern, professional and engaging way.
➤ If you found this video useful, please Like, Share and Subscribe!
Need amazing Excel Dashboards and Charts? We've got you covered!
We can support you by updating your existing Spreadsheet visualizations or creating new, based on your data from scratch! For more information, visit our Services page:
➤ https://www.pinexl.com/consulting
Project Management Template, which was featured in the video:
➤ https://www.pinexl.com/productpage/p...
Check out our other premium Excel Templates:
➤ https://www.pinexl.com/templates
More free tutorials are available on our website:
➤ https://www.pinexl.com/exceltutorials
Follow us on:
➤ Facebook: / pinexl
➤ LinkedIn: / pinexl
Modern & Professional. No Macros. Completely Unlocked.
Music: www.bensound.com