There are a few things I do with the Income/Article Spreadsheet that might help to make your day easier. For you folks who are spreadsheet junkies, you can skip this post because I’m not going to talk about anything new or earth shattering, just something that I do to make my life easier.
After listing the residual or up front resource name in the column heading, I hyper link the title to the site’s earnings page. Of course, if you’re not logged into the site when you click on the link it will bring you to the main page, but when you’re updating your numbers, it’s a lot easier to click the column heading and force the software to bring up the webpage than leaving Excel, opening your browser and navigating to the website (that was a record-breaking long sentence).
Here’s how to do it:
In your Excel spreadsheet, navigate to the cell of the column heading that will be hyperlinked. In this example, I’m linking to my eHow revenue page, so I click in the eHow column heading cell and then click on the hyperlink icon.
If the hyperlink icon isn’t part of your menu options, navigate to hyperlinks by clicking “Hyperlink” under the “Insert” menu. The shortcut is “Ctrl-K”
Once you click on the hyperlink icon (or navigate or shortcut to it), the “Insert Hyperlink” window opens.
In the “Linked to:” column, make sure “Existing File or Web Page” is selected.
Next, insert the URL in the “Address” box at the bottom of the window (here I inserted the URL to my eHow account) and click “OK.”
You’ll notice the header will change to the default hyperlink font, color and formatting. You can leave the formatting as is or you can change it to any color or style you wish.
Using the same “Insert Hyperlink” window you can link to any page within the spreadsheet (or other spreadsheet for that matter).