Help, please! I have an Excel problem.

12 years ago

For the work I do at home for a lawyer, I use the same Excel template over and over, saving my work under different file names. Each sheet has seven columns with headings. At the bottom of each sheet is a Page Total row followed by a Grand Total row--but the Grand Total rows don't get filled in every time.

Usually I finish a project before the template runs out. It's fairly large--about 500 rows or so. If it looks as though the project is going to run longer, I copy a blank sheet (headings at the top, then 25 blank rows, then the Page Total and Grand Total rows at the bottom) and paste it in several times to enlarge the template.

This time the project was big, and I failed to recognize that I needed more room. I didn't discover this until I had way overshot the template--by about 75 rows.

I copied one of the existing header/footer sections and pasted it into my completed rows in the proper places. Then I went to View --> Page Break Preview and adjusted the page breaks. It all looked okay on my screen. But when I printed these pages some of the text is huge. On my screen it's all 9 or 10 pt. type, but on paper it's a mess, with the font in certain rows much larger than it's supposed to be. I don't see a pattern for this.

Can someone please tell me how to correct these monster rows? Thank you!!

Sort by:Oldest

Comments (6)

Fun2BHere
12 years ago
Have you already tried reformatting the whole spread sheet to a specific font size? (Home:Cells:Format Cells:Font)
0
Tally
12 years ago
Alisande, check your page setup. If your page setup is set to 100%, smaller amounts of rows may appear larger when printed because the computer will assume 100% for every page.

Try adjusting the scaling on your page setup. Select Fit to put 1 page wide and leave the length blank. This may adjust your page breaks though. Print it and see how it looks. If the scaling looks correct then you may have to add or delete rows to get the pages to break where you want them to.
0
Related Discussions
I have problem and I need help
Q
Comments (4)
Aha - I looked around - and the list is long - and they all look the same - sunscald, drafty window, too cold, cold water used for watering, cold water drops on the leaves - and there is one I didn't hear before - zinc deficiency. Anyway - I have a plant - Santpaulia confusa - that grows like a moppy weed it is, blooms all the time - annd always develops yellow spots with yellow veins. What it wants - I do not know - and it doesn't pass this spotting t the neighbours. You have your plant for several months - and leaves live for a year - so if there were some unlucky curcumstances to damage the leaves - the plant will grow out of it. I.
...See More
Could someone help me please? I have a BIG problem
Q
Comments (19)
What were you planning to do with the leaves if you did have a shredder? If you were going to layer them on your garden beds, you could put a tarp over them and then get a load of mulch delivered (free from tree trimmers). As you distribute the leaves to your garden beds, you could cover them with mulch to keep them from blowing around. A lot more work, though. If you were going to set them aside to make leaf mold or as a compost brown, you could use a tarp, and add N occasionally (liquid gold, aka urine, is the cheapest source). Or you could set up some circles of fencing to hold the leaves.
...See More
2 different problems, and i dont have an answer, please advise.
Q
Comments (16)
Cheap bare-root plants, or any bare-roots planted after April, often suffer from canker and dieback. They have been held in cold storage since November. If conditions are not perfect, they can suffer freeze damage or dehydration. Discount roses have not been carefully inspected, culled, and pruned-- or they may be culls from a premium operation. Just prune the bad canes off, or to a bud eye at least 1" below any black or yellow bark. It looks like the healthy areas are growing well, so I'd leave them alone. Obviously the cane underlying the dead area on the tree rose has been physically injured so it cannot function. It is broken, bored by an insect, or girdled by a canker lesion. Water on leaves does not cause burning-- that's an old wives tale.
...See More
Demo done 'Houston We Have A Problem!' Please Help!
Q
Comments (15)
As a fellow sufferer of middle age (beats the alternative) the sagging isn't going to stop (as any number of pulled to tight, frozen faced celebrities can attest). I wouldn't do tile, it won't give with the next sag. Get something easy to stand on that will give a little f something else should settle or sag. It will be better for you in the long run. Cork and linoleum offer lots of versatility, great colour choices and may set off you beautiful cabinetry better than more wood.
...See More
alisande
Original Author
12 years ago
Thanks for helping, you two. I swear, I don't understand why this is happening.

Fun2BHere, if I click on one of the cells that are printing large, it says the font is 10 pt. (or 9 pt if that's what I specified). I haven't found even one cell that's formatted for the wrong font size. I hesitate to reformat all of them to one size because I changed some to 9 and some to 8 as I always do. However, I may do that in desperation anyway--maybe put them all at 9 pt.

Tally, my page set up was set to 85%. I followed your instructions, and everything printed a little bigger. I tried changing the setting to 100% and 90%, but put it back to 85%.

While printing a specific page over and over, a couple of the monster lines of text reverted on their own to normal size, while a couple of others inexplicably got bigger. Huh??
0
Jodi_SoCal
12 years ago
Susan, do you have the current driver installed for your printer?

Jodi-
0
alisande
Original Author
12 years ago
I assume I do, Jodi, but I can't answer with any certainty. My printer is a 9-year-old HP laser workhorse, and I'm sure the drivers were updated when my computer changed a few years ago. I've never had a printing problem.

I went to this Microsoft troubleshooting page and followed the instructions to close and then open Excel. I thought it had solved the problem (yay!), but all it did was cut down on the number of bad rows (boo!).

The problem does NOT show up in Print Preview, BTW.
0
alisande
Original Author
12 years ago
I just followed Fun2BHere's suggestion to change the font size throughout the whole workbook. I changed it to 9 pt., and that seems to have done the trick. I wish I knew what caused this problem I never had before, but I'll settle for a fix. Thank you!!
0

Help, please! I have an Excel problem.

Comments (6)

Fun2BHere

Tally

Related Discussions

alisande
Original Author

Jodi_SoCal

alisande
Original Author

alisande
Original Author

COMPANY

BUSINESS SERVICES

GET HELP

CONNECT WITH US

Help, please! I have an Excel problem.

Comments (6)

Fun2BHere

Tally

Related Discussions

alisandeOriginal Author

Jodi_SoCal

alisandeOriginal Author

alisandeOriginal Author

COMPANY

BUSINESS SERVICES

GET HELP

CONNECT WITH US

alisande
Original Author

alisande
Original Author

alisande
Original Author