How to Lock Column Width and Row Height in Microsoft Excel

Do you have an Excel sheet where you want the columns and rows at fixed sizes? You can lock the column width and row height for your entire spreadsheet in a few steps to prevent accidental resizing.

Maybe you have data that you want to display in a specific way. For instance, you might expand a cell to accommodate a large font or an image. Because it’s so easy to resize columns and rows by dragging them, you or a collaborator might do it unintentionally. Rather than spending time constantly getting those columns or rows back to the sizes you want, just lock them.

[mai mult...]