Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / October 2006

Tip: Looking for answers? Try searching our database.

Why can't I close "Custom Views" for original views?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
smith - 12 Oct 2006 05:12 GMT
I hided some rows in Excel, and then added one custom views namefor it. But
when I click"Close" the custom views to see the original views that contains
un-hided rows, the rows can not be visible.

What is the problem? What can I do?
RagDyer - 13 Oct 2006 21:28 GMT
One of the shortcomings of the XL help files on this feature, is that they
never mention that there's *no way back* to the original worksheet display
(view).
You'll have to manually "unchange" individually all your changes in order to
return to the original display.

SO, the *first* thing to do when starting to create "Custom Views", is to
assign a name to the original sheet display, say something like "orig" (no
quotes).

Now, after you're finished with creating all your other views, you can click
on "orig" to return to the default sheet display.

If you're intending to produce many different views, or you'll be moving
back and forth between views often, you might wish to insert a "views"
window on your toolbar or menu bar.
This window will display the name of the current view, and will allow you to
change views by simply expanding the window and clicking on the name of any
of the other existing views in the sheet.

Right click in the toolbar and choose "Customize".
Under the "Commands" tab, in the left window click on "View".
In the right window, click and drag the "Custom View" window to either the
toolbar, or the menu bar (usually more room there).

Now you can easily navigate between views.
Signature

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

>I hided some rows in Excel, and then added one custom views namefor it. But
>when I click"Close" the custom views to see the original views that
>contains un-hided rows, the rows can not be visible.
>
> What is the problem? What can I do?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.