Copying Tables From A Website
I'm primarily a Firefox kinda guy but here is one where Microsoft Explorer 7.0 (or 6.0) has an edge.
How many have seen a table on a website and attempt to copy & paste into excel? Many folks will attest that this is a pain as it brings in all the funky graphics, html links, or adds all the text to a single cell leaving you to spend even more time re-formating everything. There is an easier way to export it to excel if you are using Microsoft Explorer and here's how:
- Simply hover your mouse over any table on a website
- Right click your mouse and a submenu will appear
- Near the bottom of the menu you will see "Export to Microsoft Excel" (click it)
That's it your done!
Another Way to Add Photos
Someone turned me on to a very simple solution that allows you display photos that are linked to cells by using the comments feature within excel.
In order to make this work effectively you'll need to go into the "Tools" menu and select "Options". On the "View" tab make sure that the "Comment indicator only" radio button is selected and then press OK.
Start by selecting the cell and add a Comment (with no text). After adding a Cell Comment, right click in the cell and choose Edit comment. Now double click the dotted outline of the Comment where the size handles are, and then click the "Colors and Lines" page tab. From this page click the drop arrow from the "Color" box and then "Fill Effects" and finally "Picture" then "Select Picture".
Linking Photos
I received some e-mails asking how to add pictures to the file. The easiest way is by creating a link to the photo.
I've attached a PDF file that provides instructions on how to do this. ;)
Creating a Want List
You can use "Set Description" field for not just coins you have but for even coins you don't have.
This is accomplished by simply adding the coins you are looking for to the inventory sheet and in the Set Description column use the phrase Want List.
Once you have this then you can do whatever you want, such as sorting by that field or using the filters to generate a want list that you can print out.
Leave Your Spreadsheet Tip
We found this list of Microsoft Office Tips and Tricks if anyone is interested
I am using the "coin" spreadsheet on both of my computers. The one running Windows 2007 seems to be working well, however, for some reason whenever I save a spreadsheet it goes to recent documents and not into the Excel Document files. Why ?
On my second computer, I am running Windows XP and I cannot get the programs to work. I would like to use this computer as my backup. Help……
Jim
You are having compatibility issues. When you started the file in 2007 it automatically saved it in a new file format that office 2003 cannot use. Try doing a "save as" and choose excel 97/2003 and it should clear up your problems.
I have inherited a coin collection and need to inventory it. I've downloaded the coin inventory template, but can't figure out how to use it. Could you give me a quick primer?
Much appreciated, thanks.
Hi Alex,
Most of the sheet is manually entered and you will need some eventual numismatic knowledge to fill-out some of the fields but the good thing is that the fields are not mandatory so you can leave them blank. That said let's walk though a quick example;
That is pretty much it. The other fields can be filled out later (or not at all) as you gain more knowledge on collecting coins. Also I'd recommend picking up Redbooks "A Guide Book of United States Coins" at your local bookstore.
Post preview:
Close preview