How can I select the arrows in my spreadsheet?

B

B. Markham

I have a spreadsheet from a client that contains arrows that I can neither
select nor delete. When I put the cursor on them, it changes, as if to allow
selection of the item, but no such luck. I did try the "zoom" function to
see if I was selecting them and just unable to see the size handles appear.
Also not the case. Suggestions?
 
P

PCLIVE

You might try right-clicking the item. You also may need to enter design
mode to select it.

Regards,
Paul
 
A

Ashish Mathur

Hi,

Is it s blue arrow - in which case, it could be Trace precedents or trace
dependents. Go to Tools > Formula auditing > Remove arrows

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using the list form control: multi-selection possible? 3
Prompt For Replace in Selection And More... 0
How can I show up and down arrows when a value changes? 1
Function in Excel to count and list number of entries of text valuesin a row. 2
I have lost 6 months work, how can i get my file back 1
How can I move to the first cell in the selection in Excel 07? 7
CANNOT DELETE AUTOPHAPES ARROWS FROM WORKSHEET 3
How do I add N/A to a selectable cell with an arrow? 1

Top