 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2007How can I delete specific cells within a list?
How can I delete cells, (note not the content of these cells, but the cells themselves) within a list that contain a specific value '0' without changing the order of the remaining items in the list? Hi Chris, Try this, Assuming your list is in column A. Put this in helper column B =IF(A1=0,NA(),"") and drag down to the end of your data. While column B is still highlighted tap the F5 key, This will bring up the Go To dialog box Click the Special button Check Formulas Uncheck Numbers, Text and Logicals Leave Errors checked And OK out This will leave only the #NA errors highlighted Right click on one of these Select delete and check Entire row OK and you should be done. HTH Martin > How can I delete cells, (note not the content of these cells, but the > cells themselves) within a list that contain a specific value '0' without > changing the order of the remaining items in the list? Thanks Martin, does exactly what it says on the tin. > Hi Chris, > [quoted text clipped - 20 lines] >> cells themselves) within a list that contain a specific value '0' without >> changing the order of the remaining items in the list? Glad to hear that Chris. Thank you. Regards Martin > Thanks Martin, does exactly what it says on the tin. > [quoted text clipped - 22 lines] >>> cells themselves) within a list that contain a specific value '0' >>> without changing the order of the remaining items in the list? In xl2002+ you can choose Edit > Find, type '0' then Find All. Select all items in the list (Ctrl+A) then Edit > Delete > Entire Row. On 30 Oct, 07:22, "Chris Mitchell" <chris.a.mitch...@NOSPAMbtinternet.com> wrote: > How can I delete cells, (note not the content of these cells, but the cells > themselves) within a list that contain a specific value '0' without changing > the order of the remaining items in the list? data>filter>autofilter>>>>>>  SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > How can I delete cells, (note not the content of these cells, but the > cells themselves) within a list that contain a specific value '0' without > changing the order of the remaining items in the list?
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.