drag and fill options

M

mewmew

Total novice here, so sorry if i annoy anyone, anyhow my work sheet
won't allow me to drag and fill my formula? Could do it the other day,
but just returns o's now. I have been to my tool bar but dont see any
options to correct anything. Any suggestions?

thanks mewmew
 
D

Dave Peterson

Do you see the little autofill box in the bottom right corner of the activecell?

If no, then I'd try:
Tools|Options|Edit Tab|Check Allow Drag and Drop
 

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

Similar Threads

Cell outline prevents drag and fill 2
Excel Drag autofill only part of formula 3
Fill Handle doesn't display - Allow cell drag and Drop option is c 1
How to Disable the Little Auto Fill Dialog 3
Fill the below blank cells 8
fill series option not available 5
Excel 2013 vlookup to different workbooks not working 5
Filling down w/o dragging 6

Top