Best Offer for Books in Amazon

Showing posts with label Using Freezepans in Excel. Show all posts
Showing posts with label Using Freezepans in Excel. Show all posts

Wednesday 3 May 2017

Using Freezepans in Excel

Hi Readers !

     In this Lesson you will understand how to use 'Freeze pans' in Excel. Freeze pans normally use for stop scrolling for Top Row or First column of the Table, rest of the records will Scrolled normally, When we have huge data then it will be use full.



Steps;

1. View -> Freeze pans -> Freeze Top Row. / Freeze First Column.


Thank you
Excel Tips

How to Protect sheet in Ms-Excel

STEPS:  1. OPEN Ms-Excel 2. Go to Review-> Protect Sheet -> Protect sheet  3. enter Password -> Re-enter Password-> save.