see my image file,
i have many data's with formula, i want read data in formula box, formula box only shows formula, i don't want type "Alt+o+c+a" to extract rows columns , any other options there?
formula hideh.jpg
see my image file,
i have many data's with formula, i want read data in formula box, formula box only shows formula, i don't want type "Alt+o+c+a" to extract rows columns , any other options there?
formula hideh.jpg
Last edited by vengatvj; 10-05-2013 at 06:25 PM.
no one replay yet......
Last edited by vengatvj; 10-08-2013 at 12:52 PM.
Hello vengatvj,
The only way to prevent formulae to show in the Formula Bar is to select all cells with formulas,>Format Cells>Protection>Check the Protect Box and the Hide Box> OK your way out. Now select all user input Cells, and follow the same steps, but Uncheck the Protect Box, and the Hide Box. Then Protect the Sheet.
Regards
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks