Paste data as a picture (image) in Excel 2007

To copy data and then paste it as a picture (image) follow these steps:

  1. Select the range you want to copy.
  2. In the Home tab, Clipboard group, click Copy.
  3. Select a cell in the range where you want to paste the picture.
  4. In the Home tab, Clipboard group, click on the arrow below the Paste icon, point to As Picture and click Paste Picture Link.

XL7PastePict

How to hide error indicators in Excel 2007 cells

I find it annoying sometimes when I enter a correct formula in a cell and Excel gives me an error like “Inconsistent Formula” or “Formula Omits Adjacent Cells”.

XL7Error

Fortunately you can hide these error indicators through Excel Options.

  1. Click the Microsoft Office button. XL7Office
  2. Click Excel Options.
  3. In the left pane of Excel Options click Formulas.
  4. In the  Error Checking section, clear the Enable background error checking check box.
  5. Click OK.

How to change Excel 2007 default file location

To change Excel 2007 default file location, follow these steps:

1. Click the  Microsoft Office Button.

2. Click Excel Options.

3. In Excel Options window (left side) click Save.

4. In the text box labeled Default File Location , specify the path for the required location.

XL7Save

Save an Excel 2007 workbook to Excel 97-2003 format

To save an Excel 2007 workbook to Excel 97-2003 format follow these simple steps:

1. In Excel 2007, open the workbook that you want to save in Excel 97-2003 format.

2. Click the Microsoft Office Button XL7Office and point to the arrow next to Save As.

3. Under Save a copy of the document, click Excel 97-2003 Workbook.

The file will be saved in the Excel 97 – Excel 2003 file format. This will make it possible to open the file in versions of Excel 97 through Excel 2003.

XL7to2003