Excel help.

[Vipers]

Hi guys, a simple question if you know the answer, this is something I used some time ago, and forget how to do it, and I have no examples to look at.

I have an excel worksheet with two pages on, if thats what you call them, one is called "Feet" the other "Metres", what I am trying to do it this :-

On the "Feet" one put in a cell. "Metres" and when I click on it it will go to the other page, and visa versa.

[davepoth]

Possible, certainly; but can't you just click on the relevant tab? Or Ctrl+PgUp/PgDn?

Anyway, right click on the cell, and select "hyperlink", which will be somewhere near the bottom of the menu. The rest should be obvious from there.

[Tonsko]

Ctrl-K is shortcut for hyperlink.

[Vipers]

Got as far as the hyperlink, no further.

I seem to recall you enter the name of the page with ! at the end or beginning or both, its know its simple, but cant remember it, years since I used it.

[Vipers]

davepoth said:

Possible, certainly; but can't you just click on the relevant tab? Or Ctrl+PgUp/PgDn?

Anyway, right click on the cell, and select "hyperlink", which will be somewhere near the bottom of the menu. The rest should be obvious from there.

Yes I could click on the page to change, just wanting to make it easier for a friend of mine who will be the user, just a bold statement, so when in the "Feet" page, a box with "Metres" in, click and it changes.

[FlossyThePig]

Vipers said:

davepoth said:

Possible, certainly; but can't you just click on the relevant tab? Or Ctrl+PgUp/PgDn?

Anyway, right click on the cell, and select "hyperlink", which will be somewhere near the bottom of the menu. The rest should be obvious from there.

Yes I could click on the page to change, just wanting to make it easier for a friend of mine who will be the user, just a bold statement, so when in the "Feet" page, a box with "Metres" in, click and it changes.

Can we take a step back and ask what you are trying to achieve by flipping between the two worksheets (pages)? What are they going to be used for?

[davepoth]

Vipers said:

Got as far as the hyperlink, no further.

I seem to recall you enter the name of the page with ! at the end or beginning or both, its know its simple, but cant remember it, years since I used it.

feet!A1 will reference the cell A1 in the worksheet "feet".

[Vipers]

'

FlossyThePig said:

Vipers said:

davepoth said:

Possible, certainly; but can't you just click on the relevant tab? Or Ctrl+PgUp/PgDn?

Anyway, right click on the cell, and select "hyperlink", which will be somewhere near the bottom of the menu. The rest should be obvious from there.

Yes I could click on the page to change, just wanting to make it easier for a friend of mine who will be the user, just a bold statement, so when in the "Feet" page, a box with "Metres" in, click and it changes.

Can we take a step back and ask what you are trying to achieve by flipping between the two worksheets (pages)? What are they going to be used for?

At work we run altitude trials, the spreadsheets read out Height, Torr, ppo2, and mbs. A very basic calculation. Manufactures come to us to test products at altitude, ie pregnancy kits, these are sold for example in the states, and some locations are well above seawater, so we pull a vacuum in a chamber to simulate height above sea water.

There are two spreadsheets, one for Feet and one for Metres, so I want to choose either to work on.

I know I did the swap thingy years ago, but have forgotten how to do it, I think davepoth (cheers) has the answer, will be trying that this afternoon when I get home.

Example of spreadsheet :-

Edited by Vipers on Tuesday 27th January 07:40

[Planet Claire]

davepoth said:

Possible, certainly; but can't you just click on the relevant tab? Or Ctrl+PgUp/PgDn?

Anyway, right click on the cell, and select "hyperlink", which will be somewhere near the bottom of the menu. The rest should be obvious from there.

Yes, once selected Hyperlink, click on the 'Place in this document' icon down the left hand side and then you will be given the option to insert a cell reference from the list of worksheets you have available.

[Tycho]

Planet Claire said:

davepoth said:

Possible, certainly; but can't you just click on the relevant tab? Or Ctrl+PgUp/PgDn?

Anyway, right click on the cell, and select "hyperlink", which will be somewhere near the bottom of the menu. The rest should be obvious from there.

Yes, once selected Hyperlink, click on the 'Place in this document' icon down the left hand side and then you will be given the option to insert a cell reference from the list of worksheets you have available.

This ^^^^.

Here is a page with screenshots

[Vipers]

Tycho said:

This ^^^^.

Here is a page with screenshots

Looking good, will be straight on the laptop this afternoon when I get home.

[Vipers]

Thanks to all of you, my little problem is solved. I knew I could rely on PH's, as always.