Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I have a set of numbers with 1000+ rows. Every other row is blank and I want to delete all the blank rows, how?
1- Select the entire range of records.
2- Go to Data> Filter, select 'AutoFilter',
3- Open the list for any column which does have data for all records then
select 'Show Non-Blanks,
4- Copy the selected range, then go to a new sheet,
5- Use Edit> Paste Special, check the 'Skip Blanks' checkbox, OK
HTH |:>)
Bob Jones
[MVP] Office:Mac
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.
