If you need to enter the same data into multiple cells in Excel, it’s easy with this simple trick.

1. Select the cells where you need to enter the data.  If the cells are not contiguous, use the CTRL key to select.
2. Type the data you want into the last cell you select.
3. Press CTRL + ENTER.
4. Excel will enter the same data into every selected cell.

Selecting a large range in Excel by dragging the mouse can be difficult.

Try using the SHIFT key when you select a range that extends beyond what is displayed on your screen.  You can do this two ways:

1. Click into the cell in the upper left corner of the range.
2. Click into the Name Box and type the cell in the lower right corner of the range.
   
3. Press SHIFT + Enter.
4. Excel will select the entire range.

As an alternative, you can start by clicking into the upper left corner of the range, then hold down the SHIFT key, while clicking into the cell in the low

er right corner of the range.

The location of the Templates folder varies in different versions of Windows, so here is a quick way to access it even if you don’t know where it is:

1. Click the Start button or open the Run… box:
2. Type:  %appdata%\Microsoft\Templates
3. Your Templates folder will open in Windows Explorer.

The folder contains the normal template used in Word, any custom or downloaded PowerPoint templates, and custom Excel, Outlook, and Publisher templates.

Ctrl + ; – Puts the current date into the active cell; does not update automatically.

Ctrl + Shift + ; – Puts the current time into the active cell; does not update automatically.

Ctrl + A – Selects all the cells in the worksheet.

Ctrl + Page Up – Makes the previous sheet in the workbook the active worksheet.

Ctrl + Page Down – Makes the next sheet in the workbook the active worksheet.

F2 – Lets you edit the cell without double-clicking on it.

F11 – Creates a chart on a separate sheet from the selected data.

Microsoft Word 2007 lets you create blog postings and publish them directly from Word. (Actually, I’m doing it right now!) Using Word is generally easier than most blogging software, which requires users to edit HTML code.

To create a blog posting from Word:

1. Click the Office button.
2. Select New, select New blog post, and then click the Create button (lower right corner).
3. Click the Register Now button in the dialog, and then select your Blog provider from the drop-down list.
4. Enter the appropriate information into the New Blogger Account dialog box.
5. Click the Picture Options button if you want to select a picture provider from the drop-down list.
   (If you don’t use a picture provider, select None-Don’t Upload Pictures.)
6. Type your blog posting, and click the Publish button on the Ribbon to publish it to the blog. (When you publish, Word will prompt you for your Username and Password.)

By default, Office 2007 saves files in new XML-based formats. Word uses the .docx and .docm extensions. Docx files do not support macros, while docm files are macro-enabled. Presumably, this is to cut down on the number of viruses aimed at Word documents.

Similarly, Excel uses the .xlsx and .xlsm extensions, and PowerPoint uses the .pptx and .pptm extensions. Access has also changed its file format to an XML-based format, using the .accdb extension.

However, the new formats are not backward-compatible. Therefore, people using any older versions of Office will not be able to open files saved in the new formats. Since it will be some time before a majority of users have Office 2007, we recommend saving files in the old formats if you intend to distribute them to other users.
online pharmacycialislevitrasomaviagra
To save an Office 2007 file in an older format:

1. Click the Office button.
2. Select Save As.
3. At the bottom of the dialog box, under Save as type:, select Word 97-2003 Document (*.doc).

Office 2007 now lets you save any document, presentation or spreadsheet as a PDF (without having to purchase Adobe Acrobat). However, you have to download a plug-in to add this functionality.

You can download the free plugin from Microsoft at:

http://www.microsoft.com/downloads/details.aspx?FamilyId=4D951911-3E7E-4AE6-B059-A2E79ED87041&displaylang=en

After you have downloaded the plug-in, to save a file as a PDF, click the Office button and select Save As | PDF or XPS.