Excel高手請進

１．冇辦法！

２．小階變大階，用”UPPER”，大楷變小楷，用”LOWER”．
即係打（例如，假設你要轉嘅字響A1嗰格）：　=UPPER(A1)
　　　（例如，假設你要轉嘅字響A1嗰格）：　=LOWER(A1)

2007-07-19 15:56:02 補充：
或者你可以直接輸入（例如：chan tai man要變成CHAN TAI MAN）：=UPPER(chan tai man)

１）打過。但係Ａ２７你想點轉？

定係你想ｔｒａｎｓｐｏｓｅ？
ｃｏｐｙ，ｐａｓｔｅ　ｓｐｅｃｉａｌ，轉置？

２）
ｇｏｔｏ　ｓｈｅｅｔ　２
Ａ１＝ｕｐｐｅｒ（ｓｈｅｅｔ１！Ａ１）
ｄｒａｇ　ｃｏｐｙ　ｆｏｒ　ｙｏｕｒ　ｄａｔａ　ａｒｅａ。
ｃｏｐｙ，　ｇｏ　ｂａｃｋ　ｔｏ　ｓｈｅｅｔ　１，
ｐａｓｔｅ　ｓｐｅｃｉａｌ，ｖａｌｕｅ，
ｄｅｌｅｔｅ（ｏｒ　ｃｌｅａｒ）　ｓｈｅｅｔ２

我想將A1 A2 A3 A4 A5...etc轉為A1 B1 C1 D1 E1咁樣，有咩最快既方法?
i don't think you can use a fastest way, however, it's faster of you to type the data again.
you highlight A1 A2 A3 A4 A5...etc and then put the mouse towards the black edge,
then you can see a cross sign, then you can move the whole data to A1 B1 C1 D1 E1...
and then move the right corner of the edge to paste the data.


同埋點一次過將英文既大細(佳)一次過轉做大或細(佳)呢?
highlight them , and then choose some words style, eg algerian, engravers mt, Showcard Gothic, stancil, Scruff LET, Perpetua Titling MT, Felix Titling, Copperplate Gothic Light, etc...........

hightligh 你所打既 英文字母 然後 簡 engravers mt 呢個字形 就會變晒大佳