Join pages

[Potholes]

Hi All

I have attached a sample worksheet called potholes.

On the MASTER page I want to have another page ( SAY SHEET 1) to the RIGHT of MASTER at cell L13 and have them scroll but in NOT SYNC so I can copy cells accross to the master page

Last night I was advised to use ( View/Arrange All/Vertical )

Sadly this did not work.

I am using Excel 2016

If anybody can assist I will be gratful.

Peter

[peterrc]

Hi.

Please open attached file.

Click View and select "View Side by Side"
De-Select "Synchronous Scrolling"
Is this what you are after?

Regards

peterrc

[peterrc]

Edit,

Having uploaded the file, I opened it to check it was working and it openend showing "both windows" siude by side.

peterrc

[Potholes]

Good Morning to you.

I have downloaded your modified file and I cannot see on the Master sheet where you have the other sheet beside the Red vertical line.

if you can assist further I would be appreciated.


Many Thanks

Peter

[Potholes]

Hi again

I have uploaded just one file for some reason I originally had 2 files joined. ??

I trust you can assist


Regards

Peter

[peterrc]

Hi,

Not sure what has happened here (see my post #3), but if you download the file, then down load it a second time then:-
Click View and select "View Side by Side"
De-Select "Synchronous Scrolling"
Select Master in left hand screen and Sheet 2 in right hand screen.
I did this with the one you attached and it worked.
Please let me know if this works for you.

Regards

peterrc

[Potholes]

Hi Peter ( I'm assuming)

I have struggled with it for 30 minutes to no sucess, maybe it a function they have dropped in the 2016 version. ???

I can open 2 seperate files, but they still scroll in sync, even tho I have deselected it.

Pete

[AliGW]

Pete - it works fine here in 2016.

[Potholes]

Pete - it works fine here in 2016.

Hi all

I worked it out, the old brain is not as good as it used to be,

Many thanks


Is there a short cut to hide collums j through to the end. ??? short of Highlighting each collum


Peter

[Potholes]

Hi all

I worked it out, the old brain is not as good as it used to be,

Many thanks


Is there a short cut to hide collums j through to the end. ??? short of Highlighting each collum


Peter

[peterrc]

Hi Pete,

Thanks for the feedback.

@ALiGW thanks for your feed back too - I was beginning to think I had lost the plot!

With regard to hiding the 2 "J" columns I would suggest macros - how are you with macros?

Regards

peterrc

[AliGW]

Is there a short cut to hide collums j through to the end. ??? short of Highlighting each collum


Peter

I find that SHIFT selecting the columns I want to hide is pretty fast, unless you mean right to the right extremity of the sheet ...

[jason.b75]

Is there a short cut to hide collums j through to the end. ??? short of Highlighting each collum

Select a cell in column J (to hide only the columns that contain data, do this in a row that has data in all columns, to hide empty columns as well, use an empty row) then press Shift Ctrl and right arrow.

Right click in the selected range and hide - entire column.

[newdoverman]

I can't tell whether you have solved this or not. This is how I got side by side with your original workbook.
1. Click on the View Tab
2. Click on New Window
3. Click on Arrange All and select Vertical (you should see tabs for your worksheets in each window)
4. In the left window, click on the Master tab to select it.
5. In the right window, click on the Sheet1 tab to select it.

Hide the columns as suggested by Jason.b75
I couldn't upload a workspace file showing this so a picture will have to do.

[Potholes]

Hi Pete

It is too long since I attempted a macro, I have forgotten the procedures.

I want to hide say columm J to the extreme far right.


Pete

[Potholes]

HI all

I highlighted Collumm J shift/Control/right arrow and that highlighted all collums the hide them

Many thanks

All tho a macro would be nice

[jason.b75]

Just add a line like

Please Login or Register  to view this content.

to the end of your existing macro.

You could get some basic code to do that by recording a macro while you do it manually.

[Potholes]

Hi ron ??

Can you pm me pse