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.

1 comment:

  1. Every single line is full of meaning and kind of need for coming future. This blog is so much necessary for the related people. Really helpful for those who read it as me and very thanks to u for posting it. Best of luck.

    ReplyDelete