Reference Question of the Week – 10/4/09
October 10th, 2009 Brian HerzogI was asked these two questions back-to-back one day this week:
I want to sell my car on craigslist, and I want to be able to email people an info sheet. I've already created an Excel spreadsheet with mileage and other statistics, including a couple pictures pasted in. Can you show me how to put arrows and text on the pictures, and how to convert it to a pdf file?
...and...
I've been on Yahoo for a few months now. I know that I can get letters from people, and I can reply to letters people send me, but, can I send people letters too?
Of course, both of these are legitimate questions. I was just struck by such different technology experience levels from two patrons who walked up to the reference desk at about the same time.
And the answers are:
Excel's Drawing Toolbar (View > Toolbars > Drawing) allows both of these things. Click the icon that looks like an Arrow to draw an arrow on a picture, use the Line Style to make it thicker, and the Line Color icon to change the color. Then, click the Text Box icon to create a text box wherever you want words to appear. Use the Fill Color and Line Color to make sure it's legible against the picture.
To create a pdf version, we installed PDFcreator on our public computers. It shows up in the printer selection dropdown box, and creates a pdf file patron can then save to disk
...and...
Just click the "New" button in the upper left corner of the Inbox.