Help with Excel +Sheet1!XY function please
Closed
hjdx
Posts
2
Registration date
Thursday May 18, 2017
Status
Member
Last seen
May 18, 2017
-
May 18, 2017 at 07:50 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - May 18, 2017 at 11:31 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - May 18, 2017 at 11:31 AM
Related:
- Help with Excel +Sheet1!XY function please
- Excel date format dd.mm.yyyy - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Print function excel ✓ - Excel Forum
- Number to words in excel - Guide
- Function key stuck on - Guide
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
544
May 18, 2017 at 11:31 AM
May 18, 2017 at 11:31 AM
Hi Hjdx,
Find and Replace will work, but only after you display the formula in the cells. Do this by hitting Ctrl+t, then Ctrl+h for Find and Replace and finally Ctrl+t to change the formula's back to showing results.
Best regards,
Trowa
Find and Replace will work, but only after you display the formula in the cells. Do this by hitting Ctrl+t, then Ctrl+h for Find and Replace and finally Ctrl+t to change the formula's back to showing results.
Best regards,
Trowa