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

  • Thread starter Thread starter smith
  • Start date Start date
S

smith

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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top