I have a spreadsheet that is "double spaced" and i need to get rid of the empty row. I don't want to do this manually b/c there 12000 rows. Thanks!
2006-12-10 08:00:32 · 3 answers · asked by Anonymous in Computers & Internet ➔ Software
If you sort (Data, Sort...) the spreadsheet by one or more columns, it will put all the blank cells at the beginning or the end depending on the sort order.
2006-12-10 13:36:25 · answer #1 · answered by nospamcwt 5 · 2⤊ 0⤋
If there is one cell with data for every line that needs to be included (for example, maybe the first row of data is a control number and every entry has one) highlight that column, Select Tools, Filter, Auto Filter. A drop down arrow will appear on that column. Select (blanks) - Then delete those lines. When you un-filter, all that is left is lines with data thus your blanks are gone.
2006-12-12 23:34:21 · answer #2 · answered by mschrissy74 2 · 0⤊ 0⤋
Lots of free tutorials for excel on web just do a search
2006-12-10 16:03:39 · answer #3 · answered by derf 4 · 0⤊ 1⤋