Cell outline prevents drag and fill

  • Thread starter Thread starter Spoon
  • Start date Start date
S

Spoon

All,
hopefully a quick question about why I am not able to use the fill
handle to drag certain cells in my workbook. I am still able to copy
and paste etc. and can use the fill command from the edit menu. The
majority of cells are unaffected, but the problem cells appear to have
a thin white line within the cell outline when highlighted.
I can work around the problem, but it's getting a little annoying.
Does anyone have any ideas?
Thanks
Spoon
 
Spoon said:
All,
hopefully a quick question about why I am not able to use the fill
handle to drag certain cells in my workbook. I am still able to copy
and paste etc. and can use the fill command from the edit menu. The
majority of cells are unaffected, but the problem cells appear to have
a thin white line within the cell outline when highlighted.
I can work around the problem, but it's getting a little annoying.
Does anyone have any ideas?
Thanks
Spoon

One possible cause...
Tools|Options|Edit|Allow cell drag and drop<<< Is this option turned
on? It must be on for the fill handle to be available.

Ken Johnson
 
Thanks Ken, but yes it is turned on. The fill handle is generally
available for the majority of cells, just not all of them.
Spoon
 

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

Back
Top