or, The Hitchhiker’s Guide to Fear and Loathing at a Public Library Reference Desk

Reference Question of the Week – 10/4/09

   October 10th, 2009

I 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?


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


Just click the "New" button in the upper left corner of the Inbox.

Tags: , , , , , , , , , , , , , ,

Comments are closed.