Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing Blanks
I have a set of data that has a blank in every other row. Is there a way to
remove these blanks ? I tried the paste special but to no avail. Thank you in advance. Carl |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing Blanks
If you want to delete the rows where the cells are blank, try this:
Select from the first item in the list down to the last item (or blank) Press the [F5] key (that's the short cut for <edit<goto) Click the [special..] button Check: Blanks Click the [OK] button WHILE the blanks are still selected <edit<delete<entire row Does that help? *********** Regards, Ron XL2002, WinXP "carl" wrote: I have a set of data that has a blank in every other row. Is there a way to remove these blanks ? I tried the paste special but to no avail. Thank you in advance. Carl |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing Blanks
Use a copy of your data first to experiment........
Highlight the dataset and SORT ascending on the column with the blanks.........the blank rows will all go to the bottom of the list........ Vaya con Dios, Chuck, CABGx3 "carl" wrote: I have a set of data that has a blank in every other row. Is there a way to remove these blanks ? I tried the paste special but to no avail. Thank you in advance. Carl |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make a Chart data series treat blanks as "Empty" cells | Charts and Charting in Excel | |||
Removing blanks from a spreadsheet | Excel Worksheet Functions | |||
Removing blanks / sorting - common methods not applicable | Excel Discussion (Misc queries) | |||
Weighed average if the adjecent column contains blanks | Excel Discussion (Misc queries) | |||
linking files with blanks | Excel Discussion (Misc queries) |