Print problem with Microsoft Excel 2008?
I wonder if you can help me with a problem i am having regarding editing an excel spreadsheet, which is driving me mad: I use a Mac Powerbook that has the Microsoft Excel 2008 programme installed. My secretary has a PC upon which is stored all the work files. My Mac is networked to her computer, so I can access all the work files and edit them, print them etc. No worries.
Any ideas as to how I can get it to print all the text on the first page ? I am thinking it is a simple setting adjustment but for the life of me, I cannot work out what to do.
Having spent a lot of time working with spreadsheets, I know exactly what problem you're encountering and, ironically, I can explain the solution in less words than you used to detail out exactly the problem you're facing with Microsoft Excel.
First, though, I want to point out that this is a problem (or 'feature' depending on how you look at it) that's been in just about all versions of Excel I can recall using, so it's nothing new that's showing up in Microsoft Office 2008 for Mac OS X, that's for sure!
The problem is that the print area hasn't encompassed all the active cells in your spreadsheet because of nuances in font sizing, column widths, default margins for your printer, etc etc.
The way to fix this is to simply select the entire active cell region by clicking and dragging, then choosing File --> Print Area --> Set Print Area:
Now you've defined what columns you want printed, you also need to see where the dashed line falls on the page: If it's between the fourth and fifth column (which is what I expect will occur) you need to make another tweak...
Choose File --> Page Setup... and you'll see:
As you can see where the cursor is pointing, you'll want to select "fit to" and choose one page wide by one - or more - pages long, depending on your spreadsheet.
Between these two settings you should be good to print!
More Useful Mac OS X Help Articles:
✔ Audacity can't find LAME library, I can't save Mp3?
Hey Dave. I read your article Audacity can't save mp3 audio files and am still puzzled because I downloaded the LAME Mp3 converter...✔ How to remove Dashboard as a "space" in Mac OS X Spaces?
I'm a big fan of the Spaces utility in Mac OS X that lets me have multiple virtual screens [see Set Up Mac...✔ Best place to buy a cheap MacBook laptop?
Hi Dave. I am looking for two gently used MacBook laptops for my teen daughters. Personal computers would greatly facilitate their studies as...✔ File too big error copying to USB flash drive on my Mac?
I'm baffled. I have a 16GB Kingston USB flash drive that I use on my Mac system and I'm trying to copy a...✔ Stealth image capture photo from webcam on my Mac?
Someone sneaks into my cubicle while I'm at lunch and takes candy out of my desk. Petty, but stupid too. I want to...
Let's stay in touch!
Sign up for my weekly AskDaveTaylor Newsletter and you'll receive even more tech and gadget help right to your inbox, along with exclusive news and industry updates. It's good stuff. I promise!
I do have a comment, now that you mention it!
Check This Out Too...
Look for Answers
All Our Categories
Apple iPad Help
Articles and Reviews
Auctions and Online Shopping
Blogs and Blogging
Building Web Site Traffic
Business and Management
Computer and Internet Basics
d) None of the Above
Google Gmail Help
Google Plus Help
Industry News and Trade Shows
iPhone and Cell Phone Help
iPod, Sony PSP and MP3 Player Help
Kindle Fire Help
Mac OS X Help
Pay Per Click (PPC) Advertising
Search Engine Optimization (SEO)
Shell Script Programming
Tech Support Video Help
The Writing Business
Twitter, LinkedIn and Social Network Help
Unix and Linux Help
Video Game Tips and Help
Windows PC Help
Find Me on Google+
ADT on G+