Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Views | Excel Discussion (Misc queries) | |||
Custom Views | Excel Discussion (Misc queries) | |||
Custom Views | Excel Discussion (Misc queries) | |||
Custom Views | Excel Worksheet Functions | |||
Custom Views | Excel Discussion (Misc queries) |