Excel Tricks

this blogs gives the complete information about ms excel . You can find any query from excel and get answers.

Best Offer for Books in Amazon

Excel Tips
Home
Excel Short Cuts

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

at May 03, 2017 No comments:

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Labels: Using Freezepans in Excel

Older Posts Home

Subscribe to: Posts (Atom)

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.

Excel Tricks: How to Use Transpose in Excel

Excel Tricks: How to Use Transpose in Excel : How to Use Transpose in Excel Transpose used to Convert Row Values to Column Values. E...
HOW TO USE COMPOUND INTEREST FORMULA IN EXCEL ?

HOW TO USE COMPOUND INTEREST FORMULA IN EXCEL A B Intial investment ...
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 scroll...