+ Reply to Thread
Results 1 to 2 of 2

How do I deselect a row in Excel when selecting w/ the ctrl key?-away to undo the las

  1. #1
    Trustworthy
    Guest

    How do I deselect a row in Excel when selecting w/ the ctrl key?-away to undo the las

    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?

  2. #2
    Paul B
    Guest

    re: How do I deselect a row in Excel when selecting w/ the ctrl key?-away to undo the las

    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" <Trustworthy@discussions.microsoft.com> wrote in message
    news:00D4B889-C931-4139-B220-CFCC719A3E74@microsoft.com...
    > 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?




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1