Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing Data
I have a spreadsheet with data on half and data history on the other half, I
need to delete the data on the 2006 and leave the 2005 data, however it is on the same row. When it comes to inserting I have the same problem. It is a spreadsheet seperated by a column. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing Data
First, I'd put that data on two separate worksheets or even add a column to
serve as an indicator and make it one giant list. But you can select your range (not the whole row!) and edit|delete|Shift cells up Or Insert|Cells|Shift cells down You can get to both of those options by selecting the range then rightclicking on that range and choosing either Insert or Delete But either two separate worksheets or a combined list would be much easier (my opinion). Sylvia wrote: I have a spreadsheet with data on half and data history on the other half, I need to delete the data on the 2006 and leave the 2005 data, however it is on the same row. When it comes to inserting I have the same problem. It is a spreadsheet seperated by a column. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
removing tabs from data | Excel Discussion (Misc queries) | |||
Vlookup to Return a Range of Data | Excel Discussion (Misc queries) | |||
Macro question | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) |