IV-ArrangingAndViewing

IV-ArrangingAndViewing - IV. Arranging & Viewing the...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Excel makes it easy to rearrange a worksheet. Along with dragging data ranges to move them, you can add or delete rows and columns. In the illustration below, add a column for February data by clicking the Column C header to select it (the entire column appears in reverse video) and selecting Insert, Column from the menus. Excel inserts a new, empty column to the left. Inserting a row works in a similar fashion. The new row is inserted above the row whose header you selected. Delete a row or column by selecting its header and choosing Edit, Delete from the menus. Add multiple rows or columns at the same time by selecting more than one row or column header before choosing Insert, Row or Insert, Column . Delete multiple rows or or multiple columns at the same time by selecting their headers before choosing Edit, Delete . If your selections aren’t contiguous, hold down the Control key as you select them. Because you can’t delete overlapping selections you must delete rows and columns in separate operations.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
One- and two-way splits A common situation is to have a large amount of data in a worksheet and to lose the view of the data headers when scrolling down or across the data. Excel provides a way for you to “fix” headers in place so they always remain visible. In the illustration below, headers to the left of a spreadsheet survey data have been fixed in place. This is accomplished by using the mouse to drag the vertical
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 7

IV-ArrangingAndViewing - IV. Arranging & Viewing the...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online