How do I deselect a row in Excel when selecting w/ the ctrl key?
I receive a daily spreadsheet that has unnecessay rows of information
scattered throughout the sheet. To delete them, I have to hold down the control key, left click on entire row, then select delete. To avoid inadvertently clicking in a cell and having to start over again, I delete every so often. My question is... does anybody know of away to undo the last click without losing all the other rows that were previously highlighted? |
Trustworthy, have a look here for some code by Chip Pearson to do it
http://makeashorterlink.com/?T2E221D8B -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Trustworthy" wrote in message ... I receive a daily spreadsheet that has unnecessay rows of information scattered throughout the sheet. To delete them, I have to hold down the control key, left click on entire row, then select delete. To avoid inadvertently clicking in a cell and having to start over again, I delete every so often. My question is... does anybody know of away to undo the last click without losing all the other rows that were previously highlighted? |
All times are GMT +1. The time now is 07:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com