Tom’s Tutorials For Excel: Conditionally Formatting Locked and Unlocked Cells. There are times when your users will find it easier to enter data directly into worksheet cells, instead of a userform interface. Apr 09, 2019 · I have experienced this situation numerous times since upgrading to Excel 2016 (running on Win 7 Pro 64 bit). All patches/updates applied. Most often I am modifying a value in a cell, sometimes editing a formula, but often just changing a data value and when I hit enter all of a sudden my cursor keys are disabled. This means that to reference a header in a data table in a formula (and let that formula stay drag-able), you need to lock the reference. Fortunately, the header row of a data table always stays in the same place, so you can lock it like a normal cell reference in Excel. In the example formula above, that’s exactly what we did: B$1 Re: Scroll Lock Stuck in Excel 2007. May be you accidently press Fn+C instead of Ctrl+C (shortcut for Copy) . Can you please try to press Fn+C again to unlock the scroll lock function. Each row has a formula to subtotal the values. The sheet also has columns for each of the different types of donation: general fund, maintenance, special collection(s), etc. And each of these columns also has a subtotal. These subtotals are all totaled together elsewhere in the sheet. This Excel tutorial explains how to hide formulas from appearing in the edit bar in Excel 2007 (with screenshots and step-by-step instructions). In Microsoft Excel 2007, I have formulas in a worksheet that I don't want to be visible when that cell is selected. In this tutorial, we learn how to lock and unlock cells in Excel. First, right click one cell and click on format cells. Go to the protection cell, and then un-check the locked category.