|
SPREADSHEET TIPS FROM AN EXCEL ADDICT (Online Edition) Helping Average Spreadsheet Users Become Local Spreadsheet Experts A Free Weekly Publication of TheExcelAddict.com Publication Date: July 14, 2004 I respect your privacy and promise not to abuse this privilege. This newsletter is sent only to those who have requested it. If you no longer wish to receive my tips, you'll find simple instructions at the bottom of every newsletter. CONTENTS
been receiving my newsletters regularly in your email.
GREETINGS FROM CANADA Top
Hi Fellow Excel Addict, Well, my team won that soccer tournament last weekend, they did find out about my birthday, and I DID get ice water down my neck. However, it was very satisfying to see my team play so well in their first tournament of the summer. All those practices throughout the winter seem to have paid off. So, how are things going for you with Excel? One by one, these tips will help you become the 'local Excel expert.' Keep me informed of your progress. If you have any questions, don't hesitate to email me. Until next week ...
Keep on Excelling,
P.S. VERY IMPORTANT Please remember to include "TheExcelAddict" in the Subject line of any email you send me. This will help it stand out in the flood of junk email I have been receiving lately. EXCEL SCREENSAVERS: Don't forget to check out the cool Excel screensavers in the new downloads section of my website. http://www.TheExcelAddict.com/downloads
DISCOVER NEWFOUNDLAND AND LABRADOR, CANADA: EXCEL "QUICK TIP" Top Creating Page Breaks I see many beginning Excel users, and often people who have been using it for some time, inserting blank rows in their worksheet to get their reports to print properly. On multiple-page worksheets, some pages may print in the middle of a section. To get these pages to print the way you want, you can insert page breaks that tell Excel where to start printing a new page. Just click on the row heading (i.e. select the whole row) where you want a new page to start printing and choose Insert, Page Break. There's no need to insert blank lines.
If you would like to benefit from the wisdom of 'America's
Foremost Business Philosopher' check out his FREE weekly E-Zine.
Jim Rohn's Weekly E-Zine is a free weekly publication dedicated
to providing valuable insights and information that can help
empower and improve both your business and personal life. Find
out more at
http://www.TheExcelAddict.com/rd/jimrohn.htm.
REFERRAL CONTEST Top Each month I select a name from everyone who refers my website or newsletter to a friend or colleague and they receive a cool prize from TheExcelAddict.com. All you have to do to qualify each month is send an email to your Excel friends and associates recommending my newsletter and website. Include a BCC to francis@TheExcelAddict.com and for each person that you refer, your name will go into the draw. Please, recommend only to people you know and who are Microsoft Excel users. All you have to do each month is click here to recommend my newsletter and website to a friend. For each person that you refer, your name will go into the draw. The more Excel friends you refer, the more chances you have of winning, but please, recommend it only to people you know and who are Microsoft Excel users. If you use the 'Tell A Friend' link at www.TheExcelAddict.com you could win $10,000 and you will also qualify for my Referral Contest draw. *** Each monthly winner will be notified by email and will have 10 days to reply with a shipping address. If I don't receive a reply within 10 days, another name will be drawn.
"HOW TO EXCEL" MINI-TUTORIAL Top Page Break Preview Often you have to go through trial and error to get multiple page reports to print the way you would like. It can sometimes be tricky getting the pages to break at the right place. Print Preview will show you how your pages will print, but changing page breaks (Insert, Page Break) and switching back to Print Preview can sometimes be awkward. A much more user-friendly solution for getting your pages to break at just the right places is to set and adjust your page breaks in Page Break Preview mode. In Page Break Preview you are given a view of your worksheet with page breaks shown as blue lines. Blue dashed lines show automatic page breaks and solid blue lines indicate manual page breaks (i.e those set by the user). The best part of Page Break Preview is that you can easily adjust page breaks and instantly see how the changes affect the printing of your report. To set or adjust page breaks in Page Break Preview:
EXCEL ADDICTS AROUND THE WORLD Every week this newsletter is being read by Excel Addicts in: Albania, Antarctica, Antigua and Barbuda, Argentina, Australia, Austria, Bahrain, Brazil, Canada, Chile, China, Colombia, Cote d'Ivoire, Croatia, Cuba, Cyprus, Denmark, Dominican Republic, Ecuador, El Salvador, Estonia, Finland, France, Germany, Great Britain, Greece, Guam, Hong Kong, India, Indonesia, Ireland, Israel, Italy, Jamaica, Japan, Kazakhstan, Korea, Malaysia, Mauritius, Mexico, Nepal, The Netherlands, New Zealand, Nicaragua, Nigeria, Norway, Pakistan, Peru, Philippines, Portugal, Puerto Rico, Reunion, Romania, Saudi Arabia, Singapore, Slovenia, South Africa, Spain, Sweden, Switzerland, Turkey, Uganda, Ukraine, United Arab Emirates, United States, Vanuatu, Venezuela, Viet Nam There are tens of millions of other Microsoft Excel users all over the world. The vast majority of them have a very limited knowledge of Excel's capabilities. My goal is to share this information with everyone I possibly can and help them to benefit from Excel's amazing capabilities.
Please help me spread the word about my newsletter. If you know other Excel users, please tell them about "Spreadsheet Tips From An Excel Addict". I'm sure they'll appreciate it. Maybe you know someone who supervises or employs many Excel users. That's where your referral could have a big impact. VERY IMPORTANT: Please refer only people you know personally, who use Microsoft Excel and would benefit from this newsletter. BONUS "NON-EXCEL" TIP Top Printing Web Pages That Are Too Wide It happens to me a lot, so I'm sure you must have encountered this problem also. You try to print a web page but it's too wide, and the right side of the page gets chopped off. The simplest solution is to print the page in landscape mode. In Internet Explorer, select File, Page Setup, choose Landscape, and click OK. Now print the page. SUBSCRIPTION MANAGEMENT Top This online version of Spreadsheet Tips From An Excel Addict is available only to subscribers of my free email newsletter. Each week, in addition to the email version of my newsletter, you will be emailed a special link to the online version. If you haven't subscribed yet you can click here to subscribe NOW or you can send a blank email to TheExcelAddict@DemandMail.com
Email me @ francis@TheExcelAddict.com is a FREE weekly publication of TheExcelAddict.com. Copyright © 2004, Francis J. Hayes All Rights Reserved. 8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630 | ||||