How to Move to the Last Cell in a Selected Range

This post explains that how to move to the last cell in a selected range in excel. How to quickly jump to the bottom of your selection of cells.

Move to the last cell

If you have a long list of data, and then wondered if you want to quickly select the last cell in a selected range, you can refer to the following steps to move to the last cell of a selection range in excel:

1# select a range of cells, such as: B1:D10.

move last cell1

2# then press Shift + Enter keys.

move last cell2

You will see that the last cell will be selected in your selection of range.


Note: if you are working on the Mac OS, you should use the shortcut Fn + ^ + ->



Related Posts

Excel Array Operation

We have all heard of arrays. Depending on the dimensionality, they are divided into one-dimensional arrays and two-dimensional arrays. Depending on the data type, they can also be divided into numeric arrays, logical arrays, and so on. The concatenation and ...

Excel Array Matrix Operation

In Excel, we have a built-in function used to perform matrix operations. It is the MMULT function. This function accepts two arrays as parameters and returns the product of the two arrays. However, this function has a prerequisite that the ...

A1 Reference Style and R1C2 Reference in Excel

In Excel, there are two reference styles. A1 reference style and R1C2 reference style. These two reference styles can help us find the cell by the cell address. Some functions return these two addresses through the argument settings. A1 Reference ...

Excel Structure Reference

This tutorial introduces the basics of structured referencing in Excel and shows you how to use structured referencing in a table with examples. When you use formulas that reference tables, whether the formula references a part of the table or ...

Excel/Google Sheets: Full Row Reference

Excel or Google sheets supports both full row references and full column references. This article will talk about the usage of full row references. Full Row reference is another cell reference in Excel or Google Sheets, which is used to ...


So empty here ... leave a comment!

Leave a Reply