vlook up

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

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

Vlook up

resolvedResolved · Low Priority · Version Standard

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?

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


 

Excel tip:

Page Break Preview in Excel 2010 (Hint/tip)

If you select View then Workbook Views then Page Break Preview, you will be able to view how your Excel spreadsheet will be split across multiple pages when printed. Even better, you can also drag a page break to a new place. Excel will then scale down your entire worksheet to fit the information you want on the pages you want.

View all Excel hints and tips


Server loaded in 0.08 secs.