Can I delete blank rows from excel without selecting them?
Where are these "do edit /Go to / special" commands? Are they entered in
macro or is this from a pull down menu. Can you be more specific?
"Ken Wright" wrote:
Select a column where you can be SURE that a blank cell means you want to
delete that row. Select the whole column, do edit / Go to / Special /
blanks, then hit edit / delete / entire row
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
------------------------------Â*------------------------------Â*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------Â*------------------------------Â*----------------
"rgtest" wrote in message
...
I exported data from a Crystal Report into Excel. During the export
process
extra fields and and columns were added to the data set. I would like to
delete the blank rows that were inserted between every record from my
spreadsheet.
Is there a way to delete extra rows from a spreadsheet without selecting
each row? For example, could I run a script to delete rows with null
values
or space?
Thanks
|