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.

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.

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.

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.