| 懷疑我會中左excel毒.. 對excel hotkeys太熟悉.. calc可能從此唔要我
[如果你認為自己對於excel hotkeys好熟悉的話.. 試試自己是否也懂得下列hotkeys?]
highlight就睇到答案
1. Shift Space
select a row
2. Ctrl+Space
select a column (i did change the "input method switch" from ctrl+space to ctrl+shift+space)
3. Alt+E+S+V (+e / +b)
paste values only (+e: transpose, +b: skip blanks)
4. Alt+E+S+T
paste format
5. Ctrl+R
fill right (copy the formula to all cells based on the leftmost cell)
6. Ctrl+D
fill down
7. Ctrl+[
find the dependent cell
8. Ctrl+]
find the precedent cell
9. F5 / Ctrl+G
Go to
10. Pressing "Shift Enter" when using F5/Ctrl+G
select from the current active cell to the destination cell
11. Ctrl+Shift+1
change to General format
12. Ctrl+Shift+3
change to Date format
13. Ctrl+Shift+4
change to Currency format
14. Ctrl+Shift+5
change to Percentage format
15. Ctrl+Shift+-
remove all borders
16. Ctrl+(Shift+)9
hide/unhide rows
17. Ctrl+(Shift+)0
hide/unhide columns
18. Alt+F+V
print preview
19. Alt+O+H+U
unhide sheet
20. Alt+O+H+H
hide sheet
21. Alt+O+H+R
rename sheet
22. Alt+I+W
insert sheet
23. Alt+D+S
sort
24. Alt+D+F+Enter
filter
24. Alt+D+T
data table
25. Alt+D+P
pivot table
26. Alt+T+O, right arrow, Alt+MU
set calculation to MANUAL
27. Alt+T+P+P
(un)protect sheet
28. Alt+T+P+W
(un)protect workbook
29. Alt+W+F
(un)freeze pane
30. Alt+E+I+S
fill series
31. Alt+E+I+U
fill up
32. Ctrl++
when selecting column/row, insert it
33. Ctrl+-
when selecting column/row, delete it
|
| |
| 
2009-10 Term 2
21 credit again.. hope i can register all the ug courses.
for sure: i won't attend H10 haha
-------------------------------------------------------
cuts有2009-10年timetable喇! 而且仲多左另一個版本既planner (俾d course choice 唔太複雜既人用, 同埋可以直接submit上facebook!)
亦都fix左之前睇唔到professor資料既問題, 而家可以睇到佢地03-09年教過既course
見到有熱心人o係course/professor 留左唔少comment ^^
http://apps.facebook.com/cuhk-cuts
|
| |
| 終於重拾寫cuts的熱誠，對上一次好像已經是超過半年前的事情了。
首先要做的是bug fixes..
由於excel及vba的設計很差，所以良好的programming style更難達到。
對我而言一個excel workbook是一個program︳有自己應有的programming style。
|
| |
| excel 你唔夠memory出聲就得啦.. 我可以close緊d program再save過, 或者唔save我都唔mind... 但係你唔好夾硬同我save d垃圾落去啦!!!!! 我冇任何方法recover要重新做過呀!!!!!!!!!!!!!!!! |
| |
| 1, 一大堆冇well documented and accessible既hotkeys and functions
2. 寫到亂七八糟周圍飛 (worksheet之間甚至係file之間) 但係又不停重覆既formula
3. delete一個blank column就足以令到成個excel計錯數
4. 可以整一個10MB既excel file出黎, 但係我用openoffice開完再save返既話得返300KB
5. save完冇得undo = 一失足成千古恨
and..
(http://j-walk.com/ss/jokes/car.htm)
If Excel Were a Car... - It would crash two or three times per day for no apparent reason. The driver is often hurt, but the car itself receives no permanent damage. You'd just accept this fact, restart the car, and begin your trip again.
- Occasionally, your car would fail to restart after a crash, and you'd have to reinstall the engine. For some strange reason, you'd just accept this too.
- You would be forced to buy a new model every 18 months, and your old model would have no resale value. Each new model would be bigger that the previous one, require more gas, and would operate differently. Furthermore, parts from the old car would not be interchangeable with the new car.
- You could call a special phone number when you had a problem. The phone would be staffed by people who know less about your car than you do.
- There would be a special Macintosh model, powered by the sun. However, it would only run on 5 percent of the roads and require different driving skills.
- You would have to spend additional money to buy the operating manuals.
- The oil, engine, gas and alternator warning lights would be replaced by a single warning light: "This car has performed an illegal operation."
- Before engaging, the airbag system would display a message, "Are you sure?"
- Every time you looked under the hood, an obnoxious cartoon character would appear and ask if you need help. No matter how many time you refused help, it would keep appearing.
- A special feature would let you automatically record the route for a particular trip, so you could repeat the trip automatically later on. However, after repeating the trip you always end up at a different location.
|
| |
