Lock columns width/row height

Question

Lock columns width/row height

Anonymous

Hello humans,

I can't find anything that allows me to define the column width or row height and lock it.

I typically have a data page with all sorts of tables, and I put a blank column in between each table. I could also make use of this to define a row at a specific height

Defining what width/height those columns/rows are allows one to still use the auto width/height button across the entire sheet without losing that setting.

I would have thought this could be done in cell styles or something...

Does this formatting criteria exist anywhere in anyway?

Thanks for your time!

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

1 answer

Answer 1

Hi Whirled P!

Thank you for writing to the Microsoft Answer Community Forum, I am Shakiru, an independent advisor and a user like you, and I am glad to be helping you out today.

To set the Column width, row height, and lock width and height in excel, please do this:

Set the Column width -Click on one or more columns. Navigate to the cells section of the home tab. Select the format button. Click "cell size." Click "column width." Type how wide you want the column to be. Select "ok."
Set the row height: Click on the rows you want to adjust. Go to the cells group in the home tab. Click the format button. Select "cell size." Click "row height." Enter how tall you want the row to be. Click "ok."
Lock the Lock columns width/row height: -Select the range of cells, columns and rows included> Right-click and click on format cells> click on the Protection tab and select lock or

-Select the range of cells, columns, and rows included> click the Format icon under the Home menu > click on Lock cells

Kind Regards, Shakiru

Please, remember to give back to the community. Help the next person with this problem by indicating with comments and rating based on the conversation to resolve the issue

Share via

Lock columns width/row height

1 answer