ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can you hide the value contained in a single cell (https://www.excelbanter.com/excel-discussion-misc-queries/130243-can-you-hide-value-contained-single-cell.html)

Bill

Can you hide the value contained in a single cell
 
Thank you in anticaption of replying

Mark

Can you hide the value contained in a single cell
 
On Feb 11, 5:17 pm, Bill wrote:
Thank you in anticaption of replying


You can set the font color to the same as the background color.


Gord Dibben

Can you hide the value contained in a single cell
 
Bill

Custom Format of ;;; will leave the cell looking blank.

However you can still see the formula/value in the Formula Bar so you have to
also hide that.

This can be done by locking that cell and check it "hidden" also.

Then you protect the worksheet.


Gord Dibben MS Excel MVP

On Sun, 11 Feb 2007 15:17:01 -0800, Bill wrote:

Thank you in anticaption of replying




All times are GMT +1. The time now is 11:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com