Home >Tips >Excel cell styles kalmstrom.com site map icon Site map  

Excel Cell Styles – Locked and Open Cells

An Excel tutorial by Peter Kalmstrom

Excel iconThe video below demonstrates how to use Excel cell styles. Peter Kalmstrom, CEO and Systems Designer, explains how to lock certain cells in a spreadsheet and let other cells be open for editing.

As an example Peter uses a spreadsheet with sales estimates for each month of the year, but the idea can be used for any data.

Excel sheet


Peter uses Excel 2013 for his demo, but most of what he does is possible to do in earlier versions also.