Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Jun 2007
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Needing help with excel!! (Excel 5.0)

    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.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Needing help with excel!! (Excel 5.0)

    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.

  3. #3
    New Lounger
    Join Date
    Jun 2007
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Needing help with excel!! (Excel 5.0)

    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....[img]/forums/images/smilies/wink.gif[/img]
    thanks for the help, it reaffirmed what I had suspected. I will continue to cut and paste my sum row!
    j

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Needing help with excel!! (Excel 5.0)

    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.
    Legare Coleman

  5. #5
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts

    Re: Needing help with excel!! (Excel 5.0)

    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

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Needing help with excel!! (Excel 5.0)

    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.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •