HOW TO SET CUSTOM VIEW AND FULL SCREEN IN EXCEL?

Table of Contents

• INTRODUCTION
• WHERE CAN BE MAKE USE OF CUSTOM VIEW IN EXCEL?
• BUTTON LOCATION FOR ADJUST CUSTOM VIEW AND FULL SCREEN IN EXCEL
• STEPS TO ADD CUSTOM VIEW IN EXCEL
• HOW TO VIEW FULL SCREEN IN EXCEL?

INTRODUCTION

Different layouts or views are very important in case of Excel. The reason for this importance is the absence of the clear cut boundaries between the pages as we find in the Word Processors.

Every time, when we start a new worksheet , it’ll always open in the NORMAL VIEW.

Before printing the sheet , we need to make all the settings over and again to bring the data sheet into the required format. This is where we may take the advantage offered by the CUSTOM VIEWS option.

Custom view is a setting which can be saved for different margins and settings which can be saved simply and re applied to the new data when necessary.

WHERE CAN BE MAKE USE OF CUSTOM VIEW IN EXCEL?

Custom View is simply a STATE SAVING OPTION which will save the hidden rows, columns, margins, headers , footers, other page settings etc.

It means, once you create a custom page view for a sheet [ You can make as many views as you want ], you can simply execute it to get a particular view in a moment.

CUSTOM VIEW IS APPLIED TO THE ONLY WORKSHEET OR SHEET WHERE YOU CREATED IT.

BUTTON LOCATION FOR ADJUST CUSTOM VIEW AND FULL SCREEN IN EXCEL

You can find the option to save or reuse custom view under the VIEW TAB and under WORKBOOK VIEWS section.

STEPS TO ADD CUSTOM VIEW IN EXCEL

STEPS:

• Do all the setting as your preference.
• Click CUSTOM VIEW.
• The following screen will follow.

• Click ADD.
• Put the name of the setting and click OK.
• Reuse the custom view, by again clicking the CUSTOM VIEWS button.
• The saved custom view will be shown.
• Double click the view , you want to apply.

HOW TO DELETE A CUSTOM VIEW?

You can simply delete a custom view with the following steps:

1. Go to VIEW TAB and choose CUSTOM VIEWS.
2. Select the VIEW from the given list which you want to delete.
3. Click DELETE as shown in the picture below.
   
   

HOW TO VIEW FULL SCREEN IN EXCEL?

It makes the excel work in full screen. The formula ribbon is folded and the sheet appears in full screen.

ESC can be pressed to get out of full screen