#Microsoft office

Every Excel cell is locked by default, but that setting does nothing until you protect the sheet. Here's the two-step process to keep specific cells editable.

Excel's View tab has one Freeze Panes menu that locks the top row, the first column, or any block of rows and columns you pick while the rest scrolls.

Learn how to wrap text in Excel with the Wrap Text button, add a manual line break with Alt+Enter, and fix cells where wrapped text still gets cut off.

Learn how to build an Excel drop-down list with Data Validation, using typed items or a cell range, plus how to edit it later and add error alerts.