Microsoft Excel for PC "lock row" Questions

...selecting the entire sheet, right clicking, going to "Format Cells", "Protection" and clearing the "locked" checkbox. Then select the rows or cells you want to protect and turn "locked" on for them. ...

...lock it so they cannot mess it up. What I do want is after the first row the next formula would be IF cell E7 = 5 and cell F7 = m, then go back to total that is in Row 80 and change the 1 to a 2 if ...

...row header and on the left of the first column header. All cells on the sheet are selected now. Ctrl 1 to open the format cells dialog. On the protection tab uncheck locked. After you do this select ...

...to format. Move the mouse to the highlighted area, press the right mouse button and make sure the locked option is on under the protection tab. Make sure protect sheet is enabled. To activate it, ...

...collection of sheets but if someone re-arranged the sheets, it'll break the formulas. You can lock the workbook so that people can't rearrange the worksheets but that will probably mess up

...lock, a top row as you scroll down the worksheet. For example, you may need to keep the top row of column titles visible at all times. The "View" tab on the command ribbon contains the "Freeze Panes" ...

...SCROLL LOCK is on, you scroll one row up or one row down. Or, you scroll one column to the left or one column to the right. To use the arrow keys to move between cells, you must turn SCROLL LOCK

y cant i write in any one of my coloms in ms excell It is possible you have locked the spreadsheet. I would check the spreadsheet to see if you have locked or protected the rows or columns or, maybe ...

I cant get past level 100. The locked jewels are different colors and I cant get three in a row same here, email me if you get the answer to solve it? [email protected]

...row in a worksheet. Moves to the cell in the upper-left corner of the window when SCROLL LOCK is turned on. Selects the first command on the menu when a menu or submenu is visible. CTRL+HOME moves to ...