Microsoft Excel is a powerful tool to analyze data, display charts and graphs, and create reports. While most people use MS Excel for these tasks, they often overlook the flexible features and many possibilities that Excel offers. For example, I created a spreadsheet storing hyperlinks to launch folders, documents, web pages, and even programs that I use most often. I then categorized the links under various categories to retrieve them quickly.
There are many benefits to using such a “control panel spreadsheet”:
- It enables you to access anything you need in a simple click, as opposed to going through many folders to finally reach your end destination.
- If you like to multitask, this will finally get rid of all the open windows clogging your taskbar and desktop.
- If you work in group at work, this spreadsheet could be used and shared amongst colleagues to keep everyone on the same page.
Here are the simple steps to creating your own control panel spreadsheet:
1. Open a new Excel workbook and start typing down all your most-often used programs, websites, folders and documents.
2. Categorize them into groups.
3. For each of them, right-click on the cell, and select Hyperlink.
4. In the address bar at the bottom, insert the path to the file you want to open. The “Text to display” is by default the text you inserted previously in the cell.
5. To retrieve the path, you can browse through the file or the folder, right-click to select Properties and copy and paste Object name location as shown in the images below.
6. Now all you need to do is add some colors and your spreadsheet is good to go!
by Mark Luu