Excel 2007 : drawing lines in Excel 2007

[kitbit]

Hi all,
I have a spreadsheet onto which I have pasted several pictures as illustrations. I need to use the "lines" tool in order to draw arrows between text and images, but can't find the line drawing tool, nor the toolbar. F1 help just says to click on an existing line or drawing object in order to activate the drawing tab on the ribbon. Er...if I had one already I wouldn't need to make one myself..!
Am I being really dim? Where do I find the "line" tool?

TIA

[Andy Pope]

xl2003 with the drawing toolbar displayed it's right next to the Autoshapes button.

If you are not seeing the Drawings toolbar try
View > Toolbars > Drawing

[kitbit]

thanks Andy, but when I click on the "view" menu I get only the "view" ribbon, showing workbook views, show/hide, zoom, window and macros groups of buttons. Can't seem to find any toolbars anywhere, as you used to in previous versions.
Can't see anything in Excel Options either...
??

[oldchippy]

Hi,

You might find this useful

http://office.microsoft.com/en-us/ex...491511033.aspx

See the link to a workbook here

This guide covers the most popular commands from Excel 2003. For the complete list of command equivalents, see Reference: Locations of Excel 2003 commands in Excel 2007.

[Andy Pope]

My bad. I missed the 2007 mention in the title.

Insert > Illustrations > Shape > Line

[kitbit]

ah there it is!!! Thank you so much, and thanks too for the link to the 2003-2007
your help is very much appreciated thanks guys x