The function of ctrl+end is to navigate to the "lower right" cell with data in the worksheet with one click. \x0d\EXCEL system provides many "quick positioning" shortcuts. \x0d\ For example, CTRL+HOME, press a key to return to cell A 1. \x0d\CTRL+ up, down, left and right arrow keys, you can press a key to the next cell with the data in this row or column. If there is no data in the arrow direction of the row or column, you can press a key to the beginning or end of the row or column.