Excel rows keep changing to max height

Question

I'm working on a spreadsheet in Excel 365 and some of my rows keep randomly changing to max height. I change them back and then the problem occurs in another section of the spreadsheet. What is the fix for this?

Answer 1

Thank you for the information. I implemented the steps you outlined but that solution doesn't seem to allow for me to use the filter function. Is there something I can do to permanently fix the row height issue and still be able to filter my spreadsheet?

Answer 2

Hi ExcelUser3-31-22, I am Juliet and It's my pleasure to help you today.

How are you? I hope you are doing good.

I know how frustrating this may be for you but I'll do my very best to help you :)

I would suggest you try the following methods below:

A. try Disabling the Lock Property for all Cells

Below are the steps to disable the lock property for all the cells, after which we can lock the row height and the column width:

1. Select all the cells in the worksheet by clicking on the gray triangle at the top-left part of the worksheet.
2. Click on the gray triangle to select all cells
3. Click the ‘Home’ tab
4. In the Number group, click on the dialog box launcher icon (the small tilted arrow icon at the bottom right of the group)Click the dialog box launcher in the Number group
5. In the Format cells dialog box that opens up, click on the ‘Protection’ tab
6. Uncheck the Locked option
7. Click OK

By doing this we have ensured that even if we protect the entire worksheet the cells would still remain editable.

When you protect a worksheet in Excel, the cells would be completely locked (i.e., the user won’t be able to edit the cells and enter anything into it). But this happens only when the Locked property is enabled. If you disable the Locked property, the cells would remain editable even after protecting the worksheet.

Now, let’s move to the second step, which is to protect the entire sheet.

B. Protecting the Entire Worksheet

Now let’s see how to quickly protect the entire worksheet.

1. Click the ‘Review’ tab
2. Click the Review tab in the ribbon
3. In the Protect group, click on the ‘Protect Sheet’ option
4. In the Protect Sheet dialog box that opens up, enter the password (optional)
5. Enter the password in Protect Sheet dialog box
6. Check all the options in the Protect Sheet dialog box (except the ‘Format Columns’ and ‘Format Rows’ options).
7. Row height and column options grayed out
8. Click OK

The above steps would protect the worksheet, but at the same time allow the user to do all the regular stuff such as formatting the cells or deleting/adding rows and columns.

Since we have disabled the format columns and format rows option (in the Protect Sheet dialog box), these will still remain locked for the user.

This means that you won’t be able to change the row height or column width in this worksheet. The row height or column width would be constant.

I hope it helps! Let me know the results.

source:

https://trumpexcel.com/lock-row-height-column-w...

++++++++++++

Standard Disclaimer: There are links to non-Microsoft websites. The pages appear to be providing accurate, safe information. Watch out for ads on the sites that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the sites before you decide to download and install it

Answer 3

Hello ExcelUser3-31-22,

I am Jaenise, and I am happy to help you with your concern.

Sorry to hear this problem. Have you tried performing an office repair already? If not, please try to run office repair to fix any issue within the application. Please refer to the article below on how to do it.

https://support.microsoft.com/en-us/office/repa...

Please let me know if the issue is resolved or not so that we can investigate further.

If there’s anything I can do, please just let me know.

Stay safe & have a nice day.

Sincerely,

Jaenise

Answer 4

i'm sorry that didn't work. Let me open this thread so other advisors could help you :)