ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2007 drawing selection tool (https://www.excelbanter.com/excel-discussion-misc-queries/187850-excel-2007-drawing-selection-tool.html)

RunningTheRace

Excel 2007 drawing selection tool
 
In Excel 2003 there is a feature on the drawing toolbar that allows
one to select only drawing objects when clicking in a drawing. It's
done by clicking on an icon on the left side of the drawing toolbar
that looks like the familiar mouse pointer. If this icon is selected,
mouse clicks will only select drawing objects (lines, boxes, etc.)
instead of the underlying worksheet cells.

My question is, where is that functionality in Excel 2007? I don't
seem to find it anywhere.

BoniM

Excel 2007 drawing selection tool
 
Home tab, Editing Group, Find & Select, Select Objects.


"RunningTheRace" wrote:

In Excel 2003 there is a feature on the drawing toolbar that allows
one to select only drawing objects when clicking in a drawing. It's
done by clicking on an icon on the left side of the drawing toolbar
that looks like the familiar mouse pointer. If this icon is selected,
mouse clicks will only select drawing objects (lines, boxes, etc.)
instead of the underlying worksheet cells.

My question is, where is that functionality in Excel 2007? I don't
seem to find it anywhere.


BoniM

Excel 2007 drawing selection tool
 
Some links you might find helpful...

Online Interactive: Excel 2003 to Excel 2007 command reference guide
http://office.microsoft.com/en-us/he...491511033.aspx

Downloadable Interactive: Excel 2003 to Excel 2007 command reference guide
http://www.microsoft.com/downloads/d...displaylang=en

Excel Ribbon mapping workbook
http://office.microsoft.com/en-us/ex...101030621033#3


"RunningTheRace" wrote:

In Excel 2003 there is a feature on the drawing toolbar that allows
one to select only drawing objects when clicking in a drawing. It's
done by clicking on an icon on the left side of the drawing toolbar
that looks like the familiar mouse pointer. If this icon is selected,
mouse clicks will only select drawing objects (lines, boxes, etc.)
instead of the underlying worksheet cells.

My question is, where is that functionality in Excel 2007? I don't
seem to find it anywhere.


RunningTheRace

Excel 2007 drawing selection tool
 
Thanks, both of you. Very helpful.

RunningTheRace

Excel 2007 drawing selection tool
 
On May 16, 9:32*pm, RunningTheRace wrote:
Thanks, both of you. Very helpful.


Or, I guess, just one of you. Thanks BoniM.

BoniM

Excel 2007 drawing selection tool
 
You are very welcome... happy to help.

"RunningTheRace" wrote:

On May 16, 9:32 pm, RunningTheRace wrote:
Thanks, both of you. Very helpful.


Or, I guess, just one of you. Thanks BoniM.



All times are GMT +1. The time now is 10:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com