| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
creating a new page, or gateway...
what i would like to do is be able to create a "gateway" leading to a new
page, or new area of the current page when you click on a certain number. is there any way to accomplish this? for example, when i click on a certain cell i'd like it to open up a new page, or bring me down to the bottom of the current page with more information. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
creating a new page, or gateway...
Hi,
You might try a hyperlink. Press Ctrl+K and indicate where you want to go when the cell is clicked. If by "Open a new page" you mean a new worksheet, for that you would need VBA. If you are interested in programming let us know. -- Cheers, Shane Devenshire "bbadami" wrote: what i would like to do is be able to create a "gateway" leading to a new page, or new area of the current page when you click on a certain number. is there any way to accomplish this? for example, when i click on a certain cell i'd like it to open up a new page, or bring me down to the bottom of the current page with more information. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
creating a new page, or gateway...
thank you very much. what is VBA?
"ShaneDevenshire" wrote: Hi, You might try a hyperlink. Press Ctrl+K and indicate where you want to go when the cell is clicked. If by "Open a new page" you mean a new worksheet, for that you would need VBA. If you are interested in programming let us know. -- Cheers, Shane Devenshire "bbadami" wrote: what i would like to do is be able to create a "gateway" leading to a new page, or new area of the current page when you click on a certain number. is there any way to accomplish this? for example, when i click on a certain cell i'd like it to open up a new page, or bring me down to the bottom of the current page with more information. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
creating a new page, or gateway...
Right-click on a cell with a number and choose HyperlinkPlace in this
document. Select your sheet and cell reference. Gord Dibben MS Excel MVP On Tue, 26 Aug 2008 06:22:01 -0700, bbadami wrote: what i would like to do is be able to create a "gateway" leading to a new page, or new area of the current page when you click on a certain number. is there any way to accomplish this? for example, when i click on a certain cell i'd like it to open up a new page, or bring me down to the bottom of the current page with more information. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a summary page | Excel Discussion (Misc queries) | |||
| Creating a web page | New Users to Excel | |||
| creating a web page | Charts and Charting in Excel | |||
| Creating a summary Page | Excel Discussion (Misc queries) | |||
| Creating a web page using Excel | Excel Discussion (Misc queries) | |||
Linear Mode
