Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
After Filter
Once we add "fileter", and get a incomplete list, we can't see the hidden
rows anymore, however, when we select multiple rows, the hidden rows are still selected. Is there any way to "freeze" those hidden rows? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
After Filter
On Jun 24, 2:09 pm, Ask MS <Ask wrote:
Once we add "fileter", and get a incomplete list, we can't see the hidden rows anymore, however, when we select multiple rows, the hidden rows are still selected. Is there any way to "freeze" those hidden rows? I think you are looking for Select Visible Cells. After selecting your rows, you can hit F5 (goto), click on Special, and click on Visible Cells Only. This will de-select the hidden rows, keeping the visible ones. There is also a toolbar button that is easier to use, but it isn't on the standard toolbars. You'd have to add it using Customize. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
After Filter
You can hit edit|goto (xl2003 menus) or ctrl-g or F5
then click special then click visible cells only To limit your selection to the visible cells in the selected area. Is that what you meant by freezing the hidden rows? Ask MS wrote: Once we add "fileter", and get a incomplete list, we can't see the hidden rows anymore, however, when we select multiple rows, the hidden rows are still selected. Is there any way to "freeze" those hidden rows? -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
After Filter
Thanks, Spiky. A further question: after I select the visible cells as you
suggested (for example, a few cells A5, 7, 9, 10 in column A), I want to copy and paste them, in exactly the same order, into a differnt column, (i.g. into D5,7,9,10) What should I do? This question is actually the one that bothers me. "Spiky" wrote: On Jun 24, 2:09 pm, Ask MS <Ask wrote: Once we add "fileter", and get a incomplete list, we can't see the hidden rows anymore, however, when we select multiple rows, the hidden rows are still selected. Is there any way to "freeze" those hidden rows? I think you are looking for Select Visible Cells. After selecting your rows, you can hit F5 (goto), click on Special, and click on Visible Cells Only. This will de-select the hidden rows, keeping the visible ones. There is also a toolbar button that is easier to use, but it isn't on the standard toolbars. You'd have to add it using Customize. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
After Filter
On Jun 24, 3:59 pm, Ask MS wrote:
Thanks, Spiky. A further question: after I select the visible cells as you suggested (for example, a few cells A5, 7, 9, 10 in column A), I want to copy and paste them, in exactly the same order, into a differnt column, (i.g. into D5,7,9,10) What should I do? This question is actually the one that bothers me. You should be able to copy after getting just the visible cells selected. But they will paste to 4 cells in a row, not the way you suggest. I don't think there is a simple way to paste like that, whether rows are hidden or not. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy only visible cells after filter is applied/ sum after filter | Excel Worksheet Functions | |||
filter: how to print filter list options in dropdown box | Excel Discussion (Misc queries) | |||
Why won't advanced filter return filter results? | Excel Worksheet Functions | |||
Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions |