Multiple Duplicate Worksheets
Click on the first worksheet tab and hold down the Shift key. Keeping the Shift key down, click on the last worksheet. They should all appear white, rather than gray. Now, just start typing. What you do on one sheet will also be on the remaining selected worksheets.
Populate Several Cells at the Same Time
It’s always a good idea to test your worksheets with predictable data. So if you’d like to populate the first 4 columns and 4 rows with the value of 100, you’d select or highlight A1:D4. Type 100 and Ctrl+Enter.
Do you often repeat several location names, department names or other text items? Make it a no-type solution with Custom Lists and AutoFill. Type the list in the order you’d like to see it. Select it and click File, Options and Advanced. Scroll down until you see the Custom Lists button. (In Office 2007, click the Office Button, Excel Options and the Edit Custom Lists button should be right there in Top Options!). After clicking the button, click the Import button to import your new custom list. Now, type any of your entries and use the AutoFill handle, and you’ll see your list values populate the cells like any other AutoFill entry.
Like what you've read? ...Republish it and share great business tips!
Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...
We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.
The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.
" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/33333/3-no-type-tips-for-excel "