View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Shane Devenshire Shane Devenshire is offline
external usenet poster
 
Posts: 857
Default Can't remove check boxes

Hi,

1. You can remove the hyperlinks by selecting an empty cell and choosing
Copy, highlighting all the hyperlinks and choosing Edit, Paste Special, Add.

2. Generally you can remove checkboxes by pressing F5, Special, Objects, OK.
And then pressing Del.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"***TominFL***" wrote:

Couldn't find a post that addresses these two problems.

I copied a bunch of data from my Scottrade history and wound up with a line
of check boxes on the right side of a column of cost numbers. No matter what
I do I can't remove them. Can anyone tell me how to do this?

Also, I want to remove the hyperlinks that are part of a column of stock
symbols. I can remove them individually but what to do so to the whole
column. Any advice on how to do this?