How to Customize your views for Quick reports in Excel?

You will also be facing issue while printing your Excel worksheet for a report. Like you will need to trim down the data and do changes like hiding the columns. Just to fit it into one page. It is so time-consuming and boring too because after printing it out you will need to undo the layout changes one by one.

Previously In Shortcuts: Lock Cells in Excel

Don’t worry in this tutorial I have mentioned the Excel’s Custom Views. It will help you to revert and save your layout changes within a single click.

STEP1: Adding Normal View

irstly, you must set a default view.

Once you get the default layout that you prefer for most of the cases, you will need to go to View > Custom Views:

Now, click on the Add to create a new Custom View option.

STEP2: Adding New Hidden View

Now you will need to prepare the second Custom View. So, for that you must select the first 4 columns. After that just right click and select Hide option.

Now follow this: 

Go to View> Custom Views:

Now you can try both views in action