If you have problems reading this newsletter in your email program, you can read it online in your browser at:
http://www.virtualservices.com.au/news/10_02.htm
![]() |
|||||
| Issue no 21 | February 2010 | |||||
My favourite linksWeb Grammar's Food for ThoughtAn archive of newsletters containing never ending compilation of a wealth of URLs covering, Arts, Grammar, Reference-General, Science & Technology and Writing & Journalism. http://www.webgrammar.com/foodforthought.html Technical tipsMicrosoft ExcelFind cells that are formatted with a specific colourWant to find cells that are formatted with a specific colour? Dead easy if you are using Excel 2003 or Excel 2007.
Note: This process will also work with cell text colours. Microsoft WordClick and TypeWord has a Click And Type feature that will allow you to start typing anywhere on a blank page. However you must first of all enable this feature.
To use this feature you need to be in Print Layout view. Suppose you want to type a title in the middle of the first page:
Inserting non-text items works this way too. To place a clip art picture in the bottom right corner of your page:
Microsoft AccessExporting a report to Word using Office LinkYou probably have the need to periodically supply data to people who don't use Access. Even if they do, someone working remote from you, or who is travelling may be unable to connect to a particular data source. Of course, you could send hardcopy reports, but they can be inefficient to work with and are costly to distribute. Plus they waste trees. So why not convert that report into a file that users can open with Word, and send it as an e-mail attachment. The recipient can edit the results and incorporate the report into other documents. The easiest is to use is the little known Office Links feature:
Note that the file you have created will be in a Rich Text Format (RTF), so most of the report formatting will be preserved. However, the file will not include any graphical objects that existed in the original reports. These, and other, tips have been garnered from many sources over the years. My grateful thanks to the originators. |
|
eNewsletter sign-up
Enter your email address below and you'll receive CVS Office News monthly via email, plus a link to your no cost Productivity Report. Free consultation
Click here to request a complimentary half-hour consultation. Learn fresh tips!
Follow Terence's Top Tech Tips — 50+ tips to save time and increase your efficiency with MS Excel, MS Word and more!http://tinyurl.com/3twrzgq Having problems coping with all that paperwork?Turn those piles into files and find any document in 10 seconds or less! http://tinyurl.com/64ag2 Time management10 Tech solutions to improve your productivityBy: Chris Brogan http://www.chrisbrogan.com/ Use computer shortcuts and launches. For Macs, it’s Quicksilver . For Windows, I found 10 Quicksilver alternatives listed here. (Disclaimer: I’m not good with Quicksilver. I use Spotlight still). Don’t read blogs directly from the website. At least not first. Start in a good feed reader. I prefer Google Reader. It’s fast, has keyboard shortcuts, and is flexible in letting me bookmark, share, and email posts that I find useful. Find extra time and use it. One way is to use Jott on your phone to send brief messages, to leave yourself reminders, and to take notes for future use. Set up text replacement. This lets you type a few letters and get back several words easily. For Macs, use TextExpander. For Windows, try Texter. Keep good notes. I’m enamored with EverNote. I’ve used it to outline documents, plan conference content, store small lists of email addresses, and even tried the optical recognition feature for photos. It’s worth checking out. ~~~~~~~~~~ For free Time Management articles to help you get more done in less time, with less stress, visit our website now at: http://www.balancetime.com Don Wetmore | Professional Speaker | Productivity Institute Time Management Seminars 127 Jefferson St, Stratford, CT 06615 | (203) 386-8062 (800) 969-3773 | Fax: (203) 386-8064 Email:ctsem@msn.com DISCLAIMER: Neither Cyberspace Virtual Services nor Terence Kierans endorse the quality of any products obtained by you as a result of following any link or recommendation published in this newsletter. Please perform your own due diligence before purchasing any product. |
|||
| © 2000-2011 Terence Kierans, Cyberspace Virtual Services | Recommend us | Contact us |