Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
will formulas be lost when moving data in a worksheet?
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
will formulas be lost when moving data in a worksheet?
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? . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
will formulas be lost when moving data in a worksheet?
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? . |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
will formulas be lost when moving data in a worksheet?
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? . |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
will formulas be lost when moving data in a worksheet?
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? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
will formulas be lost when moving data in a worksheet?
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? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
will formulas be lost when moving data in a worksheet?
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
All data in my worksheet was lost how do I retrieve it | Excel Worksheet Functions | |||
Excel Worksheet Data Lost | Excel Discussion (Misc queries) | |||
Moving data from one worksheet to another | Excel Worksheet Functions | |||
Moving data from from one worksheet to another | Excel Worksheet Functions | |||
Moving Data to Another Worksheet | Excel Discussion (Misc queries) |