grouping sheets
Thanks any way,
"Jim Thomlinson" wrote:
I am affraid that in xl when sheets are grouped together, they are by default
in edit mode and are edited together. There is no easy way around this that I
can think of.
--
HTH...
Jim Thomlinson
"wildauk" wrote:
HI JIm, I see what you are saying but I don't want to do the same thing on
each sheet I just want the cursor to be in the same place on each sheet, so
if I page down on sheet one then page two will page down as well but if I
type 150 into cell G5 one sheet one I do not get 150 in Cell G5 on sheet two.
Wildauk.
"Jim Thomlinson" wrote:
Hold down the Ctrl key while selecting sheets to individually select more
than one sheet. You can also use the Shift key to select multiple sheets.
While holding down the Shift key if you select another sheet all of the sheet
inbetween will also be selected.
Now what you do on one sheet will also be done on the other selected sheets.
--
HTH...
Jim Thomlinson
"wildauk" wrote:
Hi, When I used lotus 123 I used to group the sheets so if I was in cell a5
in the first sheet then if I moved to another sheet the curser was in cell a5
as well.
Can I do this with XL if so how?
Thanks in advance Wildauk.
|