-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
expand selection
-
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...- RobertALWilliams
- Thread
- sort
- Replies: 1
- Forum: Excel Questions
-
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...- SteveBExcel
- Thread
- group and outline visible cells only
- Replies: 0
- Forum: Excel Questions
-
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...- Sanibel
- Thread
- Replies: 4
- Forum: Excel Questions
Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.
