Excel

From Mesopoly 3.0
Revision as of 09:42, 13 January 2011 by Zlatko (talk | contribs)
Jump to navigation Jump to search

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