Change Default Browser for Hyperlinks in Excel 2021 Home Student
Microsoft Excel is a powerful spreadsheet software that is widely used for various purposes, such as data analysis, data visualization, and data management. One of the useful features in Excel is the ability to insert hyperlinks that can direct users to a specific webpage or file. However, by default, Excel opens hyperlinks using the default web browser, which may not always be the preferred browser.
Why Change the Default Browser for Hyperlinks in Excel?
There are several reasons why one might want to change the default browser for hyperlinks in Excel. For example, a user may prefer using a specific browser for certain tasks or may want to use a different browser for security reasons. Additionally, some webpages or files may not open correctly in the default browser.
Changing the Default Browser for Hyperlinks in Excel
Fortunately, changing the default browser for hyperlinks in Excel is a straightforward process. Here are the steps to follow:
- Open Microsoft Excel.
- Click on the "File" tab in the ribbon.
- Select "Options" from the drop-down menu.
- In the Excel Options window, click on "Advanced" on the left-hand side.
- Scroll down to the "General" section.
- Under "Web Options," click on the "Settings" button.
- In the Web Options window, select the "Browsing" tab.
- Under "Default Web Browser," select the preferred browser from the drop-down menu.
- Click "OK" to save the changes.
Code Block: Changing Default Browser for Hyperlinks in VBA
Alternatively, changing the default browser for hyperlinks can also be done using Visual Basic for Applications (VBA). Here's an example code block:
In the code block, replace "Google Chrome" with the preferred browser. To run the macro, press "Alt + F11" to open the VBA editor, paste the code into a module, and press "F5" to run the macro.
In summary, changing the default browser for hyperlinks in Excel 2021 Home Student is a simple process that can be done through the Excel Options window or using Visual Basic for Applications (VBA). By changing the default browser, users can improve their workflow and ensure that hyperlinks open correctly.