Daily Tips and Tricks Special Delivery

Sign up for other newsletters | Unsubscribe | Update your profile Fill In the Blanks in Spreadsheets the Easy Way 1. Select all the rows in your Microsoft Office Excel spreadsheet data set. 2. On the Home tab, in the Editing section, click Find & Select, click Go To, click Special, click Blanks, and then click OK. 3. Click the equal sign (=) on the toolbar, select the cell above, and then hold down the CTRL key while you press ENTER. Blanks in the spreadsheet will be filled automatically. 4. Copy all the data, click Paste Special, and then click Values. This will overwrite the formulas and enable you to sort the data by filling in each empty cell with the same information as the one above. This tip will work on any size of data set. RSS Feeds Really Simple Syndication (RSS) feeds are an easy way to subscribe to interesting information like world news, sport scores, or blogs. With Microsoft Office Outlook 2007, it's easy to start adding and reading RSS subscriptions. 1. Click the mail folder called RSS Feeds. 2. Choose a feed that interests you from the RSS Feeds content directory. 3. Outlook prompts you to add this feed to your list. Click OK. 4. Outlook creates a specific RSS subscription folder for this feed below the main RSS Feeds folder. Note: When using Office Outlook 2007 with Windows Internet Explorer 7, you can keep a synchronized list of subscriptions between the two programs. • 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 Sign up for other newsletters | Unsubscribe | Update your profile © 2008 Microsoft Corporation Terms of Use | Trademarks | Privacy Statement