Right click the row number & select Delete.
Excel formulas can only return values to the cells that they are located in. They cannot move or delete data.Right...I was looking for a built in excel function that I can drag down the entire sheet, and it would delete the rows? is that possible?
Excel formulas can only return values to the cells that they are located in. They cannot move or delete data.
Take a look at the last link I provided. You can do that with VBA code (just turn on the Macro Recorder and do that manually to get most of the code that you need).OK, I was afraid of that, I'll use code. thanks