Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

removing anchors

0

I have converted a word file to excel and need to remove the anchors so i can edit the formulas. The anchors are in all the cells, how do i remove all of them at one time.

excel
MS Office Version: 2016
posted by: HS1 on Thu Dec 21, 2017 at 11:47 pm
Answer
Discuss

Discussion

Can you post a sample file? Just edit your question and upload it.
don (rep: 1989) Dec 22, '17 at 1:26 pm
Thanks Don.  But doing that discloses the file,, I can't do that of course file is confidential material... 
HS1 Dec 22, '17 at 9:20 pm
Add to Discussion

Answers

0

by ctrl A and then delete

posted by: asso on Fri Dec 22, 2017 at 5:35 am
Discuss

Discussion

Thank you.... 
HS1 Dec 22, '17 at 9:20 pm
Add to Discussion
0

The "Anchors" are the product of a faulty method of importing the data from Word into Excel. Instead of removing them you should change the method so that you don't have them in the first place. You may find some guidance here.

posted by: Variatus (rep: 4889) on Fri Dec 22, 2017 at 9:04 pm
Discuss

Discussion

Thank you. 
HS1 Dec 22, '17 at 9:21 pm
Glad to have been of help. Let me know how you are making out. If you got all you needed please accept the answer. It may help others to save time.
Variatus (rep: 4889) Dec 22, '17 at 10:47 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login