tag:blogger.com,1999:blog-4756971318468684357.post7485402378844632839..comments2024-01-17T03:31:05.160-07:00Comments on Waxaholic: Anyone really good at using Microsoft Excel???Captain Canuckhttp://www.blogger.com/profile/02189853561737282234noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-4756971318468684357.post-71494336188186896952014-02-18T19:11:13.211-07:002014-02-18T19:11:13.211-07:00format c:
:Dformat c:<br /><br />:DJediJeffhttps://www.blogger.com/profile/10261262040532716901noreply@blogger.comtag:blogger.com,1999:blog-4756971318468684357.post-17460588613780209982014-02-18T17:32:08.612-07:002014-02-18T17:32:08.612-07:00If you're deleting lines with certain criteria...If you're deleting lines with certain criteria (e.g., you want to delete all the lines where Column C says "wax"), you can use a filter to only display those lines, then highlight and delete them all.<br /><br />Above all, make a backup copy of the file first! :)Wilsonhttps://www.blogger.com/profile/07885481981559170900noreply@blogger.comtag:blogger.com,1999:blog-4756971318468684357.post-59947497185797128682014-02-18T17:21:17.693-07:002014-02-18T17:21:17.693-07:00Use the control key. Then right-click and delete....Use the control key. Then right-click and delete.<br /><br />Practice on a dummy spreadsheet first, to satisfy your "does it really work?" curiosity.<br /><br />If you can sort them to get these lines together, that's even better. You can use the shift key to get inclusive. Play with that, too, because there is only one inclusion area.Anonymousnoreply@blogger.com