![]() Select the range of cells in your worksheet. For extending the selection to the entire row, please select the first or any cell of the row, … To select the array containing the active cell: CTRL+/ To select all cells that contain comments: CTRL+SHIFT+O (the letter O) In a selected row, to select the cells that don't match the value in the active cell CTRL+\ In a selected column, to select the cells that don't match the value in the active cell Zoom controls. This will open the ‘Go To’ dialog box Click on the Special button. For instance, if you desire to lock the first three rows, then click cell A4. ![]() ![]() Excel select all rows below mac Editing group, and click Find & Select > Go to Special… In the Go To Special dialog box, select Visible Cells only, and click OK.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |