By: Fang Jian Fang.jian@eyou.com
In Excel2000:
CTRL mouse button ---------- You can select multiple discontinuous cells at the same time; Ctrl `(key left on the left) - make all column width doubled on the original basis, then press once Restore; ctrl 1 --------------- Toned the "cell format" dialog; Ctrl 2 (or letters B) ---- bold; Ctrl 3 (or letters U) --- - Tilt; CTRL 4 (or letters I) ---- Underline; Ctrl 5 --------------- Delete line; the above can also operate at the same time, such as I want the selected cell Bold, tilted, add the line, add deletion, then press and hold the CTRL button, then press 2, 3, 4, 5, which can effectively improve the work efficiency. CTRL 7 -------------- Display / hide common toolbar; Ctrl 9 -------------- Hide selected cells; CTRL 0 ---- ---------- Hide selected cells; (Note: The above numbers 1 ~ 0, all the numbers above the alphabet key, not the number key on the keypad.) Ctrl - -------------- Delete cells; Ctrl (on keypad) ----- Insert cell; Ctrl w (or F4) ------- Close; Ctrl D -------------- Pack the cell content on the right side of the selected unit to this unit, ie "fill right to right"; Ctrl R ------------ - Fill the cell content on the selected cell to this unit, "downward"; Ctrl ; -------------- Insert the current date in the selected cell ; Ctrl F3 -------------- Define the name of the selected cell; Ctrl F5 -------------- Restore the current workbook window size, that is, the window maximizes Pre-state; Ctrl F9 -------------- minimize the current workbook window; Ctrl F10 ------------ function is the same as F5, but can make Workbook returns to maximize; Ctrl F11 -------------- Insert a macro table; Ctrl F12 -------------- Open; CTRL arrow keys ----- ------ You can go to the top rightmost rightmost right to do the workbook; Ctrl Enter -------------- If you want to enter the same in multiple cells The content is to use him. First, use the mouse to select multiple cells, then enter the content in the edit bar, press CTRL Enter after entering. Ctrl Table -------------- can switch in the various windows of Excel
In Word2000:
Ctrl 1 -------------- single line spacing; Ctrl 2 ------------ 2 times a distance; Ctrl 5 ----------- --- 1.5 times a distance; Ctrl 0 -------------- increase / revocation segment pitch 12 pounds; (Note: The above number keys 1 ~ 0, all the numbers above the letter key Key, not the number key on the keypad.) Ctrl - (or F3) --------- Delete; Ctrl -------------- 上 标; ctrl = - ------------- Short mark; Ctrl Backspace / Delete - Delete before / back in words, if English deletes the entire word; Ctrl Q ------------ ---- Paragraph Reset; Ctrl W (or F4) ------ Close; Ctrl E ----------------------- --- Right alignment; Ctrl L -------------- Left alignment; CTRL J -------------- End alignment; Ctrl T ------ -------- The first character is increasing 1 character; Ctrl B -------------- Bold; CTRL U -------------- Add Underline; ctrl i -------------- tilt; ctrl ] -------------- increase the size of 1 pound; (this function is very practical) Ctrl [ -------------- Decrease the font size 1 pound; (this feature is very practical) Ctrl D -------------- Open the font dialog; Ctrl M - ------------ Different indentation; CTRL F2 -------------- Print preview; Ctrl F5 ------------ from the largest Chemical reduction window; Ctrl F10 ------------- From maximize restore / recovery window; Ctrl F9 ------------ Insert domain code; Ctrl Insert ----- ---- Display the clipboard window Ctrl home (or page up) - move the cursor to the beginning of the document; Ctrl End ------------ Move the cursor to the document; Ctrl Enter- ---------- Insert a page break; Ctrl 5 (on the keyboard) - all selected, equivalent to Ctrl A; Ctrl Left (right) direction button ------------ will The cursor moves to the left (right) in the word; the ctrl over the key ------------ Copy a paragraph of the last input; (also apply to Notepad) Ctrl Under the direction button ---- -------- list 16 words, words, or phrases that have recently entered.
