Share via

how invert a selection excel 2007

Anonymous
2013-04-10T23:26:06+00:00

Hello,

I'm trying to select a small range in a sheet, invert it and hide the rest of the worksheet. (Similar to what MS templates like the time sheet or invoices are.)  Isn't it possible to do this without manually coloring or hiding the cells outside of this selection or writing a macro?  I thought there used to be an "invert selection" option in previous versions.

Anyway, any help would be appreciated.

Thanks!

Brooks

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. OssieMac 48,001 Reputation points Volunteer Moderator
    2013-04-11T00:10:15+00:00

    Not sure if I am on the same wave length. Transpose will change a column of data to across a row and vice versa.

    Select a range in a column and then select Copy

    Select a single cell outside of the copied range

    Select Paste Special

    Check the box against Transpose and OK

    4 people found this answer helpful.
    0 comments
Answer accepted by question author
  1. OssieMac 48,001 Reputation points Volunteer Moderator
    2013-04-11T22:27:13+00:00

    The rows below when selected don't provide the option on the pop up menu to hide.  Not sure why that is.

    Are you selecting the entire row by clicking on the row identifier number? Don't just select the visible cells by selecting A34:G34.  Even though you can't see the selection of the entire row, I assure you that clicking on the row identifier number that it does select the entire row. Reason that it needs to be done this way is that part of a row cannot be hidden.

    0 comments

7 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. OssieMac 48,001 Reputation points Volunteer Moderator
    2013-04-11T20:29:16+00:00

    If I am now understanding correctly you just want the range A1:G33 visible with everything else hidden. If so, then the following:

    1. Select entire column H (Click on the H column identifier will select the entire column)
    2. Hold the Ctrl and Shift keys and press right arrow. (This will select all columns from H to far right of worksheet)
    3. Right click over the selected area and then select Hide
    4. Select entire row 34 (Click on the number 34 row identifier)
    5. Hold the Ctrl and Shift keys and press down arrow. (This will select all rows from 34 to bottom of worksheet)
    6. Right click over the selected area and then select Hide

    To Unhide:

    1. Select entire column of last visible and drag to right. (You will see a little popup with a number ending in C that indicates the number of columns selected)
    2. Right click over selection and select Unhide
    3. Select entire last row of visible and drag down (Again you will see little popup with number ending in R that indicates the number of rows)
    4. Right click over selection and select Unhide

    9 people found this answer helpful.
    0 comments
  2. Anonymous
    2017-10-26T21:29:12+00:00

    Next to your last row of data, in cell 1, type 1, in cell 2, type 2.  Copy down to row 650.

    Select all your data, click sort & Filter, custom sort. 

    Sort the data by your last row, largest to smallest.

    Easy peasy lemon squeezy.

    4 people found this answer helpful.
    0 comments
  3. Anonymous
    2013-04-11T14:19:55+00:00

    Hi OssieMac,

    No, that isn't what I'm after.  The transpose feature just takes what I'm using for a number columns and makes a new selection the number of rows, takes my number of rows and makes them my new number of columns.

    Specifically, I have an area from A1 to G33; roughly some kind of page size.  I want to hide everything outside of that selection.  If I select A1:G33 I'd like to just invert that selection so that everything from G1:XPD1 (or whatever that last column is) down to G1226033:XPD1226033 (or whatever that last row is) then also A34 and G34 all the way down and hide them.

    There doesn't seem to be an option out there that does that.  Am I right?  It looks like I have to select all, deselect my area and then lock those cells, color them and them protect the sheet or something.

    Thanks again...

    0 comments