26th November 2001

Is your name not Bruce? No matter, there's this Gnomie (Bruce Levitan) and he's got a bunch of Excel keyboard shortcuts to turn you into a spreadsheet superstar. He understands that using a mouse for routine tasks can get cumbersome quickly. Like myself, Bruce is a fan of the key combo. While ALT+EQUALS will invoke the AutoSum feature, the rest of his click quickies rely on pressing CTRL and SHIFT simultaneously. With the '$' (dollar sign), the field's format is switched to Currency. The '%' (percent symbol) modifies the cell's value to a Percentage. The '^' (caret) turns the selected location into an Exponential. The "!' (exclamation mark) toggles the use of commas or decimals. The "@' (at sign) automatically inserts the current Time. The '#' (number sign) adds today's Date. The '&' (ampersand) draws a border around the current selection. The '_' (underscore) removes the border from the selection. The '*' (asterisk) selects the current region. Soon your mouse will be collecting dust (and your co-workers will be eating it).