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