 Using the Mouse to Move Cells
|
Summary: It is handy, at times, to use the mouse to move cells around a worksheet. Here is how to do this:
- Select the range of cells you want to move by highlighting the range with the mouse.
- Position the mouse pointer over the heavy border that surrounds the selected range. The pointer should turn into an arrow.
- Click and drag the range to a new location. As you move the mouse, the outline of the range moves.
- When you are satisfied with the new location, release the mouse pointer.
The cells are moved. If there is anything already at the target location, Excel may ask you if you want to overwrite the existing cells. You can respond according to your desires.
|
Hiding a Worksheet
|
Summary: There are times when you want to hide a particular worksheet so that it cannot be easily accessed. This is often done to protect information on a worksheet or keep it from prying eyes. To hide a worksheet, follow these steps:
Select the worksheet you want to hide.
- Display the Home tab of the ribbon.
- In the Cells group, click the Format tool. Excel displays a menu.
- Choose Hide & Unhide, and then choose Hide Sheet.
The worksheet is immediately hidden. Once hidden, there is no way to tell it is "missing," as there is with hidden rows and columns. If you later want to unhide the worksheet, follow these steps:
- Display the Home tab of the ribbon.
- In the Cells group, click the Format tool. Excel displays a menu.
- Choose Hide & Unhide, and then choose Unhide Sheet. Excel displays the Unhide dialog box. Select the worksheet name you want to unhide.
- Click on OK.
You can also display the Unhide dialog box by displaying the View tab of the ribbon and clicking the Unhide tool, in the Window group.
|
Back to top
Summary: There are many different ways to sum a column or a row. Here is how to quickly do it from the keyboard:
- Select the first empty cell at the bottom or to the right of the numbers you want to add.
- Select ALT+"=".
- Press the Enter key.
The numbers will be summed.
|
|
Displaying the Ruler
Summary: The ruler appears at the top of each Word document window. It is highly useful when you need to adust your formatting. There are times, however, when the ruler is not visible. When that happens here is how to get it back:
Word allows you to control whether the ruler is displayed or not. If the ruler is not displaying do the following:
- Click on the View tab of the ribbon
- In the Show group click on the ruler check box.
The ruler will now be visible.
|
