Tuesday, August 28, 2018

Display or hide cell values

Display or hide cell values

If you have a sheet that contains confidential information, such as employee salaries, you can hide the values of those cells by using a custom number format.

Do any of the following:

Hide cell values

When you hide a value in a cell, the cell appears to be empty. However, the formula bar still contains the value.

  1. Select the cells.

  2. On the Format menu, click Cells, and then click the Number tab.

  3. Under Category, click Custom.

  4. In the Type box, type ;;; (that is, three semicolons in a row), and then click OK.

Display hidden cell values

  1. Select the cells.

  2. On the Format menu, click Cells, and then click the Number tab.

  3. Under Category, click General (or any appropriate date, time, or number format other than Custom), and then click OK.

See also

Protect workbooks or sheets (2016)

Protect a workbook

Protect a sheet (2011)

2 comments:

  1. I think other web site proprietors should take this website as an model, very clean and excellent user genial style and design, as well as the content. You're an expert in this topic! app agentur berlin

    ReplyDelete
  2. Hello Everyone,

    Welcome to the future! Financing made easy with Prof. Mrs. DOROTHY LOAN INVESTMENTS

    Have you been looking for financing options for your new business plans, Are you seeking for a loan to expand your existing business, Do you find yourself in a bit of trouble with unpaid bills and you don’t know which way to go or where to turn to? Have you been turned down by your banks? MRS. DOROTHY LOAN INVESTMENTS says YES when your banks say NO. Contact us as we offer financial services at a low and affordable interest rate of 2% for long and short term loans. Interested applicants should contact us for further loan acquisition procedures via profdorothyinvestments@gmail.com

    Services rendered include:

    * Refinancing Loans
    * Car Loan
    * Truck Loans
    * COVID-19 Financing Loan
    * Home Loan
    * Mortgage Loan
    * Debt Consolidation Loan
    * Farm Loan
    * Business Loan [secure and unsecured]
    * Personal Loan [secure and unsecured]
    * Students Loan and so many others.

    For more info; Contact us via Email: profdorothyinvestments@gmail.com

    With Prof. Mrs. DOROTHY LOAN INVESTMENTS. you can say goodbye to all your financial crisis and difficulties as we are certified, trustworthy, reliable, efficient, fast and dynamic

    ReplyDelete