Help, please! I have an Excel problem.

13 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
13 years ago
Have you already tried reformatting the whole spread sheet to a specific font size? (Home:Cells:Format Cells:Font)
0
Tally
13 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
Having a few problems!! Please Help!!
Q
Comments (3)
Lori, there 3 things for you to do: 1. get a shoplight and hang it 10 inches above your Lovelies. Shoplight in Walmart is $6.97, 2 48 inch growlights $11 the same place, couple plant chains, hooks - to hang it, timer the same place - $5, extension cord. 2. You need to repot them - 2 times a year is perfect - once a year is a must. You can use the same type of soil - just add some perlite to it to make it more breathable- at least 1/3. Yes - you are right - stick to 3 to 4 inch pots. (1/3 of the leaf diameter. 3. Get an African Violet fertilizer - and use it half dose. It what you should do to keep them blooming. Another thing from a fellow addict - do not reproduce same MIL or WM violets over and over again - give the babies to your friends. There are 15000 registered violets of shapes and hues to die for - and you need to try at least some of them. Irina
...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
I have a big problem and I need some help!
Q
Comments (3)
Hydrogen peroxide has a problem similar to chlorine in solution, ie, in the wrong concentrations, they are toxic. The advantage of hydrogen peroxide is that it leaves solution completely in 1-2 hrs after it has done its work; chlorine hangs on for days. I treat all water for nutrient change and make-up to 500-1000 ppm with 3% solution available in stores and let it sit for 2 hours. I have no nasties carried by water. Solution concentrations will depend upon your water supply.
...See More
Please help, I have a problem!!
Q
Comments (12)
I may have a solution. I called Kohler customer service and they make an extension that will fit this model sink. With the extension, it will go through a countertop up to 3 inches thick. I am going to let the countertop installer figure out something to go beneath the counter the same thickness as the lip on the sink, and then use the extension. I will also deduct the cost of the extension when I pay for the counters. Thanks again for all the responses. JJ
...See More
alisande
Original Author
13 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
13 years ago
Susan, do you have the current driver installed for your printer?

Jodi-
0
alisande
Original Author
13 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
13 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