I am looking for a way to have Excel automatically delete rows that have
columns that are blank.

Example:

If my row contains 7 columns across and column A & F do not have any data in
them, I want Excel to delete the entire row.

If there is a way to create a macro to do this, I need specific instructions
on how to create a macro, I have very little experience in macros.

I appreciate any and all assistance.