ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   duplicate sheets (https://www.excelbanter.com/excel-discussion-misc-queries/84086-duplicate-sheets.html)

LaurieB

duplicate sheets
 
I am rather new to Excel and I have a problem that I can not figure out how
to correct. I would appreciate any help you can give me.

All of a sudden one of my sheets is appearing double. It is hard to explain
so bear with me. When I open this one sheet, and scroll down there is a
divider and it appears in exact duplicate below the other. When I make
changes to one it also changes the other.
Please help.



Ron Coderre

duplicate sheets
 
This is just a guess....

From the Excel main menu:
<Window
If you see "Remove Split"...select it.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"LaurieB" wrote:

I am rather new to Excel and I have a problem that I can not figure out how
to correct. I would appreciate any help you can give me.

All of a sudden one of my sheets is appearing double. It is hard to explain
so bear with me. When I open this one sheet, and scroll down there is a
divider and it appears in exact duplicate below the other. When I make
changes to one it also changes the other.
Please help.



James Hamilton

duplicate sheets
 
I think you have split your window. Go to window - remove split.

Whilst on this subject, play around with splitting thw window, and freezing
the pane - both very handy features.

"LaurieB" wrote:

I am rather new to Excel and I have a problem that I can not figure out how
to correct. I would appreciate any help you can give me.

All of a sudden one of my sheets is appearing double. It is hard to explain
so bear with me. When I open this one sheet, and scroll down there is a
divider and it appears in exact duplicate below the other. When I make
changes to one it also changes the other.
Please help.



LaurieB

duplicate sheets
 
Ron, Thank you. You were absolutely right. It seems so obvious but I had no
idea that it was called a "split window". I appreciate the help.
LaurieB

"Ron Coderre" wrote:

This is just a guess....

From the Excel main menu:
<Window
If you see "Remove Split"...select it.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"LaurieB" wrote:

I am rather new to Excel and I have a problem that I can not figure out how
to correct. I would appreciate any help you can give me.

All of a sudden one of my sheets is appearing double. It is hard to explain
so bear with me. When I open this one sheet, and scroll down there is a
divider and it appears in exact duplicate below the other. When I make
changes to one it also changes the other.
Please help.



LaurieB

duplicate sheets
 
James--Thank you SO much. It worked like a charm.
You guys are great.
LaurieB

"James Hamilton" wrote:

I think you have split your window. Go to window - remove split.

Whilst on this subject, play around with splitting thw window, and freezing
the pane - both very handy features.

"LaurieB" wrote:

I am rather new to Excel and I have a problem that I can not figure out how
to correct. I would appreciate any help you can give me.

All of a sudden one of my sheets is appearing double. It is hard to explain
so bear with me. When I open this one sheet, and scroll down there is a
divider and it appears in exact duplicate below the other. When I make
changes to one it also changes the other.
Please help.




All times are GMT +1. The time now is 08:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com