Fill handle turned into a move handle

G

Guest

Not sure how it happened but with one particular workbook my fill handle is
not functioning, it has turned into a 4 way arrow and I can't fill formulas.
I have checked options > edit > allow drag n drop and that looks OK. Looked
at the visual basic editor. No funny commands or properties.
I can only think I hit some sort of key combination. I can't copy paste this
workbook to a new one and get rid of the problem, it comes with it. However,
it does not exist in any other workbook or new workbook.
Any suggestions?
Thanx
 
R

Richard O. Neville

Did you try copying the entire sheet to a new workbook? Right click the bad
sheet, select Move or copy, check Make a copy, and in the drop-down list
select (new book). If that solves the problem, delete the bad one and copy
the repaired one back to the original document.
 

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

Top