Difference between revisions of "Excel"
Jump to navigation
Jump to search
m |
m |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | ==useful Excel stuff== | ||
*to edit cell press F2 (keyboard shortcut replacing doubleclick on the cell) | *to edit cell press F2 (keyboard shortcut replacing doubleclick on the cell) | ||
*to use top row as dropdown sorting menu, use Data > Filter > Autofilter | *to use top row as dropdown sorting menu, use Data > Filter > Autofilter | ||
| + | ==shortcuts== | ||
| + | *Ctrl+Shift+PlusSign (not numeric pad) = Insert row(s) | ||
| + | ==Question and observations== | ||
| + | *color coding cells - not usefull for sorting | ||
Latest revision as of 09:43, 13 January 2011
useful Excel stuff
- to edit cell press F2 (keyboard shortcut replacing doubleclick on the cell)
- to use top row as dropdown sorting menu, use Data > Filter > Autofilter
shortcuts
- Ctrl+Shift+PlusSign (not numeric pad) = Insert row(s)
Question and observations
- color coding cells - not usefull for sorting
