Windows 10: Hiding values in cells

Discus and support Hiding values in cells in Microsoft Office and 365 to solve the problem; Hi all, I have drawn a blank on how to hide cells that are empty, as in no data to display. I set up the formula and it calculates properly, but if it... Discussion in 'Microsoft Office and 365' started by Sven1458, Jan 30, 2019.

  1. Sven1458 Win User

    Hiding values in cells

    Hi all,
    I have drawn a blank on how to hide cells that are empty, as in no data to display.
    I set up the formula and it calculates properly, but if it gets to an empty cell, it will continue to display the results from the previous cell all the way to the bottom of the sheet, see picture below.
    Would like some help in hiding the cells that don’t have any data yet. I have done that before, but can’t remember how I did it.

    Hiding values in cells [​IMG]

    Sven1458, Jan 30, 2019

  2. how to effectively hide or disable the taskbar?


    Did you try the “Auto-hide the taskbar” option from Taskbar properties?

    If you have not tried it, I would suggest you to follow these steps and auto-hide the taskbar:

    • Right click on Taskbar.
    • Click on Properties
    • Check the box Auto-hide the taskbar.
    • Click on OK.

    Hope this information helps.
    Rohit Siddegowda, Jan 30, 2019
  3. Hide or Show User Profile's Personal Folders in Navigation Pane

    Hello Brink and thank you. This website is a very helpful resource. Hiding values in cells :)

    Your suggested answer will hide the User Profile folder in the Navigation Pane.

    Instead, this scenario involves not hiding the User Profile folder but hiding specific Personal Folders in the Navigation Pane that are marked "Hidden" in the Files/Folders Listing Area.

    My suspicion is that there are more "PinToNamespace" registry entries for me to toggle the DWORD value.
    TechGuy737, Jan 30, 2019
  4. Hiding values in cells

    Microsoft Free Cell

    Hi Peter,

    To help you reset your statistics in Free Cell, we suggest you to perform the following steps below:

    • Close the Microsoft Solitaire Collection (if it is open).
    • In the File explorer go to: C:\Users\<user name>\AppData\Local\Packages\Microsoft.MicrosoftSolitaireCollection_8wekyb3d8bbwe\LocalState\UserData\Guest\Statistic\
    • Rename Statistic.ark as old-Statistics.ark.
    • Run the Microsoft Solitaire Collection. The statistics will be back to 0.

    Let us know how it goes.
    Wilfred Mac, Jan 30, 2019

Hiding values in cells

  1. Hiding values in cells - Similar Threads - Hiding values cells

  2. Formatting Cells

    in Microsoft Office and 365
    Formatting Cells: I am trying to split one cell horizontally in a word table, but when I do, all the other cells in the row double in height. How do I add an extra row in one cell without altering the overall height? Thank you 151277
  3. Cells locking

    in Windows 10 Customization
    Cells locking: Dear Sir/Madam I created a programme using VBA. I am still a beginner. I wish to lock certain cells especially headings and data which is inputted. These cells would only be unlocked by password. Can you please help? Alfred Caruana...
  4. coping text from a excel cell to another excel cell

    in Windows 10 Network and Sharing
    coping text from a excel cell to another excel cell: I am trying to copy text from one excel to another excel cell automatically on the same worksheet"
  5. Excel copy and paste cell to non adjacent cell in Apple

    in Windows 10 Drivers and Hardware
    Excel copy and paste cell to non adjacent cell in Apple: In windows Excel to copy and paste to a non adjacent cell press the control key and move the cusor to the edge of the cell and you get an arrow with a plus sign to move the contents to another cell. On my Apple computer I cannot get an arrow to appear when I select the cell....
  6. Free Cell

    in User Accounts and Family Safety
    Free Cell: Freecell keeps bringing up the same game with a different game number - about ten times, now. Makes it easy to solve, but dead boring. Any ideas?"
  7. Android cell

    in AntiVirus, Firewalls and System Security
    Android cell: Can I use windows defender to scan my android cell phone?
  8. Cell and Ethernet connection

    in Windows 10 Network and Sharing
    Cell and Ethernet connection: Hello, I have been trying for some time to find a solution for Windows 10 that will allow cell connection and ethernet to work at the same time, we use the ethernet without any connection to configure IP based devices, once we connect the ethernet port the cell no longer...
  9. Free cell game

    in Windows 10 Gaming
    Free cell game: Why does my free cell game keep freezing up. It's my favorite game.
  10. Cell phone integration

    in Windows 10 Support
    Cell phone integration: Is there any way to get cell phone apps working from within Windows? Example: would like to use PC keyboard to type messages in WhatsApp. TIA 59437

Users found this page by searching for:

  1. 15_1 is not a valid integer value