Needing help with excel!! (Excel 5.0)

Topic

New Reply

Hi there! boy do I need help. I’m trying to make a row in an excel spreadsheet stay in the same place, no matter if I insert rows above it or not. What I am trying to acheive is totals at the bottom of each page, rather than being affected by the rows above it, pushing this row with the total onto the next sheet. makes it hard to follow the totals.
boy, i hope this is clear enough!
thanks, J.

Reply | Quote

Replies

Welcome to Woody’s Lounge!

Excel 5.0? That was the version for Windows 3.1, I think!

If you insert a row, the rows below it will be pushed down – where else should they go? And even if you could keep the totals row in its place, how should it react to a row being pushed below it to the next page? I fear it is not easy to keep totals at the bottom of a page, it would probably require extensive VBA coding.

Reply | Quote

Thanks Hans!
ha ha, you got me. I just wanted to leave work and I made up something that I thought I had read in an excel book. not that telling me something was for windows 3.1 really means anything to me anyways….
thanks for the help, it reaffirmed what I had suspected. I will continue to cut and paste my sum row!
j

Reply | Quote

You could write a macro that would go through the worksheet and delete any current “sum rows” and then insert new “sum rows” every n rows. However, if that would work for you, then we would need to see a copy of the workbook (with dummy data if the data is proprietary) to use to test the macro before we could help.

Reply | Quote

You can mimick a row that stays in place by putting a picture of the actual sum row where you want it and then tell the picture to not move and size with cells:

– Select sum row
– Hold shift key, click Edit menu and select copy picture
– select the option you want (as shown on screen or as printed)
– go to the location where you want the picture and hit paste
– here comes the trick: Click once in the formula bar, type the = sign and select your sum row again
– rightclick picture and select format picture, on properties tab choose don’t move or size with cells.

Reply | Quote

J:

Some work arounds with Excel.

A common alternative is to have all sums at the top of the data not at the bottom, then when you insert a rows the total row is on top.

If you are only going to insert a few rows the following may get you there. I would begin by having adequate top and bottom margins for the worksheet. Next insert a page break just below the Total Lines. Just make sure you have a place in the workbook to make note of how many rows are currently printed. then compare that with the amount when new rows are inserted.

When you insert rows you either change the top and bottom margins a sufficient amount to have all totals back at the bottom, or use the Page Setup Scaling to reduce the size of print out from say 100 % to 90% or a combination fo both. Print preview the results until its what you want. A better version of the above is find out the height of the rows (hopefully they are all the same). Since ther are 72 Point to an inch you could set up a math formula in Excel that will quickly solve for the proper adjustments that you would then put in Print Setup for the amount of additional rows you inserted.

Good Luck

Tom Duthie

Reply | Quote