smart tags autofill

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

Smart tags (autofill)

resolvedResolved · Medium Priority · Version 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:

Viewing Many Worksheets

If there are more worksheets in your workbook than there is room to show all their tabs at the bottom of the screen - Right click on the navigation arrows. A list of all your worksheets is shown. You just click on the one that you want to access. If you have more than 15 worksheets, select in the list and choose your worksheet from hundreds.

View all Excel hints and tips


Server loaded in 0.08 secs.