Monday, December 13, 2010

Today in Excel 2007

Past Special>Formats is useful when you spend time setting up a sheet with customized formatting and then you need to make the sheet expand over/down.

Data>Remove Duplicates is useful when you have rows containing line items and you want, say, all the “names” in one of the columns.  It’s quicker than making a pivot table, which is the other way I know how to do it.

Home>Wrap Text can be thought of as a button with the same functional semantics as Bold or Underline, that is, it’s either on or off for any given position in the document.  It does what it says – if you enter more data than can fit in a column horizontally, and wrap text is in the ON state, then the text will wrap, taking up additional vertical space.

No comments:

Post a Comment