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

autofil

ResolvedVersion 2010

Dan has attended:
Excel Intermediate course
Excel Advanced course
Excel Financial Modelling course

Autofil

Hi there.
I created a summary data in Sheet2 but when autofill i got random formulas.
I was told in the course that I can send you the worksheet, in case.
Please, advice accordingly.
Thanks
Dan

RE: Autofil

Hello Dan,

Hope you enjoyed your Microsoft Excel courses with BEST Training.
Thank you for your question regarding Autofill.

Please send your file to forum@stl-training.co.uk and we as see what you are referring to.

Kind regards,

Richard
Microsoft Office Specialist Trainer

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Mon 1 Dec 2014: Automatically marked as resolved.

Excel tip:

Quickly insert a function

In Excel 97 and 2000 it was known as the Paste Function dialog box, these days it's known as the Insert Function dialog box. Regardless, one has to choose Insert|Function. or the fx button to open it up. There is, however, a non-mousey way to get hold of the Insert Function dialog box: press Shift+F3 in a blank cell to open the Insert Function dialog.

Press Shift+F3 after a function name and open bracket to open the Function Arguments dialog. For example, type =VLOOKUP( into a cell and press Shift+F3 to obtain a detailed description of VLOOKUP's arguments.

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.