Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Select certain values in a field, then drag it up to lock it in
I used to be able to select certain values in a field and drag that field up
to the top of a pivot table so that it locks in those values. So say I didn't want sales that were already "booked", only those in the pipeline, I would deselect the booked value and leave the others in. Once I dragged it up to the top the spreadsheet would show the data based only on those in the pipeline, not including booked. Don't know why it's not working now when I go to do that. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
How do you control scroll rate when click and drag to select cell | Excel Discussion (Misc queries) | |||
creating drop down lists where you can select multiple values | Excel Discussion (Misc queries) | |||
how can I select two different values for a cell? | Excel Worksheet Functions | |||
PivotTable Column Field Values | Excel Discussion (Misc queries) |