Share via

Excel Online - Protected Worksheet - Allow Hide Rows

Anonymous
2017-01-19T00:17:48+00:00

In a protected worksheet in excel online, I cannot allow users to hide rows.  This feature works in desktop excel when protecting the sheet by checking the "format rows" box, but fails when uploaded to excel online.  Now I have no way to allow users to "clean up" their worksheets by hiding blank (unused) rows.  This is important, I don't want users formatting, adding, or deleting rows, but I would like them to have the ability to hide blank rows so the data they enter can be printed onto one sheet.  Changing the row height only guarantees that the sheet will look like a mess, ie. all different row heights, which is undesirable as well.  Also it takes alot of time to do this for each row.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2017-01-19T06:26:52+00:00

    Hi Adam,

    Please select “Format columns” and “Format rows” in the Allow all users of this worksheet tolist, this will make “Hide rows” **** feature work in Excel online.

    Screenshot from Excel Online, using “hide rows” feature in protected sheet

     

    Thanks,

    Neha

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-01-21T09:48:24+00:00

    Hi Adam,

    Have you referred above reply? Are you able to hide the rows in protected sheet now?

    Regards,

    Neha

    0 comments