+ Reply to Thread
Results 1 to 3 of 3

how to hide formula in formula box, view lookup result in formula box?

  1. #1
    Forum Contributor
    Join Date
    09-19-2013
    Location
    chennai
    MS-Off Ver
    Excel 2007
    Posts
    252

    how to hide formula in formula box, view lookup result in formula box?

    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.

  2. #2
    Forum Contributor
    Join Date
    09-19-2013
    Location
    chennai
    MS-Off Ver
    Excel 2007
    Posts
    252

    Re: how to hide formula in formula box, view lookup result in formula box?

    no one replay yet......
    Last edited by vengatvj; 10-08-2013 at 12:52 PM.

  3. #3
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: how to hide formula in formula box, view lookup result in formula box?

    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] .

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Hide certain number of rows and view one row
    By salmanisn in forum Excel General
    Replies: 2
    Last Post: 12-24-2011, 11:19 AM
  2. Help - Need Formula To Hide Rows
    By PIPPIBOOKS in forum Excel General
    Replies: 1
    Last Post: 11-08-2005, 01:10 PM
  3. can you hide rows with a formula?
    By david in forum Excel General
    Replies: 3
    Last Post: 04-08-2005, 11:06 AM
  4. can you hide rows with a formula?
    By david in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-08-2005, 09:06 AM
  5. Formula to hide blank rows
    By Ladyra in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-25-2005, 03:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1