I am a big fan of shortcuts. I'v always been a crtl+v/crtl+x guy, a alt + shift + tab guy, a shift f7 guy...
In the list provided, a few shortcuts and functions struck me as being particularly useful. I found CTRL+; to be a nice shortcut to quickly enter the date. I also think its helpful to use CTRL+` to see what formulas are being used where, and then to switch back to cell values. Some tasks could probably be facilitated through the use of the SHIFT+F4 tool to repeats the last Find action. I also frequently use the CRTL + z shortcut to undo the previous step.
Of course, CRTL + S is critical to use in periodically saving one's work to avoid losing important data.
As for the functions, I like using f7 to check spelling, and f11 to create a chart of the information in range.
Of all the additional shortcuts, I felt the most interesting ones were ALT+ENTER to start a new line in the same cell, CTRL+ENTER to fill the selected cell range with the current entry, and SHIFT+ENTER to complete a cell entry and select the cell above it.
Saturday, October 6, 2007
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment