Daily Tips and Tricks Special Delivery

Sign up for other newsletters | Unsubscribe | Update your profile Paste into Non-sequential Cells in Excel You can use the CTRL key for multiple selections. Sometimes, you want to copy a formula or piece of data into a series of non-sequential cells in Microsoft Office Excel. You can do this quickly without having to paste into each cell individually. 1. Copy the data from the source cell. 2. Hold down the CTRL key as you click to select each destination cell. 3. After all the cells are highlighted, paste the data by pressing CTRL+V. You have to paste only once. Similarly, you can type data into a series of cells simultaneously. 1. While holding down the CTRL key, click all the cells that you want to type the same text (or value) into. 2. Type the entry, and then press CTRL+ENTER. The text will be added to all the selected cells. Customize Which Commands Appear on the Status Bar The Status bar is the bar that appears across the bottom of the screen in many programs and provides information about the active file. For example, the Status bar in Microsoft Office Word provides information such as active page number, number of pages in the document, and word count. In most cases, you can also click the Status bar option for more information or to perform an action. For example, click Page in the lower-left corner of Word to access the Go To tab of the Find and Replace dialog box. In several of the 2007 Microsoft Office system programs, including Word, Excel, PowerPoint, and Access, you can customize what appears on the Status bar. To do this, right-click the Status bar, and then click to show or hide the options you want. • 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