W
william
Excel displays contents of every cell in the formula bar.
How can they be hidden ie not shown in the formula bar?
How can they be hidden ie not shown in the formula bar?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
V
Vasant Nanavati
Hi:
You can either (1) suppress display of the formula bar or (2) set the Hidden
property of the cells to True and then protect the worksheet containing the
cells.
Regards,
Vasant.
You can either (1) suppress display of the formula bar or (2) set the Hidden
property of the cells to True and then protect the worksheet containing the
cells.
Regards,
Vasant.
R
Ragdyer
Select the cells that contain the formulas that you wish to hide.
If you want to hide every formula, select the entire sheet by clicking in
the square to the left of the Column labels, above the Row labels,
Then, <Format> <Cells> <Protection> tab,
Click on "Hidden", then <OK>.
Now, you have to protect the sheet in order for this to take affect.
If this protection inhibits some of the functionality of the sheet, you can
unlock any affected cells beforehand, even the ones that contain the hidden
formulas (means users can replace hidden formula with data entry).
If you want to hide every formula, select the entire sheet by clicking in
the square to the left of the Column labels, above the Row labels,
Then, <Format> <Cells> <Protection> tab,
Click on "Hidden", then <OK>.
Now, you have to protect the sheet in order for this to take affect.
If this protection inhibits some of the functionality of the sheet, you can
unlock any affected cells beforehand, even the ones that contain the hidden
formulas (means users can replace hidden formula with data entry).
M
mendoza
There are 2 ways.
1. Hide or unhide formulas
To prevent formulas from displaying in the formula bar,
you must format the cells that contain the formulas as
hidden and then protect the worksheet. Follow the
procedure below to hide formulas. To unhide hidden
formulas, remove the protection from the worksheet.
Select the range of cells whose formulas you want to hide.
You can also select nonadjacent ranges or the entire sheet.
On the Format menu, click Cells, and then click the
Protection tab.
Select the Hidden check box. Click OK.
On the Tools menu, point to Protection, and then click
Protect Sheet.
Make sure the Contents check box is selected.
2. Display or hide specific window elements
On the Tools menu, click Options, and then click the View
tab.
Select the check boxes for items you want to display, and
clear check boxes for the items you want to hide.
1. Hide or unhide formulas
To prevent formulas from displaying in the formula bar,
you must format the cells that contain the formulas as
hidden and then protect the worksheet. Follow the
procedure below to hide formulas. To unhide hidden
formulas, remove the protection from the worksheet.
Select the range of cells whose formulas you want to hide.
You can also select nonadjacent ranges or the entire sheet.
On the Format menu, click Cells, and then click the
Protection tab.
Select the Hidden check box. Click OK.
On the Tools menu, point to Protection, and then click
Protect Sheet.
Make sure the Contents check box is selected.
2. Display or hide specific window elements
On the Tools menu, click Options, and then click the View
tab.
Select the check boxes for items you want to display, and
clear check boxes for the items you want to hide.
T
Trevor Hedges
Format the cells first:
Format
Cells
Protection
Hidden
Then Format the worksheet:
Tools
Protection
Sheet
The contents of any cells you have hidden will not
display in the forumla bar once the worksheet is protected
Format
Cells
Protection
Hidden
Then Format the worksheet:
Tools
Protection
Sheet
The contents of any cells you have hidden will not
display in the forumla bar once the worksheet is protected
L
Liz
One way to accomplish this by choosing the cells you want
to hide the contents of, go to Format - Cells - click on
Hidden. Then go to Tools - Protection - Protect Sheet.
This will hide your cell contents.
However this will also prevent entering data into these
cells until the Protect sheet option is "turned off."
Good Luck!
to hide the contents of, go to Format - Cells - click on
Hidden. Then go to Tools - Protection - Protect Sheet.
This will hide your cell contents.
However this will also prevent entering data into these
cells until the Protect sheet option is "turned off."
Good Luck!
L
Liz
If it is only formulas you want to hide another option is:
Tools - View - Unclick the Formulas.
Tools - View - Unclick the Formulas.
J
Jez
Tool>Options>View Uncheck the Formular bar box at the top
Jez
Jez
J
Jez
Tools>Options>View "Formular Bar" uncheck box
Jez
Jez
J
Jez
tools>options>view... Formular bar uncheck box
J
Jez
tools>options>view: formula bar uncheck box
M
Mark Graesser
William,
This can be done but it takes a couple of steps.
Hopefully you are familiar with Sheet Protection. Under
Cell Format>Protection you need to check the "hidden"
box. Then when you protect the sheet the entry will not
display in the formula bar.
Regards,
Mark Graesser
P.S. I am not on the bulletin board very often so if you
have a question e-mail me at (e-mail address removed)
This can be done but it takes a couple of steps.
Hopefully you are familiar with Sheet Protection. Under
Cell Format>Protection you need to check the "hidden"
box. Then when you protect the sheet the entry will not
display in the formula bar.
Regards,
Mark Graesser
P.S. I am not on the bulletin board very often so if you
have a question e-mail me at (e-mail address removed)
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.