15 Excel Tips on Improving Productivity Using Excel

  1. To format a number as SSN, use the custom format code “000-00-0000?…
  2. To format a phone number, use the custom format code “000-000-0000?…
  3. To show values after decimal point only when number is less than one, use [<1]_($#,##0.00_);_($#,##0_) as formatting code…
  4. To remove grid lines from excel worksheet, go to menu > tools > options > and un-check grid lines option. (Excel 2007: office button > excel option > advanced)…
  5. To hide a worksheet, go to menu > format > sheet > hide…
  6. To align multiple objects, like charts, drawings, pictures use drawing toolbar > align and select alignment option…
  7. To freeze rows on top, select the a row and use menu > window > freeze panes…
  8. To disable annoying formula errors, go to menu > tools > options > error checking tab and disable errors you don’t want to see…
  9. To change the shape of cell comments from rectangle to some other symbol, select the comment, go to drawing tool bar and change the shape from there…
  10. To transpose a range of cells, copy the cells, go to empty area, and press alt+e+s+e…
  11. To save data filter settings so that you can reuse them again, use custom views…
  12. To select all formulas, press CTRL+G, select “special” and check “formulas”
  13. To select all constants, press CTRL+G, select “special” and check “constants”
  14. To clear formats from a range, select menu > edit > clear > “formats”
  15. To move a chart and align it with cells, hold down ALT key while moving the chart

,

No comments yet.

Leave a Reply

*