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...]

Get the Month or Year With Date Functions

Dates in Microsoft Excel are useful for tracking finances, orders, and sales. So, there may come a time when you want to pull a month or year out of a date entry. Functions and formulas make this an easy task.

There are a couple of ways to get a month from a date in Excel, depending on if you want to display the result as a number, word, or abbreviation. And luckily, you can use these same methods to get the year from your date entry.

[mai mult...]