To copy data and then paste it as a picture (image) follow these steps:
Select the range you want to copy.
In the Home tab, Clipboard group, click Copy.
Select a cell in the range where you want to paste the picture.
In the Home tab, Clipboard group, click on the arrow below the Paste icon, point to As [...]
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”.
Fortunately you can hide these error indicators through Excel Options.
Click the Microsoft Office button.
Click Excel Options.
In the left pane of Excel Options click Formulas.
In the Error Checking [...]
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.
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 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 [...]
