Joshua is a graduate student at the USF. He has interests in business technology, analytics, finance, and lean six sigma.
At times, you may need to reference other documents while you are working in an Excel workbook. Whether that document is a statement of work, standard operating procedure, or a another Excel file, you can retrieve it with only a click if you assign the document location to a button.
This task can be easily completed by adding a shape to use for a button, then assigning that button to a document location.
Add the Button to Excel
Adding a shape for a button can be done through the insert tab. The path is shown below:
Insert → Illustrations → Shapes
I recommend using a rectangle to symbolize a button, but you can really choose the shape that you desire.
After the shape has been selected, you can trace the size of the button that you want with the cursor.
Editing the Button
Make adjustments to the size the button by dragging on the spheres that surround it to give it the correct height and width. To add text you can right click on the button and select edit text from the drop down menu. This will drop your cursor in to button.
All other formatting options can be found in the shape format tab after the shape is selected.
Linking to a File
To link a document to a file right click on the button and select link from the drop down menu.
Next, you'll need to select the option in the upper left-hand corner that is labeled existing file or webpage. You may use the drop down in the "look in" area or choose the folder option below that is labeled with a number 2.
Once you find the file that you want to open select the the OK button.
At this point you should have been returned tot he worksheet. Deselect the button by clicking in any cell.
After clicking your button, there is a good chance that you will receive the same precaution shown in the illustration below. Click yes and your document should open.
To learn more about developing in Excel, I recommend taking a look at the book Microsoft Excel 2019 VBA and Macros (Business Skills) by Bill Jelen to enhance your skills.
This content is accurate and true to the best of the author’s knowledge and is not meant to substitute for formal and individualized advice from a qualified professional.
© 2021 Joshua Crowder