Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

smart tags autofill

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Smart tags (autofill)

Smart tags (autofill)

ResolvedVersion 2010

Verity has attended:
Project Intro Intermediate course

Smart tags (autofill)

Where do you enable/disenable the smart tag to come up when you autofill? Mine has disappeared!

RE: Smart tags (autofill)

Hi Verity

Thanks for getting in touch. You can enable or disable this through Excel's options.

Go to File > Options > Advanced. Make sure the box for "Show Paste Options button when content is pasted" is checked. This should turn this feature on or off.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Excel tip:

Counting Blanks

Some times you want to check if there are cells missing data in your range. You can use the COUNTBLANK FUNCTION to acheive this. It is =COUNTBLANK(Range). Note Cells with formulas that return "" (empty text) are also counted. Cells with zero values are not counted.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.