|
MS Excel Printing Tips |
![]()
Site Information Confused? It Makes Sense if You Start at the Home Page
Discounts for Financial Planners and Money Managers New Financial Planner Starter Kit Professional Investment Portfolio Building Kit How to Buy Software in General Site Info, History, Ordering Security, Privacy, FAQs How to Get Your Brokerage Account Data to Download into our Investment Software About Getting Investment Software Approved by Broker Dealers and FINRA Financial Plan Software Support Free Downloads and Money Tools Free Sample Comprehensive Financial Plan Free Downloads, Investing Tips, and Tutorials Links to Other Personal Finance Websites The World's Best Free Retirement Calculator Other Free Retirement Calculators Our Free Financial Calculators Other Free Online Financial Calculators Free Business Owner Calculators Miscellaneous About Portfolio Management Software About Using Monte Carlo with Investment Software About Investment Risk Tolerance About Using a Discount Broker to Manage Your Own Money (and about custodians for advisors) |
How to Get Spreadsheets to Print Well One can rarely just click Print in Excel and get exactly what you want, so it has functions to make it print what you want. First, try resizing rows and columns. You can either drag the row or column borders, or right click on the row numbers or column letters, and then choose height or width. Or using the same menu, you can also hide or unhide rows or columns, or insert new rows or columns. Usually all it takes is resizing to get what you want. Once you get things to print the way you want to, save the file as the original template, so the next time you use it, you won't have to go through it again. This page is mostly only for the demos, because everything is password protected, and you can't change row and column sizes to make it print right. It's impossible to format all of the demos to print right because of all of the different kinds of printers. So using Excel to print the exact print ranges you set is the best way to print protected spreadsheets. When you get the actual programs, you can change row and column sizes to print right on your printer, then save, and then it will always print that way. If you click on a graph/chart you then selected just that chart. You can then print it on one page. Also, with Excel, if there's anything in a place outside the print area you want, then it will print a bunch of blank pages in order to print everything. So it's best to do a Print Preview first. Then count how many, or which pages, you actually want to print. Then you can only print the page(s) that you want to. Click File, Print... then in the Print Range section in the middle, click From: then scroll until 1 appears, then click the field To: then scroll until the last number of pages appears. Then click OK. First, do a Print Preview so you can see the dashed gridlines. Go to File, Print Preview. When it's up, click Close. Now the area is shown in dotted lines on the spreadsheet that will automatically print when you click Print (and not Print... which will bring up another menu, which is needed later). More than likely, this will not be the area you want to print. If you're using the actual program, and it's only off a little bit, then you can tinker with row and column sizes to make it right. If not, then you'll have to set and print via ranges manually. How to do this in Excel 2007 is below How To Manually Set and Print Ranges in pre-Excel 2007 Printing a range in Excel is just telling Excel only to print an exact area. This area is called a print range (or print selection, or print just the selected area or range). Words in italic font are actual menu selections in pre-Excel 2007: 1) Highlight the area you want to print. For example, put your cursor in the middle of cell A1, then drag it down and to the right until the area you want to print is only in the black or blue box (highlighted area). If you don't want the top left corner to be cell A1, then click where you want the top left corner to be. Once you've highlighted a range that you want to print, proceed to step 2. 2) Menus: File, Print Area, Set Print Area 3) Menus: File, Page Setup On the far left Page tab, in the middle there is a section called Scaling. Change Scaling from "Adjust to:" to "Fit to:" then click OK. 4) Menus: File, Print... (not Print, you want the one with the three dots after it). The bottom left section is the Print What section. Check Selection. Click OK. 5) Menus: File, Print Preview to see what's going on first. If it looks like it will print only the area you want, then you did it correctly. At this point, make a note of what page you actually want to print, to prevent it running amok and printing tons of blank pages or wasting paper. 6) Print (or Print... then select only the pages you want to print, then click OK). How To Manually Set and Print Ranges in Excel 2007 Words in italic font are actual menu selections in Excel 2007: 1) Highlight the area you want to print. For example, put your cursor in the middle of cell A1, then drag it down and to the right until the area you want to print is only in the black or blue box (highlighted area). If you don't want the top left corner to be cell A1, then click where you want the top left corner to be. Once you've highlighted a range that you want to print, proceed to step 2. 2) Ribbon menu: Page Layout, Print Area, Set Print Area Do a print preview to check it first before proceeding. 3) Ribbon menu: Page Layout, Click the tiny little arrow at the bottom right under, Print Titles The Page Setup menu comes up. 4) On the far left Page tab, in the middle there is a section called Scaling. Change Scaling from "Adjust to:" to "Fit to:" then click OK. 5) Click Print while still in the Page Setup dialog box. 6) The printing dialog box comes up. The bottom left section is the Print What section. Check Selection. Click OK. It should then print just the range you highlighted.
How to send financial plans to clients via e-mail, without sending the whole program is explained on the Excel help page. Tips on making and coping with Excel pie charts
Preparing to Prepare to Create and Present a Financial Plan I've seen dozens of financial planners fail and leave the business just because they failed to grasp the basic concept of this one tip: This is a good point to mention the tip that makes reading this page all worth it. If you're making financial plans and/or similar reports for clients, or employ a case writer that does, then make a sign and hang up over your phone that says: "Never ever call to make an appointment with a client to come into the office to get their plan/report until AFTER ALL of the work is done, and has been checked (preferably by someone else) more than once!" Also, put the same sign in the office you have client meetings in - this is because this blunder occurs most of the time at the end of a client meeting. Sales managers are always saying, "Don't end an appointment unless you have the next one booked." Never ever do that. How hard is it to call someone for an appointment that's expecting you to call anyway? Sales managers are just afraid that you suck so bad that the client will back out if you don't "seal the deal now" and/or ABC (always be closing). In reality, if you suck, then the client will blow you off regardless of when you set appointments. Whether you have an appointment set now, or plan to call for one in a few days AFTER you've made the plan, is irrelevant to when the client will blow you off. So, telling people you want to make sure the plan is good before you make the appointment will actually help not to get blown off, because it makes you look more responsible (especially to old seasoned investors that have experienced planners that can't even control their own workloads and schedules in the past. They know instant replay when they hear it). If you're been around the block as many times as we have, then you know about all of the dozens of things that come up to completely ruin meetings when financial plans are not done, have mistakes in them, you don't have all of the client data needed (taking notes on a yellow pad and lack of using proper Fact Finders is usually the culprit here), or you don't know what the hey the plan is telling you (so you can't explain it well), you just bought the needed personal finance software yesterday and haven't even read the directions yet, etc. etc. etc. If it wasn't for the severity of the consequences, it was comical to watch planners running around like a chicken with their heads cut off because of their inability to plan even their own schedules (and you want to charge me what to make a financial plan when you can't even plan your own day out right!?). But it's not comical if you're a case writer in an office full of these kinds of planners. Your case writers hate you because of this, so this is your wake up call to change. You'll see much higher quality work from your staff, and much less tension and ill will, and less turnover, once you've started to behave yourself when it comes to appointment setting. This brings up an old saying, "Lack of preparation on your part does not constitute an emergency on my part." Doing it the bad way creates an environment of constant crisis. All of that "dead time" you fear is best used to review the plan, do more research, read the financial software's directions (or do a better job shopping if you don't already have something), ensure you don't need to ask the client if anymore data is needed, having a partner look the plan over to see if it's correct, learn how to present the plan, looking over all of the details and preparing answers to questions and objections, and then arranging all of the paperwork just in case the plan goes well and you have to engage/sell product. Once you've done this a few times, you'll see that just the amount of this kind of work is probably enough to have to reschedule as it is (and then you haven't even done the work yet? And you haven't even bought the software tools to do the job yet either!?). If you misbehave by scheduling the appointment before the work is done (or even worse, even before you have a clue about what financial software to buy to do the job), then you'll be spending 200% of this time scrambling just to have anything ready by the time they come in. Then the plan will probably suck because of all of this. Even if the plan doesn't suck, all you have to do is appear to be fumbling when you present it to make someone want to "think about it" rather than executing. If you don't practice, then you're going to fumble. Then you'll lose the client, and all of the work, time, and money you put into it is wasted. Usually, one's lack of preparation leads to working all night to get a report done before a meeting. Then the deal will be lost because you'll sound half asleep, and the clients may assume you're a broken alcoholic or something. All it takes is one little thing like this, and the client will think you're incompetent and will not hire you. We've seen every cause and effect combination and permutation with this, so take this advice to heart. We get calls and sales every week from planners scrambling to get a report done before meetings the next day. To make a very long story very short, just never do this. The way to never ever fall into this fatal trap is to just follow one simple rule: "Never ever call to make an appointment with a client to come into the office to get their plan/report until AFTER ALL of the work is done, and has been checked (preferably by someone else) more than once!" The correct way to do this is very simple: You collect the needed data in the meeting, and then you say that you'll call to schedule the appointment AFTER you've input the data into the financial software, and then looked it over to ensure it's correct. Once you're 100% sure it's all good to go, THEN you'll call to set up the appointment to present it. As you'll see, even then there are dozens of other snags that only practice will eliminate. Even when things go the way they should like this, you'll find that most of the time, something will change enough to have to redo the plan again anyway. Usually this happens over what appears to be a minor detail - until you ask the client about it, and then it turns out you've just opened a whole new can of worms - making a plan redo necessary. So this rework will just be added to your 3AM scramble when you misbehave. It may seem like a bad or counter-intuitive thing to do at the moment, but following this one rule could literally save your life. Doing things the other way could lead to the one fatal mistake that could put a whole series of events into motion, eventually ending your career in the biz (we've seen this about five times so far, so that's why all this is here). Here's out motto on this for Star Trek fans: Take Scotty. If a job takes an hour, he'll tell the Captain it will take two hours. Then, if there are no snags and it's done in an hour, then he's a miracle worker. If there's a snag, and it takes two hours to do it, then Kirk got what he expected. On the other hand, and this is what most everyone does, if Scotty told the Captain it's only going to take 45 minutes, then there's only a small chance the job will be done on time, earning the Wrath of Kirk. The motto is that it's better to under-promise and over-deliver, than to over-promise and under-deliver. In this business, this goes double. End of rant. |
Personal Finance Software Modules
Fully Integrated Financial Planning Software Menu of Retirement Planning Software Asset Allocation Overview with Our Historical Returns Asset Allocation Models with Our Historical Returns Monthly Updated Mutual Fund Picks Financial Planning Fact Finders Investment Policy Statement Software Investment Software for Comparing 23 Methods of Investing Buy Term Life Insurance and Invest the Difference in Mutual Funds vs. Whole Life Marketing Seminar for Financial Planners Variable Annuity Tutorial and Optimizer Services Evolve into a Wealth Planner with this Unique Practice Management and Marketing System Fee-only Consulting for Consumers, Investors, and Financial Planners Building Custom Investment Benchmark Portfolios Coaching for Financial Planners Buy or Sell an Investment Management or Financial Planning Practice Asset Allocation for 401(k) / 403(b) and Similar Retirement Plans |
© Copyright 1997-2010 Tools For Money, All Rights Reserved