#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default Custom Views

I know how to create a cusom view, but I can't seem to figure out how to get
back to the regular view. My custom view mostly involves hiding columns.
Thanks in advance.
--
Michael Gudyka
St. Charles, IL
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Custom Views

Maybe you can show all the columns you want to see in the normal view, then give
it a nice name in the custom view dialog (name it Normal(?)).

Then you can just show this "Normal" view.

Or you can unhide all the columns you want to see each time.

Michael Gudyka wrote:

I know how to create a cusom view, but I can't seem to figure out how to get
back to the regular view. My custom view mostly involves hiding columns.
Thanks in advance.
--
Michael Gudyka
St. Charles, IL


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default Custom Views

As you've discovered, there is *no way* to return from a "Custom View".

You'd think MS would mention this in the Help files on the feature, but they
don't.

All you can do is, *before* you create your first Custom View, create a name
for the original sheet in "Custom View" and say call it:
orig
And then you can return to it by *going* to the "orig" view.

BTW, you can add a "Custom View" window to your menu or tool bar.

Check out this old post:

http://tinyurl.com/2rnogq

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Michael Gudyka" wrote in message
...
I know how to create a cusom view, but I can't seem to figure out how to
get
back to the regular view. My custom view mostly involves hiding columns.
Thanks in advance.
--
Michael Gudyka
St. Charles, IL



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default Custom Views

UH OH. Does this mean, that since I hit "SAVE" while in a custom view, that
I will never be able to get the info that was in my normal view back? (since
I did not create a "full view" prior)

Jo

"RagDyer" wrote:

As you've discovered, there is *no way* to return from a "Custom View".

You'd think MS would mention this in the Help files on the feature, but they
don't.

All you can do is, *before* you create your first Custom View, create a name
for the original sheet in "Custom View" and say call it:
orig
And then you can return to it by *going* to the "orig" view.

BTW, you can add a "Custom View" window to your menu or tool bar.

Check out this old post:

http://tinyurl.com/2rnogq

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Michael Gudyka" wrote in message
...
I know how to create a cusom view, but I can't seem to figure out how to
get
back to the regular view. My custom view mostly involves hiding columns.
Thanks in advance.
--
Michael Gudyka
St. Charles, IL




  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Custom Views

Nope.

It just means that you'll have to show things manually. Unhide what you want
unhidden (rows and columns).

After you set it the "normal" way, save that as a custom view. Then it'll be
easier to get back there the next time.

Jo4321 wrote:

UH OH. Does this mean, that since I hit "SAVE" while in a custom view, that
I will never be able to get the info that was in my normal view back? (since
I did not create a "full view" prior)

Jo

"RagDyer" wrote:

As you've discovered, there is *no way* to return from a "Custom View".

You'd think MS would mention this in the Help files on the feature, but they
don't.

All you can do is, *before* you create your first Custom View, create a name
for the original sheet in "Custom View" and say call it:
orig
And then you can return to it by *going* to the "orig" view.

BTW, you can add a "Custom View" window to your menu or tool bar.

Check out this old post:

http://tinyurl.com/2rnogq

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Michael Gudyka" wrote in message
...
I know how to create a cusom view, but I can't seem to figure out how to
get
back to the regular view. My custom view mostly involves hiding columns.
Thanks in advance.
--
Michael Gudyka
St. Charles, IL





--

Dave Peterson


  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default Custom Views

I don't know. It appears that I cannot get them back, since I had hit save.
I tried using format, unhide columns and nothing happens. I hit that several
times. I also tried undo, but no joy there either. Very frustrating. Any
other advice would be appreciated.

Thanks, Jo


"Dave Peterson" wrote:

Nope.

It just means that you'll have to show things manually. Unhide what you want
unhidden (rows and columns).

After you set it the "normal" way, save that as a custom view. Then it'll be
easier to get back there the next time.

Jo4321 wrote:

UH OH. Does this mean, that since I hit "SAVE" while in a custom view, that
I will never be able to get the info that was in my normal view back? (since
I did not create a "full view" prior)

Jo

  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Custom Views

What columns are hidden?

If they are all to the left side, maybe you can unfreeze panes:
window|unfreeze panes
Then scroll to the left to see if it worked.

If it doesn't maybe you can try widening the columns.
Edit|goto
type: A:IV
format|column|width and give it a nice number

Jo4321 wrote:

I don't know. It appears that I cannot get them back, since I had hit save.
I tried using format, unhide columns and nothing happens. I hit that several
times. I also tried undo, but no joy there either. Very frustrating. Any
other advice would be appreciated.

Thanks, Jo

"Dave Peterson" wrote:

Nope.

It just means that you'll have to show things manually. Unhide what you want
unhidden (rows and columns).

After you set it the "normal" way, save that as a custom view. Then it'll be
easier to get back there the next time.

Jo4321 wrote:

UH OH. Does this mean, that since I hit "SAVE" while in a custom view, that
I will never be able to get the info that was in my normal view back? (since
I did not create a "full view" prior)

Jo


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom Views Dave F Excel Discussion (Misc queries) 1 November 17th 06 04:11 PM
Custom Views Stu W Excel Discussion (Misc queries) 1 August 6th 06 05:01 PM
Custom Views gailann Excel Discussion (Misc queries) 1 June 30th 06 04:26 PM
Custom Views Dana Excel Worksheet Functions 1 March 6th 06 09:52 PM
Custom Views GLT Excel Discussion (Misc queries) 0 October 21st 05 06:15 PM


All times are GMT +1. The time now is 09:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"