Splitting a page into half 1

[kgreer]

Here is the deal

I have been given a spreadsheet with information. Column A through M has information and column Q through AC has informaiton. This is a list of users split so that it can all fit on one page. The problem is this, if I want to delete a entry that is below Columns A through M, I don't want the information in Column Q through AC to be deleted.

How or Can you split a spreadsheet into two pages so the when you delete a row it doesn't delete the other side.

Thanks

 

[SkipVought]

Hi,

Select the cells in the table you want to delete.

Right-click > Delete > Shift UP

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[kgreer]

Thank you....

I forgot about that, I was making it harder than I thought.

Thanks again