How to unhide all the hidden sheets at once - Microsoft Excel
When working with big dashboards we hide lots of backend sheets so that final dashboard is clean. The easy part if hid…
Showing posts from August 16, 2020
How to get contents from a Hidden sheet in a Protected workbook - Microsoft Excel
When you have a Excel file which is protected and you have forgotten the password. Now how do you retrieve the content…
How to filter for multiple values in Microsoft Excel dashboard
When it comes to dashboards in Excel, we rely on the data validation list predominantly to act as user inputs based on…