Microsoft Office Productivity

There may be times when you receive a workbook from another individual to work on.  It is possible that a portion of the grid lines on the worksheet (or all of the gridlines) may not be
visible.  There are a couple possibilities as to why the gridlines are not visible.  Gridlines can easily be turned on and off with using a setting in Excel 2007 & 2010.  There are additional videos available for working with other versions of Microsoft Excel.
 

In Excel 2010 you can now use conditional formatting to easily identify negative numbers with conditional formatting.  There are several options.  In this example we will use “Data Bars”
 

If you would like to move the location of a Column or Row in Microsoft Excel, there are some great keyboard shortcuts that can save you some time.

If you use the “Wrap Text” function in an Excel worksheet it may wrap the text but the row height may not be high enough to display all the text in the cell.  This can be fixed easily with just a few steps.
 

Sometimes you may want to insert text into a worksheet.  You may want to easily distinguish it from the other data in your worksheet.  A textbox can be a useful tool.