Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofilter on a worksheet with merged cells
Hi,
I am prepaing a worksheet where I have one column containing employee names, with each employee name spread across 10 merged cells. The rows of those merged cells containing information specific to each employee..so what I need to know is whether there is a way for autofilter to work such that when I select a particular employee name from the list, it should show the 10 rows for that employee, and not just the first row, as is happening now.. Please help. Regards, Ashish |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofilter on a worksheet with merged cells
Ashish,
Solution 1: Select all the merged cells, and unmerge them. Without changing the selection, use Edit / Go to.. Special Blanks, and then type = and press the up arrow key once, and press Ctrl-Enter. Then copy the entire column and paste special values to remove the formulas. Solution 2: Insert another column, and in the 10 cells of that column for each employee, put in references to the cell with the name. Do that for every employee. Then copy that column and paste special values to remove formulas. Then your autofilter, which works on Databases, will work fine. HTH, Bernie MS Excel MVP "Ashish G" wrote in message ... Hi, I am prepaing a worksheet where I have one column containing employee names, with each employee name spread across 10 merged cells. The rows of those merged cells containing information specific to each employee..so what I need to know is whether there is a way for autofilter to work such that when I select a particular employee name from the list, it should show the 10 rows for that employee, and not just the first row, as is happening now.. Please help. Regards, Ashish |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofilter on a worksheet with merged cells
Hi Bernie,
I found solution #1 good for me..thanks for your help. Cheers! ~Ashish "Bernie Deitrick" wrote: Ashish, Solution 1: Select all the merged cells, and unmerge them. Without changing the selection, use Edit / Go to.. Special Blanks, and then type = and press the up arrow key once, and press Ctrl-Enter. Then copy the entire column and paste special values to remove the formulas. Solution 2: Insert another column, and in the 10 cells of that column for each employee, put in references to the cell with the name. Do that for every employee. Then copy that column and paste special values to remove formulas. Then your autofilter, which works on Databases, will work fine. HTH, Bernie MS Excel MVP "Ashish G" wrote in message ... Hi, I am prepaing a worksheet where I have one column containing employee names, with each employee name spread across 10 merged cells. The rows of those merged cells containing information specific to each employee..so what I need to know is whether there is a way for autofilter to work such that when I select a particular employee name from the list, it should show the 10 rows for that employee, and not just the first row, as is happening now.. Please help. Regards, Ashish |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying a column of single cells into a column of merged cells | Excel Discussion (Misc queries) | |||
How to name cells using same name yet specific to worksheet in Exc | Excel Worksheet Functions | |||
Linking Merged Cells | Excel Worksheet Functions | |||
Can you allow cells to be merged under a protected worksheet? | Excel Discussion (Misc queries) | |||
paste special | values should work with merged cells | Excel Discussion (Misc queries) |