How to Select Excel Cells and Reasons you might not be able to

The video guide shows several methods for selecting a range of cells with the mouse in Microsoft Excel. These include selecting individual cells, highlighting a range, up to selecting rows, columns, and even the entire worksheet. Selecting a large range of cells lets you re-format thousands of cells in a single operation. If you need to select hundreds of rows then it can become slow to use these methods as you cannot use the scroll bar whilst holding down the mouse. Alternative methods include keyboard shortcuts and entering the range in the address box (that normally reads A1 or similar) on the left of the formula bar.

There are some reasons you may not be able to select a cell by clicking on it. The most common is that the cell is locked and the worksheet is protected such that you cannot select locked cells. If column B of a spreadsheet is protected, you would also be unable to select cells A1 to C1 because of the locked cell in the middle. A related possibility is that the worksheet is protected such that you cannot select any cells. The worksheet will need unprotecting before you can select the cell.

Some cells contain hyperlinks. If a cell contains a website address, Excel's default behaviour would be to take you to that web page when the cell is clicked. Likewise an e-mail address will help you start a new e-mail. There is a further possibility that someone has created a hyperlink to a different place in the document. The solution is then to hold the mouse button down on the cell until the hand icon changes to an arrow.

Excel worksheets can also contain background code called macros. The underlying Visual Basic code can trigger when a cell is selected and automatically select a different place in your file. You can disable code temporarily by toggling Design Mode on, which is available from the Developer Ribbon.