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