|Going to the Corners of a Selected Range
Summary: There are times when you need to quickly move to a corner of a selected range.There is an Excel shortcut that makes this easy to do. Here is how:
Once you have selected the range, hold down the Ctrl key while you press the period key. Excel will move you around the outside corners of the range, in order.
In addition, you can move from the upper-left corner of the selection to the lower-right corner by pressing Shift+Tab once. To move back (from bottom-right to upper-left), just press the Tab key once.
Back to top
Summary: The AutoFill function is a great tool to use when you are doing certain types of editing. Here is an example to illustrate how useful it can be.
Let's assume we have a column full of values in column A running from A3 through A417. We want to fill the adjacent cells in column B with a numerical sequence of values running from 1 through 415. Use the following steps to accomplish this task:
- In cell B3, place the value 1.
- In cell B4, place the value 2.
- Select the range B3:B4.
- Double-click on the AutoFill handle. (The black square in the bottom right corner of cell B3)
No dragging and you now have cells B5:B417 filled with sequential values.
Summary: It is very useful to be able to define hyperlinks in your workbooks. However, there are times when you no longer need a hyperlink and you need to delete it. Here is how to do this:
Select the cell that contains the hyperlink.
- Right-click on the hyperlink. Excel displays a Context menu.
- Choose Remove Hyperlink. Excel dutifully removes the hyperlink.
You can also get rid of a hyperlink by simply deleting the contents of the cell. Select the cell and press the Del key or the Backspace key. The cell contents will disappear. However, only the contents have been deleted; the formatting remains. If you later type something into the cell, it will appear as blue and underlined, and you will think it is a hyperlink and it isn't. It is just formatted as a hyperlink. To solve this problem you will need to change the formatting.
Formatting Page Numbers
Summary: Word has a variety of standard page numbering formats. However, you are not restricted to these formats. You can format page numbers exactly the same as you format any other text in your document. Here is how to do this:
Your first step, of course, is to insert the page numbers in either the header or footer.
When you are working in the Print Layout view, you can double-click on the header or footer, select the page number, and manually format it.
You format the page numbers exactly the same as you format any other text in your document. For example, you can make the page numbers bold, italic, change their size, etc.
However, if you are in the Draft or Outline view, you will have to switch to the Print Layout view before you can edit the header or footer. (If you use the Header and Footer tools on the Insert tab of the ribbon in order to access the header or footer, Word switches you to the Print Layout view automatically.)