creating a new page, or gateway...

  • Thread starter Thread starter bbadami
  • Start date Start date
B

bbadami

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.
 
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.
 
thank you very much. what is VBA?

ShaneDevenshire said:
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.
Click to expand...
 
Right-click on a cell with a number and choose Hyperlink>Place in this
document.

Select your sheet and cell reference.


Gord Dibben MS Excel MVP
 
Back
Top