Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Office For Mac
Mac Office Excel
Deleting blank rows in excel
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="CyberTaz, post: 6818316"] One Option: 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 [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Office For Mac
Mac Office Excel
Deleting blank rows in excel
Top
