Difference between revisions of "Excel"
Jump to navigation
Jump to search
m |
m |
||
| Line 2: | Line 2: | ||
*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 = Insert row(s) | ||
==Question and observations== | ==Question and observations== | ||
*color coding cells - not usefull for sorting | *color coding cells - not usefull for sorting | ||
Revision as of 09:42, 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 = Insert row(s)
Question and observations
- color coding cells - not usefull for sorting
