How do I delete rows where cells are empty

S

Stan

Office 2007, Complete dunce
I have a large 3 col Excel spreadsheet where certain cells in col A are
empty.
How do I delete every row where the cell in Col A is empty?
Should the answer require code or a macro to be entered, please tell me FULL
details of EVERY keystroke in the answer.
 
E

excelent

Select entire column A
hit F5 > Special
Mark Empty cells - hit OK
Right click on one selection and select Delete
Entire Row - hit OK


"Stan" skrev:
 
G

Gord Dibben

No code required.

Commands for Excel 2003.........not yet running 2007.

Select column A

Edit>Goto>Special>Blanks>OK

Edit>Delete>Entire Rows


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete empty rows 1
Delete extra empty rows 2
count non empty cells if other cell has certain value 5
Delete entire row if older then 365 days 6
Write a macro that hides rows based on empty cells 3
Delete Empty Rows 4
Incrementing numbers in a column 1
how do I shift the contents of the cells up to remove empty cells. 2

Top