Excel help for the rest of us
You can save an Excel worksheet as a comma delimited file. I.e. the worksheet columns will be saved in the file separated by commas. This will allow you or someone else who has no Excel, to browse the file in any text editor.
To save the worksheet as a comma delimited file:
1. In Excel menu click File.
2. Click Save As. The Save As window will open.
3. In the Save as type drop down, select CSV (Comma delimited).
4. Any row in the worksheet will be transformed like this:
“ABC;7268;87368;XYZ;373″
The delimiter is either a “,” or “;” depending on your installation of Excel.
Applies to: Excel 2007, Excel 2010
It is fairly easy to insert a file into an Excel worksheet as an attachment. That file can be a word document, PowerPoint presentation or even another Excel workbook.
Follow these steps:
To insert a shape (rectangle, circle, line … etc.) follow these steps:
To install and load the Analysis Toolpak in Excel 2007 follow these steps:
If you want to copy data from Excel to Microsoft word then follow these steps:
In Excel
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 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.
To find cells that meet a specific criteria, for example cells with conditional formatting or cells which have data validation, proceed as follows:
Note:
You can search the entire sheet for the specified criteria or you can limit your search by selecting a range of cells.
All commands (icons) that deal with comments are found in the Review tab, Comments group.
To insert a new comment:
1. Select the cell where you want to insert the comment.
2. Click New Comment.
3. A new comment will be created. Type the required text then click outside the comment box.
4. The comment box will disappear but a small indicator will show on the top right corner of the cell.
To show a comment:
1. Select the cell where you have the comment.
2. Click Show / Hide Comment.
3. If you have multiple comments then you can click Show All Comments to show all.
Note:
If the comment is already shown and you click Show / Hide Comment, then the comment will be hidden.
To edit a comment:
1. Select the cell where you have the comment.
2. Click Edit Comment.
3. The comment box will be shown. Click on it then edit the text.
To format a comment:
1. Select the cell where you have the comment.
2. Click Edit Comment.
3. The comment box will be shown.
4. Select the text that you want to format then right-click.
5. Form the context menu select Format Comment.
6. in the Format Comment dialog box, select the formatting options that you want.
To move or resize a comment:
1. Select the cell where you have the comment then show the comment as explained previously.
2. Click the border of the comment box to show the sizing handles.
3. To move the comment, drag the border of the comment box, or press one of the arrow keys depending on which direction you want to move.
4. To resize the comment, drag the handles on the sides and corners of the comment box.
To copy a comment to another cell:
1. Select the cell where you have the comment.
2. In the Home tab, Clipboard group, click Copy (or just right click on the cell and select copy).
3. In the Home tab, Clipboard group, click the arrow below Paste, then select Paste Special (or just right click on the cell and select Paste Special).
4. In the Paste Special dialog box , under Paste, select Comments then click OK.
To delete a comment:
1. Select the cell where you have the comment.
2. Click Delete Comment.
3. The comment box and the comment indicator will both disappear.
To print a comment:
To print a comment check this post.