Microsoft Office Tutorials and References
In Depth Information
Working with Range Names
Select the cells you want to transpose.
5. Choose Transpose. As you see in Figure 8-20,
Excel copies the selected cells into the new
area, transposing rows into columns or
columns into rows.
2. Choose Home>Clipboard>Copy (or press
The Transpose feature will not work if you
choose Cut instead of Copy.
3. Click the cell where you want the transposed
cells to begin.
4. Choose Home>Clipboard and click the down
arrow below Paste.
Figure 8-20
Reverse the flow of data by transposing cells.
Working with Range Names
If your worksheet doesn’t contain
massive amounts of data, then working with
individual cells is generally quick and easy.
However, as your worksheet data expands,
performing operations cell by cell can become tedious
and can allow for more human error. Instead, you
can work with a group of cells in a single
operation. You have already experienced working with
ranges if you selected more than once cell at a
time to move, copy, or delete. Let’s take that to the
next level. If you repeatedly go to or use in a
formula a specific cell or group of cells, it will help
you to assign those cells a range name.
A range name is basically a descriptive name for a
specified worksheet area, making them much
easier to remember than actual cell addresses.
Formulas can use range names, and the Go To
dialog box can recognize range names.
Naming a Range of Cells
Giving cells intuitive names makes locating data
easier. It also can help make formulas more logical and
easier to understand. (You’ll work with formulas in
Chapter 9.) Ranges can be a single cell, a contiguous
group of cells, entire rows, or entire columns. Use
the following steps to assign a range name:
Search JabSto ::

Custom Search