Microsoft Office Tutorials and References
In Depth Information
Excel’s Ribbon User Interface
You can resize the horizontal scroll bar making it wider or narrower by
dragging the button that appears to the immediate left of its left scroll arrow. Just
keep in mind when working in a workbook that contains a whole bunch of
worksheets that widening the horizontal scroll bar can hide the display of the
workbook’s later sheet tabs.
To scroll very quickly through columns or rows of the worksheet when you
have a physical keyboard available, hold down the Shift key and then drag
the scroll button in the appropriate direction within the scroll bar until the
columns or rows that you want to see appear on the screen in the Worksheet
area. When you hold down the Shift key while you scroll, the scroll button
within the scroll bar becomes skinny and a ScreenTip appears next to the
scroll bar, keeping you informed of the letter(s) of the columns or the
numbers of the rows that you’re whizzing through.
If you have a mouse and it’s equipped with a wheel, you can use it to scroll
directly through the columns and rows of the worksheet without using the
horizontal or vertical scroll bars. Simply position the white cross mouse
pointer in the center of the Worksheet area and then hold down the wheel
button of the mouse. When the mouse pointer changes to a four-pointed
arrow with a black dot in its center, drag the mouse pointer in the
appropriate direction (left and right to scroll through columns or up and down to
scroll through rows) until the desired column or row comes into view in the
Worksheet area.
On a touchscreen device, you can also scroll new parts of a worksheet into
view simply by swiping with your finger or stylus to scroll (by dragging it on
the screen). To scroll new worksheet columns on the right into view, you
swipe right-to-left. To scroll new worksheet rows from below into view, swipe
up, bottom to top. The force with which you slide determines how many
columns or rows you scroll through. To return previously displayed columns or
rows into view, simply slide in the opposite direction: left to right to scroll
columns left and downward to scroll rows up.
The only disadvantage to using the scroll bars to move around is that the
scroll bars bring only new sections of the worksheet into view — they don’t
actually change the position of the cell cursor. If you want to start making
entries in the cells in a new area of the worksheet, you still have to remember
to select the cell (by clicking it) or the group of cells (by dragging through
them) where you want the data to appear before you begin entering the data.
Surfing the sheets in a workbook
Each new workbook you open in Excel 2013 contains a single blank
worksheet with 16,384 columns and 1,048,576 rows (giving you a truly staggering
17,179,869,184 blank cells!). But, that’s not all. If ever you need more
Search JabSto ::




Custom Search