Tag Archives: Delete Sheet Rows

Delete rows with empty cell(s) in #Excel

Guess what?  We are going to do it with a sequence of keyboard shortcuts only.  Believe it or not, it requires only 8 key strokes: Ctrl+A => Ctrl+G => Alt+S => k => Enter => Ctrl+- (minus sign) => r … Continue reading

Rate this:

Posted in Excel Tips, Shortcut | Tagged , | Leave a comment

Quickly delete/hide records (rows) with Strikethrough format by using Find and a couple of simple techniques.

Quickly delete/hide records (rows) with Strikethrough format by using Find and a couple of simple techniques. I had encountered a file with thousands of records (rows) that keeps track of details of different jobs.  Finished jobs were identified by Strikethrough … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | 13 Comments