How do you switch off Auto Fill in Excel XP?

M

michael

How do you switch off Auto Fill in Excel XP? I use
Validation a lot and the Auto Fill "smart" icon obscures
the drop-down arrow that operates the validation listbox.
 
D

Debra Dalgleish

To turn off the smart tags feature:

1. Choose Tools>Options
2. Select the Edit tab
3. Remove the check marks from 'Show Paste Options buttons'
and 'Show Insert Options buttons'.
4. Click OK
 

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

drop box/data validation help 0
Calculate (Auto Fill) cells with numbers and text. 3
Excel Auto Fill Options 1
auto fill options (copy cell, not create series) 4
Drop down lists in excel 3
Excel 2007 auto fill help 1
Auto Fill Weekdays 5
WORD VBA Search and switch to advanced ... 1

Top