| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Condensing lists
I am trying to find a way to take a list containing blank cells, and condense
it to the point where there are none (a 50 cell list with 20 blanks would be shortened to a 30 cell list). If anyone knows how to do this, I'd like to hear how. |
|
#2
|
|||
|
|||
|
Are they REALLY blanks? If so, select the column or range of cells, hit
Edit--Go to--Special, choose Blanks, OK. Then Edit--Delete, and choose whether to shift cells up or delete entire rows. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "skywalker949494" wrote in message ... I am trying to find a way to take a list containing blank cells, and condense it to the point where there are none (a 50 cell list with 20 blanks would be shortened to a 30 cell list). If anyone knows how to do this, I'd like to hear how. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding entry to validation list without retyping all lists | Excel Discussion (Misc queries) | |||
| Dependant Lists | Excel Discussion (Misc queries) | |||
| Comparing lists of map references | Excel Worksheet Functions | |||
| Comparing 2 Customer Lists to Identify Shared Customers | Excel Worksheet Functions | |||
| How do I compare two lists of names in excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
