Microsoft Excel Instant Multiplication Table - MS Excel Tutorial

Visit MotionTraining at http://www.motiontrainingweb.com
Learn how to quickly create a multiplication table in MS Excel using a bit of copy & paste trickery. This tutorial will work in all versions of Excel.

Category:

Howto & Style

Tags:

• Microsoft
• Excel
• Tutorial
• Computer
• Help
• Spreadsheets
• MS

[spiningaway]

thank you very much for the video.

but some things are different in office2007, for example the F4 key doesn't work..

or is it due to windows 7 or my keyboard????

[MotionTraining]

Hi.  F4 definitely works, as described in this video, in Excel 2007. Not sure why it wouldn't work for you. Sorry I can't be more help.

[axum93]

Hey ! thanks for your tutorial its awsome ! could you please tell me which softwear (screen capture and sound rec.) you use to make the tutorial ? i dont think you are filming your monitor with a camcorder / webcam  big thanks !

[MotionTraining]

I use Camtasia Studio.

[axum93]

oooh maan its nice but very expensive about $ 300 ! is there a free one online ?

[MotionTraining]

You could try BB FlashBack Express. Never used it myself but it is free!

[kebubas]

Thanks sooooo much, I was trying to get it right like for an hour or so... my mistake was I didn't put ' * ' into the formula ><

[bellav1389]

hey there

how do u activate your mouse point highlighter? (the green zone around mouse point, I mean)

[gadgethead16]

very good same is 2007 i got mine to 100*100

[gadgethead16]

@spiningaway yes it dose

[valerinist]

@MotionTraining

i also having prob with the F4 key. it comes up with ' computer only, duplicate, or project only' pop up on the screen. and cant add absolute to the value. thanks

[patoshevarobinho]

THANK YOU! other tutorials seems harder for some reason. Thanks

[trr12]

Very nice video, I learned something today.

1.-Is there a another way to multiply two given columns with data without having to drag down the mouse with the formula inputted?

thanks!

[dxusmandx]

@ MotionTraning dear clear me something. after putting formula when i use to copy the formula to whole k11 , i dnt knw why my excel shows some irrelevant number its 1,2,6,24,120,720.... whay is that happening. waiting for ur reply.

[Bubblevicious]

Very nice. Thank you for the tutorial. This will help me with factoring polynomials and finding common denominators for fractions, as I cannot come up with the numbers up the top of my head like many people.

[TeeLoveBaby]

i have Microsoft 2010 and the special paste don't show up what can i do ?