Forum home » Delegate support and help forum » Microsoft Excel Training and help » Vlook up

Vlook up

ResolvedVersion Standard

Thu 14 Feb 2008, 15:34 Delegate Marsha said...

Marsha has attended:
Excel Intermediate course
Word Advanced course

Vlook up

How do I customise the Auto Sum button to display the items I use the most like a Vlookup?

Thu 14 Feb 2008, 17:04 Trainer Rajeev said...

RE: Vlook up

Dear Marha

Thank you for attending Excel Intermediate course. I hope you enjoyed the training.

Your question is quite interesting one. I can understand that there are few functions that we use on a regular basis and do not want to keep on accessing the Paste Function Dialog box to search for our specific function.

Unfortunately Excel doesn

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Turn off AutoComplete in Excel

You may have noticed when typing into your spreadsheets that if you start to enter labels that begin with the same letters as a label that has been previously entered in the same spreadsheet, Excel will try and automatically complete the text for you. This feature is called AutoComplete.

If you find this feature more annoying than useful, you can turn it off by:

1. Going to Tools - Options.

2. Select the Edit tab.

3. Remove the tick from next to the "Enable AutoComplete for cell values" option.

4. Click OK.

View all Excel hints and tips

Vlook up

Vlook up

RE: Vlook up

Excel articles

Excel tip:

Turn off AutoComplete in Excel