Welcome to the Excel Forum

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

Please Register to Remove these Ads

Please Register to Remove these Ads



Reply
  #1  
Old 11-21-2009, 12:12 AM
LearnerEXL LearnerEXL is offline
Registered User
 
Join Date: 22 Sep 2009
Location: India
MS Office Version:Excel 2007
Posts: 21
LearnerEXL is becoming part of the community
How to hide the formula in formula bar?

Please Register to Remove these Ads

Dear Friends,

Please let me know whether I can hide the FORMULA in Formula Bar?

Thanks.
Reply With Quote
  #2  
Old 11-21-2009, 12:16 AM
Paul's Avatar
Paul Paul is offline
Forum Moderator
 
Join Date: 05 Feb 2007
Location: Wisconsin, U.S.A.
MS Office Version:2007
Posts: 3,882
Paul is very confident of their ability Paul is very confident of their ability Paul is very confident of their ability Paul is very confident of their ability Paul is very confident of their ability
Re: How to hide the formula in formula bar?

Hi Learner,

Right-click on the cell with the formula you want hidden and choose Format Cell..

On the protection tab, check the box for 'Hidden' and 'Locked'. You then must protect the worksheet, so be sure to unlock any cells you still want to be able to edit first.
__________________
- Paul

Click here to read the Forum Rules

To give a virtual "pat on the back" click the icon in the gray toolbar from that user's post.
To report abuse, spam or offensive posts, please click the icon.
Reply With Quote


Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Forum Jump