Why is Excel not letting me highlight cells?

Why is Excel not letting me highlight cells?

To work around this issue, use one of the following methods: Do not clear the Select Locked Cells check box when you protect a worksheet: Start Excel, open your workbook, and then select the range that you want to allow access to. Click Protect Sheet, leave the Select Locked Cells check box selected, and then click OK.

How do I get my cursor back to normal in Excel?

Windows Excel: Go to File > Options > Advanced. Go to After pressing Enter, move selection and use Direction arrow to choose a direction. Mac Excel: Go to Excel > Preferences > Edit. Go to After pressing Enter, move selection and use Direction arrow to choose a direction.

How do I enable highlighting in Excel?

How to Highlight Cells in Excel

1. Open the Microsoft Excel document on your device.
2. Select a cell you want to highlight.
3. From the top menu, select Home, followed by Cell Styles.
4. A menu with a variety of cell color options pops up.
5. When you find a highlight color that you like, select it to apply the change.

Why is my cursor not changing in Excel?

You can turn it on in the Excel option window. Click on File > Options > Advanced and make sure the box “Enable fill handle and cell drag-and-drop” is checked.

Why is my fill color not working in Excel?

The Display tab of the Accessibility Options dialog box. Clear the Use High Contrast check box. Click OK.

Why is F2 not highlighting cells?

3 Answers. Go to File -> Options -> Advanced and check the Enable fill handle and cell drag-and-drop option. You can click on the cell is press F2 that should bring up the cell references.

How do I unfreeze my cursor in Excel?

To turn off scroll lock, execute the following step(s).

1. Press the Scroll Lock key (Scroll Lock or ScrLk) on your keyboard.
2. Click Start > Settings > Ease of Access > Keyboard > Use the On-Screen Keyboard (or press the Windows logo key + CTRL + O).
3. Click the ScrLk button.

Why are my up and down arrow keys not working in Excel?

One of the common reasons why the arrow keys don’t work in Excel is because you’ve enabled the scroll lock feature on your computer. For as long as it remains enabled, the keys won’t do what they’re supposed to do. Simply press the scroll lock button on your keyboard and the lock will be disabled.

How do I activate F2 and F4 in Excel?

In other words, select the cell you want, press F2 to enter edit mode, use the left and right arrow keys to move through the formula, and press F4 whenever you want to cycle a reference through various permutations of absolute and relative notation.

What does F11 do in Excel?

F11 Creates a chart of the data in the current range in a separate Chart sheet. Shift+F11 inserts a new worksheet. Alt+F11 opens the Microsoft Visual Basic For Applications Editor, in which you can create a macro by using Visual Basic for Applications (VBA).

How do I highlight selected cells in Excel?

1. Select a cell which you want to highlight the column and row, then, click Kutools > Reading Layout, and the column and row of the selected cell have been highlighted, when you click other cell or range of cells, the column and row of the new cell are highlighted automatically, see screenshot: Notes:

When selecting one cell, multiple cells highlight?

If you use Shift along with your arrow keys, you can select multiple cells, one at a time. For example, if you start in any cell and press Shift +?, it highlights the original cell and the cell just below it. The same idea applies to the left, right, or up arrows.

How do you highlight a cell?

Select a cell that is formatted with the highlight that you want to use. On the Home tab, in the Clipboard group, double-click Format Painter , and then drag the mouse pointer across as many cells or ranges of cells that you want to highlight. When you’re done, click Format Painter again or press ESC to turn it off.