How to create Custom Views of your Worksheet in Excel | Custom View | Views | Tips and Tricks |easy
How to create Custom Views of your Worksheet in Excel | Custom View | Views of your choice | Tips and Tricks in Excel
_________________________________________________________________
A view include settings for the following :
1 Print Settings
2 Hidden rows and columns
3 Worksheet view ( Normal, Page layout and Page break
preview )
4 Selected cells and ranges
5 Active Cell
6 Zoom Factor
7 Window size and positions
8 Frozen panes
_________________________________________________________________
Drawback of Custom View :
If TABLE is inside a workbook (in any worksheet),
Custom view will not work
_________________________________________________________________
How to Create a Custom View in EXCEL :
1 Set up the view settings - hide some columns
2 Choose view - workbook views - custom views - Dialog box
appears
3 click add - Add view dialog box appears
4 provide a descriptive name
5 Click ok to save the view
_________________________________________________________________
**********************************************************************
Please Subscribe My Channel:
/ @excelplanet
**********************************************************************
Playlists Link
0001 Introduction to Excel
• 0001 Introduction to Excel
0002 Entering and Editing Data in Excel
• 0002 Entering and Editing Data in Excel
0003 Worksheet View Control
• 0003 Excel Worksheet Operations & Features
0004 Working with Cells and Ranges
• 0004 Cells and Ranges in Excel
0005 Excel Tables and its Features
• 0005 Excel Tables and its Features
0006 Worksheet Formatting
• 0006 Worksheet Formatting
0007 Understanding Excel Files
• 0007 Understanding Excel Files
0008 Using and Creating Templates
• 0008 Using and Creating Templates
0009 Printing Your Work
• 0009 Printing Your Work
**********************************************************************
#Excel #ExcelPlanet #maniya44
#MSExcel #Maniya44 #Learn
#Education #Training #Tutorial
#LearnExcel #Excel2013 #ExcelFunctions
#ExcelTutorial #Excel2016 #ExcelFormulas
#ELearning #Excel2019 #ExcelPivot
#Software #MicrosoftExcel #HowTo
#Application #How #subscribe
#PrintSettings #Print #PageSetup
#WaterMark #Header #Footer
#HeaderAndFooter #Codes #Options
#PagesetupSettings #PreventCellsFromPrinting
#Cells #PreventObjectsFromPrinting
#Objects #CreatingCustomViews
#CustomViews #CreatingPdfFiles #Create
#CustomView #PdfFiles #CreatePDF
**********************************************************************