ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Selecting All Rows with Certain Data (https://www.excelbanter.com/excel-discussion-misc-queries/120769-selecting-all-rows-certain-data.html)

DCrabill

Selecting All Rows with Certain Data
 
Hello,

I am attempting to select all of the rows within a spreadsheet in which a
particular cell within that row is blank (contains no information). I want
to remove these rows from my spreadsheet, but it is over 2000 rows long and I
do not want to select them individually. Please advise. Thanks very much!




All times are GMT +1. The time now is 12:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com