between data entries with the Ctrl key and the arrow keys in Sheet1 of Book1. (Excel 2007)
- Press Ctrl+→, Ctrl+↓, Ctrl+←, and Ctrl+↑ in succession to jump the cell cursor from one corner to the next of the entire Sheet1 worksheet. The first time you press Ctrl+→, the cell cursor jumps from cell A1 all the way to cell XFD1. When you next press Ctrl+↓, the cursor jumps from cell XFD1 all the way down to cell XFD1048576. When you then press Ctrl+←, the cursor jumps all the way left to cell A1048576, and from there all the way back up to cell A1 when you press Ctrl+↑. All this corner-to-corner jumping happens because there are no occupied cells in a particular direction, so the cursor jumps right to the cell on each border of the worksheet.
- Move the cell cursor to cell A18, type Stop, and press Ctrl+Home. Next, press Ctrl+↓.The cell cursor stops in cell A18 rather than A1048576 because A18 is now occupied with the label Stop.
- Move the cell cursor to cell AB18, type Stop again, and then press Home. Now, press Ctrl+→.This time, the cell cursor stops in cell AB18 rather than XFD18 because AB18 is now occupied.
In case your excel version is 2003 the row ranges will be 65536 and colum IV
No comments:
Post a Comment