Go To Using F5

In an earlier post, I mentioned that the last cell in Excel was XFD1048576.

If you needed to scroll from cell A1 to cell XFD1048576, you could use the arrow keys on the keyboard but it will take you some time to get there. Fortunately Excel allows you to jump to a specific cell. Just press the F5 function key on your keyboard.

The Go To dialog box will appear. Just type the cell you want to go to and click the OK button.

If you click on the Special button, the Go To Special dialog box will appear.

No comments:

Post a Comment