Navigating a Spreadsheet Part 1

Remember: The size of the Scroll Bars will vary with the amount of information held Within the Workbook.

Navigating a Spreadsheet,

There are several ways in which to Navigate a Spreadsheet.

The Scroll Bars

1. Vertical Scroll Bar, this allows us to move up and down the Spreadsheet. It is located
at the right hand side of the Workbook Window.

2. On the Vertical Scroll Bar there are two Arrows, one on top and the other on the
bottom. You can use these to Scroll Up and Down The Top Arrow will move the
Spreadsheet towards the Top or Row 1, the Bottom Arrow will move the Spreadsheet
towards the bottom or towards row 1048576.

3. The Horizontal Scroll Bar, This is located at the bottom of the Workbook just above the
Status bar and to the right of the Tabs.

4. The Horizontal Scroll Bar has two arrows at either side of it. The one to the left will
scroll back towards Column A, the one on the right will scroll towards Column XSD (the
last Column in the Spreadsheet)

The Mouse Wheel

1. If you have a Wheel Mouse you can push down on the wheel you will get a Four Pointed arrow, this will allow you to move any direction on the Spreadsheet that you >want. One thing about this that I have discovered is that if you want to scroll down quickly, before you click the wheel, get close to the top of the Spreadsheet Cells. Then after you click the wheel the closer you get to the bottom of the Spreadsheet the faster it will scroll down.
The wheel also moves you up and down the Workbook, if you roll the wheel forward it will take you towards the top of the Spreadsheet, Row 1. If you roll the wheel backwards it will move the Spreadsheet down, towards Row 1048576.

The Mouse Left Button

1. Take your Mouse and hover over any Cell then click the Left Mouse Button and it will put you into that cell

The Tab Key

1. The Tab Key will take you one Cell to the right
2. SHIFT + Tab will take you one Cell to the left

The Enter Key

1. The ENTER Key will take you one Row down
2. SHIFT + ENTER will take you one Row up

The Address Bar

1. Will take you to the Cell Address that you tell it to
     a. Once you enter the Cell Address hit Enter

The Arrow Keys

1. Up Arrow will take you one Cell up
2. Down Arrow will take you one Cell Down
3. Left Arrow will take you one Cell to the Left
4. Right Arrow will take you one Cell to the Right

CTRL + Arrow Keys (Assuming you are starting from Cell A1 with information to cell H35)

1. First use of CTRL + Down Arrow will move you to Cell A35
2. Second use of CTRL + Down Arrow will move you to Cell A 1048576
3. Firs t Use of CTRL + Up will move you to Cell A35
4. Second use of Up Arrow will move you to Cell A1
5. First use of CTRL + Right Arrow will move you to H1
6. Second Use of CTRL + Right Arrow will move you to Cell XFD
7. First use of CTRL + Left will move you to Cell H1
8. Second use of CTRL + Left Arrow will move you to Cell A1

CTRL + Arrow Keys (Assuming you are starting from Cell A1 with information to cell H35 with missing information in Cell A14 and missing information in Cell E1)

1. First use of CTRL + Down Arrow will move you to Cell A13
2. Second use of CTRL + Down Arrow will move you to Cell A15
3. Third use of CTRL + Down Arrow will move you to Cell A35
4. Fourth use of CTRL + Down Arrow will move you to Cell A 1048576
5. Firs t Use of CTRL + Up will move you to Cell A35
6. Second use of Up Arrow will move you to Cell A15
7. Third Use of CTRL + Up will move you to Cell A13
8. Second use of Up Arrow will move you to Cell A1
9. First use of CTRL + Right Arrow will move you to D1
10. Second Use of CTRL + Right Arrow will move you to Cell F1
11. Third use of CTRL + Right Arrow will move you to H1
12. Fourth Use of CTRL + Right Arrow will move you to Cell XFD
13. First use of CTRL + Left will move you to Cell H1
14. Second use of CTRL + Left Arrow will move you to Cell F1
15. Third use of CTRL + Left will move you to Cell D1
16. Fourth use of CTRL + Left Arrow will move you to Cell A1

Go To

With the Go To you can navigate to any Cell in the Spreadsheet that you want to, similar to the Address Bar. The quick way to get to Go To is CTRL + G.