will formulas be lost when moving data in a worksheet?

I have a P & L that contains 3 years of info. I have to delete the oldest
year (2007) and put in our actual numbers for year ending 2010. Will I lose
all of the formulas when I delete all of the 2007 numbers? Is there an
easier way to do this?

Edit/ Goto/ Special/ Constants
Delete those.
--
David Biddulph

"Renae" wrote in message
...
I have a P & L that contains 3 years of info. I have to delete the oldest
year (2007) and put in our actual numbers for year ending 2010. Will I
lose
all of the formulas when I delete all of the 2007 numbers? Is there an
easier way to do this?

Renae, your posting is not very clear.

1. By P & L do you mean Profit & Loss?

2. If you are deleting the oldest year 2007 why not copy it instead that way
you still retain the data that you are currently deleting.

3. If you delete things you normally lose them.

4. If you have four years worth of Profit and Loss figures maybe set up
different Worksheets within the same Workbook for each year.

As an alternative keep the different years in different parts of the same
Worksheet.

Please click on Yes if my comments have helped.

Thanks!


"Renae" wrote:

I have a P & L that contains 3 years of info. I have to delete the oldest
year (2007) and put in our actual numbers for year ending 2010. Will I lose
all of the formulas when I delete all of the 2007 numbers? Is there an
easier way to do this?

It would not let me post more than that. Yes it is a Profit & Loss. I am
not sure what you mean by copy to retain? I have to show 2008, 2009, 2010
and then my last one would be listed as Budget 2011. This is why I need to
get rid of the 2007 info. I need this information set on the worksheet this
way so they can see the years to compare. If there is an easier way to do
this I would love to know. I am fairly new to the whole excel thing.

Thanks for your help!

"trip_to_tokyo" wrote:

Renae, your posting is not very clear.

1. By P & L do you mean Profit & Loss?

2. If you are deleting the oldest year 2007 why not copy it instead that way
you still retain the data that you are currently deleting.

3. If you delete things you normally lose them.

4. If you have four years worth of Profit and Loss figures maybe set up
different Worksheets within the same Workbook for each year.

As an alternative keep the different years in different parts of the same
Worksheet.

Please click on Yes if my comments have helped.

Thanks!


"Renae" wrote:

I have a P & L that contains 3 years of info. I have to delete the oldest
year (2007) and put in our actual numbers for year ending 2010. Will I lose
all of the formulas when I delete all of the 2007 numbers? Is there an
easier way to do this?

Can you explain this a little further? I am trying to learn all I can and
just want to make sure I understand what and why I am soing this.

"David Biddulph" wrote:

Edit/ Goto/ Special/ Constants
Delete those.
--
David Biddulph

"Renae" wrote in message
...
I have a P & L that contains 3 years of info. I have to delete the oldest
year (2007) and put in our actual numbers for year ending 2010. Will I
lose
all of the formulas when I delete all of the 2007 numbers? Is there an
easier way to do this?


.

Renae:-

May be you could set things up this way:-

In Column A put your headings (like Income and Expenses etc).

In Column B - these are the figures for 2008.

In Column C - these are the figures for 2009.

In Column D - these are the figures for 2011.

In Column D - these are the figures for 2012.

- and so on.

This should give you what you want and enable you to compare year to year as
the figures are side by side.

It is not a good idea to delete things because, once deleted, you might not
be able to get the figures back again.

Please click on Yes if my comments have helped.

Thanks!





"Renae" wrote:

It would not let me post more than that. Yes it is a Profit & Loss. I am
not sure what you mean by copy to retain? I have to show 2008, 2009, 2010
and then my last one would be listed as Budget 2011. This is why I need to
get rid of the 2007 info. I need this information set on the worksheet this
way so they can see the years to compare. If there is an easier way to do
this I would love to know. I am fairly new to the whole excel thing.

Thanks for your help!

"trip_to_tokyo" wrote:

Renae, your posting is not very clear.

1. By P & L do you mean Profit & Loss?

2. If you are deleting the oldest year 2007 why not copy it instead that way
you still retain the data that you are currently deleting.

3. If you delete things you normally lose them.

4. If you have four years worth of Profit and Loss figures maybe set up
different Worksheets within the same Workbook for each year.

As an alternative keep the different years in different parts of the same
Worksheet.

Please click on Yes if my comments have helped.

Thanks!


"Renae" wrote:

I have a P & L that contains 3 years of info. I have to delete the oldest
year (2007) and put in our actual numbers for year ending 2010. Will I lose
all of the formulas when I delete all of the 2007 numbers? Is there an
easier way to do this?

May be you could set things up this way:-

In Column A put your headings (like Income and Expenses etc).

In Column B - these are the figures for 2008.

In Column C - these are the figures for 2009.

In Column D - these are the figures for 2011.

In Column D - these are the figures for 2012.

- and so on.

This should give you what you want and enable you to compare year to year as
the figures are side by side.

It is not a good idea to delete things because, once deleted, you might not
be able to get the figures back again.

Please click on Yes if my comments have helped.

Thanks!



"Renae" wrote:

Can you explain this a little further? I am trying to learn all I can and
just want to make sure I understand what and why I am soing this.

"David Biddulph" wrote:

Edit/ Goto/ Special/ Constants
Delete those.
--
David Biddulph

"Renae" wrote in message
...
I have a P & L that contains 3 years of info. I have to delete the oldest
year (2007) and put in our actual numbers for year ending 2010. Will I
lose
all of the formulas when I delete all of the 2007 numbers? Is there an
easier way to do this?


.

By "Edit", I mean select the Edit menu.
By "Goto", I mean select the "Go To ..." entry on that menu.
By "Special", I mean select the "Special" entry on that dialogue box.
By "Constants", I mean select the "Constants" option on that dialogue box.
By "Delete those", I mean hit the keyboard button labelled "Delete".
--
David Biddulph

"Renae" wrote in message
...
Can you explain this a little further? I am trying to learn all I can and
just want to make sure I understand what and why I am soing this.

"David Biddulph" wrote:

Edit/ Goto/ Special/ Constants
Delete those.
--
David Biddulph

"Renae" wrote in message
...
I have a P & L that contains 3 years of info. I have to delete the
oldest
year (2007) and put in our actual numbers for year ending 2010. Will I
lose
all of the formulas when I delete all of the 2007 numbers? Is there an
easier way to do this?


.