Microsoft Office Tutorials and References
In Depth Information
QUICKLY CREATE MANY RANGE NAMES
To repeat this with the next sheet, use Ctrl+Tab to switch to the right window
and press Ctrl+Page Down to go to the next sheet. Right-click the border of
A1, drag to B5 in the left window, and select Create Hyperlink Here. Repeat for
each additional sheet.
Additional Details: If you want to also provide a “Return to Menu” hyperlink at
the top of each worksheet in the reporting workbook, follow these steps:
In the right window, move to the fi rst report worksheet.
In the left window, type Return to Menu in cell A3 of the menu.
Select cell A3. Right-click the border and drag to cell H1 of the right window.
Choose Create Hyperlink Here.
In the right window, put the worksheets in Group mode. With the fi rst
worksheet selected, Shift+click the last worksheet.
In Group mode, go to cell H1. Press F2 and then press Enter to copy the
words Return to Menu in cell H1 of all the worksheets. (Unfortunately,
this by itself does not establish the hyperlink in each worksheet.)
Press Ctrl+C to copy the hyperlink from the fi rst worksheet.
Press Ctrl+Page Down and Ctrl+V to paste the hyperlink on the next
worksheet. Repeat this step for each additional worksheet.
Close the second window by clicking the X at the top of the right window.
Summary: Dragging titles as hyperlinks is a fast way to create a hyperlink
menu.
1.
2.
3.
4.
5.
6.
7.
8.
QUICKLY CREATE MANY RANGE NAMES
Challenge: Quickly create many range names in a worksheet. If you decide
that complicated formulas would benefi t from referring to named ranges instead
of cell addresses, you might have a daunting task of individually naming many
ranges.
Setup: If your headings are suitable range names, you can use them to quickly
create the range names. The commands are slightly different in Excel 2003
and earlier and in Excel 2007.
Solution: In any Excel version, select the data set, including the headings that
will be used a range names.
In Excel 2003 and earlier, choose Insert, Name, Create. In the Create Names
dialog, choose Top Row and click OK (Figure 74).
 
 
Search JabSto ::




Custom Search