| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
"Find" in workbook
One of our Club members has a workbook with 31 sheets. He has used Merge &
Center in several locations on several sheets. When he searches (Ctrl+F) words within the Merged cells are never found. I have easily recreated the situation on a workbook with only three sheets. The words in the merged cells are not found. Any solutions? -- Chuck Davis Publisher/Editor Anthem Compendium Sun City Anthem Computer Club newsletter. Information provided on an "as is" basis. You must evaluate its applicability to your particular situation. |
|
#2
|
|||
|
|||
|
Hi
easiest solution. Don't use merged cells. They just create to much problems! -- Regards Frank Kabel Frankfurt, Germany "Chuck Davis" schrieb im Newsbeitrag ... One of our Club members has a workbook with 31 sheets. He has used Merge & Center in several locations on several sheets. When he searches (Ctrl+F) words within the Merged cells are never found. I have easily recreated the situation on a workbook with only three sheets. The words in the merged cells are not found. Any solutions? -- Chuck Davis Publisher/Editor Anthem Compendium Sun City Anthem Computer Club newsletter. Information provided on an "as is" basis. You must evaluate its applicability to your particular situation. |
|
#3
|
|||
|
|||
|
"Frank Kabel" wrote: Hi easiest solution. Don't use merged cells. They just create to much problems! -- Regards Frank Kabel Frankfurt, Germany "Chuck Davis" schrieb im Newsbeitrag ... One of our Club members has a workbook with 31 sheets. He has used Merge & Center in several locations on several sheets. When he searches (Ctrl+F) words within the Merged cells are never found. I have easily recreated the situation on a workbook with only three sheets. The words in the merged cells are not found. Any solutions? -- Chuck Davis Publisher/Editor Anthem Compendium Sun City Anthem Computer Club newsletter. Information provided on an "as is" basis. You must evaluate its applicability to your particular situation. Someone else have a solution? |
|
#4
|
|||
|
|||
|
Try looking in Formulas rather than values.
-- Regards, Tom Ogilvy "Chuck Davis" wrote in message ... "Frank Kabel" wrote: Hi easiest solution. Don't use merged cells. They just create to much problems! -- Regards Frank Kabel Frankfurt, Germany "Chuck Davis" schrieb im Newsbeitrag ... One of our Club members has a workbook with 31 sheets. He has used Merge & Center in several locations on several sheets. When he searches (Ctrl+F) words within the Merged cells are never found. I have easily recreated the situation on a workbook with only three sheets. The words in the merged cells are not found. Any solutions? -- Chuck Davis Publisher/Editor Anthem Compendium Sun City Anthem Computer Club newsletter. Information provided on an "as is" basis. You must evaluate its applicability to your particular situation. Someone else have a solution? |
|
#5
|
|||
|
|||
|
-----Original Message----- Try looking in Formulas rather than values. -- Regards, Tom Ogilvy "Chuck Davis" wrote in message ... "Frank Kabel" wrote: Hi easiest solution. Don't use merged cells. They just create to much problems! -- Regards Frank Kabel Frankfurt, Germany "Chuck Davis" schrieb im Newsbeitrag ... One of our Club members has a workbook with 31 sheets. He has used Merge & Center in several locations on several sheets. When he searches (Ctrl+F) words within the Merged cells are never found. I have easily recreated the situation on a workbook with only three sheets. The words in the merged cells are not found. Any solutions? -- Chuck Davis Publisher/Editor Anthem Compendium Sun City Anthem Computer Club newsletter. Information provided on an "as is" basis. You must evaluate its applicability to your particular situation. Someone else have a solution? . We tried all three options. |
|
#6
|
|||
|
|||
|
Excel's behavior changed from xl97 (which found stuff ok, but had other issues
with merged cells). I don't know of a work-around. I do my best to follow Frank's suggestion. Chuck Davis wrote: -----Original Message----- Try looking in Formulas rather than values. -- Regards, Tom Ogilvy "Chuck Davis" wrote in message ... "Frank Kabel" wrote: Hi easiest solution. Don't use merged cells. They just create to much problems! -- Regards Frank Kabel Frankfurt, Germany "Chuck Davis" schrieb im Newsbeitrag ... One of our Club members has a workbook with 31 sheets. He has used Merge & Center in several locations on several sheets. When he searches (Ctrl+F) words within the Merged cells are never found. I have easily recreated the situation on a workbook with only three sheets. The words in the merged cells are not found. Any solutions? -- Chuck Davis Publisher/Editor Anthem Compendium Sun City Anthem Computer Club newsletter. Information provided on an "as is" basis. You must evaluate its applicability to your particular situation. Someone else have a solution? . We tried all three options. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| linking cell value in one workbook to a cell in another workbook | Links and Linking in Excel | |||
| Updating sheets within a workbook | Excel Discussion (Misc queries) | |||
| how can I duplicate or copy a workbook then divide selected cells. | Excel Discussion (Misc queries) | |||
| New Workbook | Excel Discussion (Misc queries) | |||
| Find duplicates | Excel Discussion (Misc queries) | |||
Linear Mode
