This website requires Javascript to function properly. Please go to the setting of your web browser and enable Javascript for this website.

Ad by

推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务

Ad by

推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务

这不算什么。俺30好几年没见过九九表了。但是怎么着九九表也不会反过来背的呀。：）

bdbs(不多不少)

1 x 1 = 1
1 x 2 = 2 2 x 2 = 4
1 x 3 = 3 2 x 3 = 6 3 x 3 = 9
1 x 4 = 4 2 x 4 = 8 3 x 4 = 12 4 x 4 = 16
1 x 5 = 5 2 x 5 = 10 3 x 5 = 15 4 x 5 = 20 5 x 5 = 25
1 x 6 = 6 2 x 6 = 12 3 x 6 = 18 4 x 6 = 24 5 x 6 = 30 6 x 6 = 36
1 x 7 = 7 2 x 7 = 14 3 x 7 = 21 4 x 7 = 28 5 x 7 = 35 6 x 7 = 42 7 x 7 = 49
1 x 8 = 8 2 x 8 = 16 3 x 8 = 24 4 x 8 = 32 5 x 8 = 40 6 x 8 = 48 7 x 8 = 56 8 x 8 = 64
1 x 9 = 9 2 x 9 = 18 3 x 9 = 27 4 x 9 = 36 5 x 9 = 45 6 x 9 = 54 7 x 9 = 63 8 x 9 = 72 9 x 9 = 81

(#3173364@0)
Last Updated: 2006-8-29
This post has been archived. It cannot be replied.

Report

Replies, comments and Discussions:

枫下家园 / 望子成龙 / 用Excel快速制作九九表。 -bdbs(不多不少); 2006-8-23 {461} (#3161060@0)
1.输入：A1(1) B1(x) C1(=A1) D1(=) E1(A1*C1) 注：仅输入括号内的值到相应的cell，下同
2.Copy A1~E1 to A2
3.Change A2(=A1) C2(C1+1)
4.Copy A2~E2 to A3~A9

到这里1出来了。继续

5.Copy A1~E8 to G2
6.Change G2(2)

这样2也完成了。

依此类推，可以几秒钟搞定3到9。剩下的就是formatting和打印的事了。

试试看，再生的手2分钟都能搞定。

教孩子背九九表小Tips。
1. 把每列设成不同字体，增加趣味性
2. 倒过来背，从9开始，比较少，比较简单，孩子比较容易有成就感。

我有自己用EXCEL做的九九乘法表和写汉字用的田格本，需要的话留E-M信箱给我。（我不知道怎么POST到这里，抱歉） -jxu(生活着，平凡着。); 2006-8-27 (#3169453@0)

PMED -missmymy(麦兜兜黄师奶); 2006-8-29 (#3173638@0)

这EXCEL水平不乍的。 -jeffrey815(Smartiecat); 2006-8-27 (#3169500@0)

你有更快的办法？请指教。我这也是随手做的，本来是回答楼下workdonkey的http://rolia.net/forum/forum_showPost.php?pno=3160595。想着也许有更多的人需要，就另起一贴。你要是有更好的办法，请不吝赐教，纯属技术探讨。 -bdbs(不多不少); 2006-8-27 (#3170570@0)

See inside -jeffrey815(Smartiecat); 2006-8-28 {123} (#3171801@0)
Copy and paste formula in B2 across and down.

不好意思，批评一下。 -bdbs(不多不少); 2006-8-28 {360} (#3171853@0)
我还以为你有什么高着呢，无非是把几个格子的内容合成一个而已。你这个做法有几个缺点：
第一：需要多一行和一列辅助，而建立这额外的一行和一列，步骤还不少。为了打印的时候不打印它们，还要隐藏这行（列）或者设定Print Area，太麻烦。
第二：打印效果不是传统阶梯状的。为了实现传统阶梯状的效果，还是得一行一行手工删除不需要的格子，增加工作量，虽然Copy & Paste的时候比较爽。

Fine. I couldn't remember how exactly 九九乘法表 looks like. But if that's the way you want (with no 1-9 on the top and on the left and with 传统阶梯状), it's still very simple. -jeffrey815(Smartiecat); 2006-8-28 {96} (#3172348@0)
Copy from A1 to I9

呵呵，这个看着才象是“Excel水平乍的”的人做的。不过还是要再批评一下。 -bdbs(不多不少); 2006-8-28 {120} (#3172370@0)
虽然你说你couldn't remember how exactly 九九乘法表 looks like，但是假如你会背的话，也不至于把乘数和被乘数搞反了吧。：）

The last time I saw 九九乘法表 was 19 years ago. And I no longer need to memorize it. I hope you don't need to memorize 九九乘法表 too. -jeffrey815(Smartiecat); 2006-8-28 {50} (#3172381@0)
Thank you for complementing my Excel skill though.

这不算什么。俺30好几年没见过九九表了。但是怎么着九九表也不会反过来背的呀。：） -bdbs(不多不少); 2006-8-29 {539} (#3173364@0)
1 x 1 = 1
1 x 2 = 2 2 x 2 = 4
1 x 3 = 3 2 x 3 = 6 3 x 3 = 9
1 x 4 = 4 2 x 4 = 8 3 x 4 = 12 4 x 4 = 16
1 x 5 = 5 2 x 5 = 10 3 x 5 = 15 4 x 5 = 20 5 x 5 = 25
1 x 6 = 6 2 x 6 = 12 3 x 6 = 18 4 x 6 = 24 5 x 6 = 30 6 x 6 = 36
1 x 7 = 7 2 x 7 = 14 3 x 7 = 21 4 x 7 = 28 5 x 7 = 35 6 x 7 = 42 7 x 7 = 49
1 x 8 = 8 2 x 8 = 16 3 x 8 = 24 4 x 8 = 32 5 x 8 = 40 6 x 8 = 48 7 x 8 = 56 8 x 8 = 64
1 x 9 = 9 2 x 9 = 18 3 x 9 = 27 4 x 9 = 36 5 x 9 = 45 6 x 9 = 54 7 x 9 = 63 8 x 9 = 72 9 x 9 = 81

As I said, you are still memorizing the table, I'm not. Just like I don't memorize how I walk. When I need to walk, I just walk. Probably you still memorize how you walk but not me. -jeffrey815(Smartiecat); 2006-8-29 {351} (#3173568@0)
And the topic of this conversation is about Excel. If your Excel is not as good as me, don't pick on me regarding this 九九乘法表. I have a Honours Bachelor of Math degree and I don't memorize 九九乘法表. So what?

And yes, you are very *smart* that you can still re-call and argue with a mature adult about 九九乘法表. Get a life. Go learn Excel.

as you said, I don't have to memorize how to walk, I take it as natual, and I will never walk in the way of 同手同脚. any again, it's good to see that you didn't claim you have PHD of Math. hoho. -bdbs(不多不少); 2006-8-29 {49} (#3173622@0)
anyway, thanks for sharing your Excel skill here.

Thanks for sharing! -onboard(Becool与酷毙); 2006-8-27 (#3169511@0)
我也做过，后来发现孩子可怜的中文念起来磕磕巴巴的，难上加难。最后还是用英文记得了。 -gingergiant(小葱); 2006-8-27 (#3170435@0)

呵呵，那你家孩子看来得先补中文。；） -bdbs(不多不少); 2006-8-27 (#3170575@0)

@Calgary

这不算什么。俺30好几年没见过九九表了。但是怎么着九九表也不会反过来背的呀。：）

Replies, comments and Discussions:

More Topics