microsoft: 2008-09-28

Saturday, October 4, 2008

Daily Tips and Tricks Special Delivery

Attach Files to Pages of Notes in Your Notebook
You can drag or insert files onto a page in your notebook. The file appears as an icon, as in Windows Explorer, and Microsoft Office OneNote keeps track of the location of the original file (even if you move it around), so you can easily open it at any time.
1. Drag the file that you want to attach from Windows Explorer onto a OneNote page.
2. When you release the mouse button, you'll see a dialog box. Select the Insert a copy of the file onto the page check box.
3. To open the file, double-click the file icon.

Using the To-Do Bar
You can organize your daily activities by using the new To-Do Bar in Microsoft Office Outlook. The To-Do Bar, located on the right side of your Outlook Inbox, brings together tasks, calendar information, and e-mail messages flagged for follow-up into one view. Now you don't need to switch back and forth between your Inbox, diary, and task list.

•	Tips and Tricks Web site
•	Microsoft Office Online
•	Help

Privacy note: Microsoft respects your privacy and that of your friends. Please do not use the Tell a Friend button to send mail to more than 10 people. Microsoft cannot collect any data about the people you send mail to unless they sign up for Tips and Tricks Special Delivery.

To cancel your subscription to this newsletter, reply to this message with the word "unsubscribe" in the subject line. You can also unsubscribe at the Microsoft.com Profile Center. You can manage all your Microsoft.com communication preferences at this site.

Legal information

Microsoft Corporation
One Microsoft Way
Redmond, WA 98052

Friday, October 3, 2008

[+/-]

Daily Tips and Tricks Special Delivery

Create Random Numbers
Sometimes it's useful to have random numbers in a Microsoft Office Excel spreadsheet—even if it's just for creating test data. To put a random number in a cell, type the formula =RAND(). For bulk random numbering, copy that formula to a large number of cells—each will be random.

Reuse Tables in Word
To save a table in Microsoft Office Word for reuse in the future:
1. Select the table that you want to save.
2. On the Insert tab of the Ribbon, click Table, point to Quick Tables, and then click Save Selection to Quick Tables Gallery.
3. In the Create New Building Block dialog box, give the table a name, classify it with some basic parameters, and then click OK.

To reuse a saved table:
1. Position your cursor where you want to insert a saved table.
2. On the Ribbon, click Insert, click Table, and then point to Quick Tables.
3. From the list, click the table you saved previously. This table will now be inserted into the document.

•	Tips and Tricks Web site
•	Microsoft Office Online
•	Help

Thursday, October 2, 2008

[+/-]

Daily Tips and Tricks Special Delivery

Creating Forms
To assist with data entry, Microsoft Office Access 2007 offers different types of forms. To create a simple form:
1. Open the table that has the fields you want to include in your form.
2. On the Ribbon, on the Create tab, click Form.

The split form is new to Office Access 2007, and it enables you to see both a datasheet view of your data and a traditional form view of your data at the same time. You can use the splitter bar to adjust the size of the datasheet.

Dragging Your Files to Outlook
When you select a file and drag it to Microsoft Office Outlook, the action that Outlook takes depends on which folder you place the file in. If you drag the file to the Tasks folder, Outlook will create a new task with your file attached. If you drag it to the Calendar folder, Outlook will create an appointment where you placed the file, and your file will be attached. If you drag it to the Mail folder, Outlook will create a new e-mail message with your file as an attachment.