ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can I select the arrows in my spreadsheet? (https://www.excelbanter.com/excel-worksheet-functions/236979-how-can-i-select-arrows-my-spreadsheet.html)

B. Markham

How can I select the arrows in my spreadsheet?
 
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?

PCLIVE

How can I select the arrows in my spreadsheet?
 
You might try right-clicking the item. You also may need to enter design
mode to select it.

Regards,
Paul

--

"B. Markham" <B. wrote in message
...
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?




Ashish Mathur[_2_]

How can I select the arrows in my spreadsheet?
 
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

"B. Markham" <B. wrote in message
...
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?




All times are GMT +1. The time now is 05:53 AM.

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