Remove blank row
how do i remove blank row from a sheet present at many places, which
restricts me from filtering all data in a sheet. |
Remove blank row
Just select the whole data range, and sort the data by one of the columns.
The sort action will move all blank rows together to the beginning (or to the end, depends on teh sort), and then you can easily delete them altogether. -- <a href="http://www.free-training-tutorial.com"Microsoft Excel Training Tutorial</a <a href="http://www.free-training-tutorial.com/function-vlookup.html"vlookup</a "Riz" wrote: how do i remove blank row from a sheet present at many places, which restricts me from filtering all data in a sheet. |
Remove blank row
Choose "Blank" at your filter and then Select black rows and delete them at
once. it then open your filter . "Riz" wrote: how do i remove blank row from a sheet present at many places, which restricts me from filtering all data in a sheet. |
All times are GMT +1. The time now is 09:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com