Microsoft Office Tutorials and References
In Depth Information
Moving Data and
chapter
15
Moving Data and
Managing Worksheets
Simple spreadsheets are a good way to get a handle on Excel. But in the real
world, you often need a spreadsheet that’s more sophisticated—one that can
grow and change as you start to track more information. For example, on the
expenses worksheet you created in Chapter 14, perhaps you’d like to add
information about which stores you’ve been shopping in. Or maybe you’d like to swap the
order in which your columns appear. To make changes like these, you need to add a
few more skills to your Excel repertoire.
This chapter covers the basics of spreadsheet modification, including how to select
cells, how to move data from one place to another, and how to change the structure
of your worksheet. What you learn here will make you a master of spreadsheet
manipulation.
Selecting Cells
First things first: Before you can make any changes to an existing worksheet, you need
to select the cells you want to modify. Happily, selecting cells in Excel—try saying
that five times fast—is easy. You can do it many different ways, and it’s worth learning
them all. Different selection techniques come in handy in different situations, and
if you master all of them in conjunction with the formatting features described in
Chapter 16, you’ll be able to transform the look of any worksheet in seconds.
Making Continuous Range Selections
Simplest of all is selecting a continuous range of cells. A continuous range is a block
of cells that has the shape of a rectangle (high school math reminder: a square is a
 
Search JabSto ::




Custom Search