Register now or log in to join your professional community.
In a excel sheet we can use a lot of grid consist of column and row. We can get a lot of grid by moving scroll bar but if we want to limit the movement of scroll bar to work with certain number of column and row then what I have to do?
Hide unnecccessary coloumns and filter with useful criteria
By Filtering you can do that
Use Pivot Table in its very useful in managing bulky data.
page Layout-
print titles -
sheet-
(print area)-
Firstly we select the number of coloum and row who requaired me and then select set print area
Pivot table is good method
Data filters
Hide unnecessary or confidential information with "column hide" and then protect sheet
Go to view and click on page break preview.
