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
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
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
[email protected] 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
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
>
> [email protected] 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
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)
<[email protected]> wrote in message
news:[email protected]...
> 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
> >
> > [email protected] 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks