Difference between revisions of "Excel"
Jump to navigation
Jump to search
m |
m |
||
| Line 3: | Line 3: | ||
*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== | ==shortcuts== | ||
| − | *Ctrl+Shift+PlusSign = Insert row(s) | + | *Ctrl+Shift+PlusSign (not numeric pad) = Insert row(s) |
==Question and observations== | ==Question and observations== | ||
*color coding cells - not usefull for sorting | *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
