expand selection

  1. R

    I want to restrict from being able to sort by current selection only.

    I'm using MS excel in Home and Student 2013. I have setup a database that volunteers are going to add to. They will need to sort it on occasion. I want to make sure that nobody accidently sorts it only by a single column. We have no need to ever sort by one column only and am concerned that...
  2. S

    Expanding only visible groups

    I have a very large spreadsheet with several groups of rows. The level 1 row in each group contains location data for a cable. The level 2 children rows contain details for that cable. When I filter the spreadsheet based on a location, all of the cables that have that location are visible but...
  3. S

    expand selection based on cell value

    Hi, I have data sorted by column A, which are employee names. There are many line items for each employee name. I need to parse out the data by employee name - I would like to select all of the rows for one employee and cut and paste the data into another workbook. I can create a new workbook...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top