![]() ![]() If your’s is good enough, I will definitely expand this article to include it and then give you credit. There are probably other cool tricks as well, so if you have any to share with the world, you can post them in a comment. Here, you can confirm or edit the range of cells. Confirm the Cells and Apply Headers Using either of the above methods, a pop-up window will appear next. For example, entering A2:D8192 into the address box will select the cells from A2 to D8192. Select the range of cells that you want to convert, open the Insert tab, and click Table in the ribbon. If you know the addresses of both the top-left and the bottom-right cells, you can enter those address delimited by a colon into the address box and then press enter. Type the address of the final cell of the range into the address box and press SHIFT + ENTER.If you know the address of the last cell, you can do the following: Press SHIFT and then select the last cell in the range.Scroll down to the end of range (which is usually the end of the sheet) by using the scroll bar.If the range does contain empty cells, instead of dragging the selection from the top to the bottom, you can do the following: Select a range of adjacent cells: Click the table, click the cell once, then drag a white dot any. This will select all of the cells in the range as long as there are no empty cells in the range. Select a cell: Click the table, then click the cell once. Hold down CTRL (or if using a Mac COMMAND) and SHIFT on the keyboard and then press the down arrow key.Select the top-most cell in the desired range.Therefore a quick tip to select a large range of non-empty cells in a column, you can do the following: In the image below, we’ve selected five different cells. It's as if the Ctrl button isn't working but it is functional, so it must be an Excel issue. Now, hold down the Ctrl key and click to select additional cells. Excel is not letting me use these shortcuts or select multiple ranges, when holding down Ctrl and selecting the second range, instead of selecting it the right-click menu pops up and the first range is deselected. Of course, for a couple hundred rows, this doesn’t take too long, but if you have thousands or tens of thousands, this can take a while. You can also select multiple cells that are not connected to one another by using your Ctrl key. One of the things that I still find funny is when I ask a user to select all of the values in a column (not the column itself) and then user starts from the top and drags the selection until they reach the end. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |