Moving List Up After Deleting Row(s)

[soltek]

This sounds pretty dumb, but I have the flu and cant think very well.
If deleted a few rows of data in a sheet, is there an option to move
the rest of the data up to fill in the blanks? Also quickly, if I sort
my data by a date, is it possible for Excel to automatically sort data
upon entering? Thanks much in advance.

 

[Gord Dibben]

sol

Select rows to delete.

Edit>Delete>Entire Row.

OR right-click>Delete>Entire Row

Excel will move the other rows up to fill.

An automatic sort could be done through Worksheet Event code, but I would find
it annoying and potentially disruptive to have data moving around while
entering new data.

Gord Dibben Excel MVP