May 13, 2009

Custom Views in MS Excel

Some times we create and use big files in Excel. It becomes difficult to search for the cell we want to work on. So we cannot use Go To features. Not only this we also get confused for go to new cell, print the new cell, create the print settings and make the builders.

Can we create and go to most used cells list. Yes we can. This depends on how do you see the Excel work sheet. The custom view feature gives the solution for this. First you decide the workbook view or printing view then you can save that. This makes some changes but this is to create your favorite views and settings. If you create the print setting for particular view that also gets saved in view setting. We can save and retrieve as many cells we want in a worksheet and hide others. This saves time and energy. Ways to creating the view setting.

First open your large workbook.
Then go to the place you are using.
Now make the changes you want. For example create print area, hide rows, filters, subtotals. Then create the view settings.
Go to view menu and select the custom view there. Now open the custom view window.
Press the Add button to create new view. The opened window gives the feature of decide the name of the new view. Select the view name that is used to identify easily.

You can also decide the new view print settings. After doing that give the name for view then click ok. This is a method for creating your favorite views and save these views. Now you return to the workbook and drop it there. Then you can retrieve the saved view. For that go to view menu then select custom views there. Select the wanted view in select the name of the view at the window and click show. Now you got a workbook with selected cells and settings. If you want delete the view setting go to custom views then press the delete button.

No comments:

Post a Comment

Please Leave your valuable comments here. Thanks in Advance.


Spend time by reading assumes no liability for the accuracy or completeness of any of the information contained on this web site. Furthermore, spend time by reading neither assumes liability for the accuracy or completeness, nor endorses the contents of, any outside links from our web site. This information is provided as a public service for convenience purposes only. Reliance upon the accuracy or completeness of the information contained herein is at the user’s risk. Users are strongly encouraged to make every effort to verify the accuracy and/or completeness of the information before reliance thereon.