Moving List Up After Deleting Row(s)

  • Thread starter Thread starter soltek
  • Start date Start date
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.
 
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
 
Back
Top