+ Reply to Thread
Results 1 to 4 of 4

Locking totals position

  1. #1
    steve.mccall1@googlemail.com
    Guest

    Locking totals position

    Hi,

    Is it possible to lock a formulas position on a work sheet so that when
    a cell is deleted above, it will not move up the spreadsheet?

    Thanks

    Steve


  2. #2
    Pete_UK
    Guest

    Re: Locking totals position

    If you delete the CONTENTS of a cell (by pressing the <delete> key,
    rather than by Edit | Delete... | Cells | Move Up etc) then the formula
    will remain where it is. Alternatively, move the totals formula to the
    top row, so that it won't matter if any cells below are removed.

    Hope this helps.

    Pete

    steve.mccall1@googlemail.com wrote:
    > Hi,
    >
    > Is it possible to lock a formulas position on a work sheet so that when
    > a cell is deleted above, it will not move up the spreadsheet?
    >
    > Thanks
    >
    > Steve



  3. #3
    steve.mccall1@googlemail.com
    Guest

    Re: Locking totals position

    Thanks for the help,

    Thats pretty much what I thought about doing. Unfortunately they want
    the totals at the bottom and don't want any blank spaces in the
    worksheet! Quite annoying eh!

    Steve

    Pete_UK wrote:
    > If you delete the CONTENTS of a cell (by pressing the <delete> key,
    > rather than by Edit | Delete... | Cells | Move Up etc) then the formula
    > will remain where it is. Alternatively, move the totals formula to the
    > top row, so that it won't matter if any cells below are removed.
    >
    > Hope this helps.
    >
    > Pete
    >
    > steve.mccall1@googlemail.com wrote:
    > > Hi,
    > >
    > > Is it possible to lock a formulas position on a work sheet so that when
    > > a cell is deleted above, it will not move up the spreadsheet?
    > >
    > > Thanks
    > >
    > > Steve



  4. #4
    Bob Phillips
    Guest

    Re: Locking totals position

    Maybe put the real totals at the top in a hidden row, and refer to them at
    the bottom.

    --
    HTH

    Bob Phillips

    (replace somewhere in email address with gmail if mailing direct)

    <steve.mccall1@googlemail.com> wrote in message
    news:1155299699.440446.186070@h48g2000cwc.googlegroups.com...
    > Thanks for the help,
    >
    > Thats pretty much what I thought about doing. Unfortunately they want
    > the totals at the bottom and don't want any blank spaces in the
    > worksheet! Quite annoying eh!
    >
    > Steve
    >
    > Pete_UK wrote:
    > > If you delete the CONTENTS of a cell (by pressing the <delete> key,
    > > rather than by Edit | Delete... | Cells | Move Up etc) then the formula
    > > will remain where it is. Alternatively, move the totals formula to the
    > > top row, so that it won't matter if any cells below are removed.
    > >
    > > Hope this helps.
    > >
    > > Pete
    > >
    > > steve.mccall1@googlemail.com wrote:
    > > > Hi,
    > > >
    > > > Is it possible to lock a formulas position on a work sheet so that

    when
    > > > a cell is deleted above, it will not move up the spreadsheet?
    > > >
    > > > Thanks
    > > >
    > > > Steve

    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1