...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 ...
...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 ...
Question about Microsoft Office Computers & Internet
...row in excel (single cell) Start by 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 ...
...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 ...
Question about Microsoft Office Computers & Internet
...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 ...
excel i need to protect data in a cell that contains a formula. the same formula i need to use the next day ,gut the data in the same row of cells should not change? please help Highlight the cells ...
...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
Question about Microsoft Office Computers & Internet
...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" ...
8,855 questions posted
Usually answered in minutes!
711 Questions
239 Questions
265 Questions
207 Questions