empty columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HI all,

is there a way to delete the empty rows on a worksheet? I'm thinking about
something like when I select the empty rows with autofilter, just now I would
like to delete columns not rows.

thanks in advance
 
Delete the empty rows just like you would for the columns...er...vic
vers
 
Try highlighting the column selection and pressing f5 or edit go to.
select the special button and then selct blanks.
this should highlight all of the blank columns whcih you can then delete.

hth

David
 
You must log in or register to reply here.

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

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel Help to copy information from one row at a time to another sheet 1
empty columns 4
List any duplicates once - no pivot tables 2
Hide columns based on row values 2
Hpw do I delete multiple empty rows found between filled rows? 1
Go To the next empty cell in Column A 3
Deleting rows (with zeros) with a macro 7

Back
Top