In Microsoft Excel 2007, go to the Home Tab > in the Editing Group select Find and Select. Choose Go To Special… > select Blanks and then ok. Then in the Cells Group > use the down arrow on the Delete command and chose Delete Cells, then Shift cells up. That will do it.
The AutoCorrect feature in Microsoft Office is a great tool! [Office 2003 = Tools menu, click AutoCorrect Options. Office 2007 = Click the Microsoft Office Button , and then click Word Options. In the Word Options dialog box, click Proofing, and then click AutoCorrect Options.]
F2: Edit a cell's contents. Ctrl-1: Open the Format Cells dialog. Ctrl-Page Up: Move to the next sheet in the workbook. Ctrl-Page Down: Move to the previous sheet in the workbook. Ctrl-Shift-": Copy the value from the cell above into the current cell. Ctrl-': Copy the formula from the cell above into the current cell. Ctrl-R: Fill contents of active cell into selected cells to the right. Ctrl-D: Fill contents of active cell into selected cells down. Ctrl-`: Toggle between showing cell values and formulas in cells.
Have you ever wanted to share a document with someone who doesn't have the same software as you. Or, maybe you wanted to share a document with someone but you want it to be unchangeable. The PDF file format is a great solution to both of these senarios. Almost every computer can open a PDF file now, and if they can't all they need is the free Adobe Reader from http://www.adobe.com to open a PDF file.
Here's how to make just about any file into a PDF:
.jpg)
