ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Duplicate Worksheet (https://www.excelbanter.com/excel-worksheet-functions/197524-duplicate-worksheet.html)

powrus

Duplicate Worksheet
 
A new software program insisted I change my desktop resolution to a higher
setting than I've used for years. I did so, which in turn gives me a broader
desktop coverage than before and causes the desktop icons [naturally] to be
smaller. Also, my MS Excel spreadsheets took on a new look following this
change.

I'm using Windows XP and using Office XP Standard, Version 2002.

I doubt anything actually changed in my Excel spreadsheet except for the
fact that I now see more on each sheet than I choose to see following the
increase in desktop resolution ... but I would like to know how to remove the
duplicate spreadsheet hovering in the background behind my primary
spreadsheet. My bottom spreadsheet's taskbar indicates the presence of two
spreadsheets - one hidden partially behind the other. The duplicate
spreadsheet appears to the extreme right hand side of my screen with only a
few columns in view. Any work done on the primary spreadsheet automatically
transfers to the hidden spreadsheet.

I understand this is probably something I caused in years past but never
became aware of the second (hidden) spreadsheet due to the lower desktop
resolution setting.

How do I make this duplicate spreadsheet go away? Thanks.

Gary Brown[_4_]

Duplicate Worksheet
 
The 'hidden' worksheet may be a phantom on your screen. Try updating your
display/monitor drivers from the manufacturer.
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"powrus" wrote:

A new software program insisted I change my desktop resolution to a higher
setting than I've used for years. I did so, which in turn gives me a broader
desktop coverage than before and causes the desktop icons [naturally] to be
smaller. Also, my MS Excel spreadsheets took on a new look following this
change.

I'm using Windows XP and using Office XP Standard, Version 2002.

I doubt anything actually changed in my Excel spreadsheet except for the
fact that I now see more on each sheet than I choose to see following the
increase in desktop resolution ... but I would like to know how to remove the
duplicate spreadsheet hovering in the background behind my primary
spreadsheet. My bottom spreadsheet's taskbar indicates the presence of two
spreadsheets - one hidden partially behind the other. The duplicate
spreadsheet appears to the extreme right hand side of my screen with only a
few columns in view. Any work done on the primary spreadsheet automatically
transfers to the hidden spreadsheet.

I understand this is probably something I caused in years past but never
became aware of the second (hidden) spreadsheet due to the lower desktop
resolution setting.

How do I make this duplicate spreadsheet go away? Thanks.


powrus

Duplicate Worksheet
 
Hi Gary - Thanks for the reply. I have been lurking on old forums and found
a post from May, '08 that seemed to help me find a fix to this issue.

In that discussion, Dave Peterson advised another poster to bring up the
problem worksheet and then hit Ctrl + W. I repeated that suggestion on my
worksheet and it worked for me. I then saved the remaining worksheet that
did not have a ghost. Things look good.

Roger



"Gary Brown" wrote:

The 'hidden' worksheet may be a phantom on your screen. Try updating your
display/monitor drivers from the manufacturer.
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"powrus" wrote:

A new software program insisted I change my desktop resolution to a higher
setting than I've used for years. I did so, which in turn gives me a broader
desktop coverage than before and causes the desktop icons [naturally] to be
smaller. Also, my MS Excel spreadsheets took on a new look following this
change.

I'm using Windows XP and using Office XP Standard, Version 2002.

I doubt anything actually changed in my Excel spreadsheet except for the
fact that I now see more on each sheet than I choose to see following the
increase in desktop resolution ... but I would like to know how to remove the
duplicate spreadsheet hovering in the background behind my primary
spreadsheet. My bottom spreadsheet's taskbar indicates the presence of two
spreadsheets - one hidden partially behind the other. The duplicate
spreadsheet appears to the extreme right hand side of my screen with only a
few columns in view. Any work done on the primary spreadsheet automatically
transfers to the hidden spreadsheet.

I understand this is probably something I caused in years past but never
became aware of the second (hidden) spreadsheet due to the lower desktop
resolution setting.

How do I make this duplicate spreadsheet go away? Thanks.



All times are GMT +1. The time now is 04:18 PM.

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