In this section we will learn to go to different parts of the workbook
- To scroll up and down rows of the worksheet by windows, press the Page Up orPage Down or click the blank area above or below the scroll box in the verticalscroll bar.
- To scroll left and right columns of the worksheet by windows, click the blank areato the left or right of the scroll box in the horizontal scroll bar.
- To quickly scroll through rows or columns of the worksheet, hold down the Shiftkey as you drag the scroll box up or down in the vertical scroll bar, or left and rightin the horizontal scroll bar.
- If you use a mouse with a wheel button, scroll up and down the rows of the worksheetby rotating the wheel button forward (to scroll up) and backward (to scrolldown).
- If you use a mouse with a wheel button, pan through the rows and columns of theworksheet by clicking the wheel button and then dragging the triangular mousepointer in the direction you want to scroll.
- In case you want to go to a specific row and colum eg A65000 then you can use the "GO" Function. We have not started using any functions yet its OK. Press F5 and a box appears. Type A65000 in it and press enter. The cursor will move to that cell -- EASY !!
No comments:
Post a Comment