How to clear rows without affecting whole spreadsheet

[gracious]

Hi all,

I have a spreadsheet with 11 columns (formulated with =sum) and currently about 120 rows. These are different jobs that I am keeping track of. Now, when a job is totally complete, I need to remove it from this sheet, get rid of the row.

The way I have been doing it is that I delete the name, and any other text and then place 0.00 in the place of the numbers there and then I have been resorting to place that row now with the other empty rows. I do not know how to eliminate the row or rows without messing up the formulas. If I highlight the row and then go to format and then "rows", "hide" will this affect the rest of the spreadsheet?

The spreadsheet is getting rather long and having to resort each time I want to remove completed jobs just seems like I am going a long way around to it.

Is there an easier way to eliminate rows that I no longer need in my spreadsheet without it affecting the formulas and the totals?

[Richard Buttrey]

Hi all,

I have a spreadsheet with 11 columns (formulated with =sum) and currently about 120 rows. These are different jobs that I am keeping track of. Now, when a job is totally complete, I need to remove it from this sheet, get rid of the row.

The way I have been doing it is that I delete the name, and any other text and then place 0.00 in the place of the numbers there and then I have been resorting to place that row now with the other empty rows. I do not know how to eliminate the row or rows without messing up the formulas. If I highlight the row and then go to format and then "rows", "hide" will this affect the rest of the spreadsheet?

The spreadsheet is getting rather long and having to resort each time I want to remove completed jobs just seems like I am going a long way around to it.

Is there an easier way to eliminate rows that I no longer need in my spreadsheet without it affecting the formulas and the totals?

If you're overwriting all the numbers on your completed jobs row with zeros, then by definition you are affecting the =SUM() formulae, i.e. you are reducing the total.

Hence deleting the whole row by selecting it (clicking on the row number) and deleting it will be no different. Why can't you just do this?

HTH

[gracious]

First, thank you for quick reply I appreciate it.

Hence deleting the whole row by selecting it (clicking on the row number) and deleting it will be no different. Why can't you just do this?

Because until you just asked that question and gave me the clue of clicking on the row number and deleting, I didn't have a clue!

You just answered my question!!! I didn't know that in order to delete a row and have it completely gone and not affect the rest of the spreadsheet was to click on the row number and delete!

Before I was highlighting the row itself and deleting, but it was just the info that got deleted not the row and then I would have an empty row sitting in the middle of my spreadsheet.

Ok, this is great, ty ty ty!!!

[Richard Buttrey]

First, thank you for quick reply I appreciate it.


Because until you just asked that question and gave me the clue of clicking on the row number and deleting, I didn't have a clue!

You just answered my question!!! I didn't know that in order to delete a row and have it completely gone and not affect the rest of the spreadsheet was to click on the row number and delete!

Before I was highlighting the row itself and deleting, but it was just the info that got deleted not the row and then I would have an empty row sitting in the middle of my spreadsheet.

Ok, this is great, ty ty ty!!!

Glad to be of help. It also works for deleting columns in just the same way: i.e. select the column letter, Edit, and delete.

Rgds