Rows n columns in excel

Asked By 0 points N/A Posted on -
qa-featured

I have once seen my boss working on report on Microsoft Excel sheet all I want to know is that how can he fix the first row or column while working on around 12000 rows of data?

SHARE
Best Answer by Cash hahn
Answered By 0 points N/A #162341

Rows n columns in excel

qa-featured

 

I hope you have been talking about locking a single row/column and can scroll to the remaining data. This is done using a built-in feature of Microsoft Excel (2007 and later version) called Freeze Panes. You can have it by

·         Go to the VIEW tab on your workbook.

·         Choose Freeze Panes on the left side.

·         Here you will be provided some options about what row or column you want to freeze.

Choose the desired location to freeze and click ok.

Best Answer
Best Answer
Answered By 0 points N/A #162342

Rows n columns in excel

qa-featured

Hi,

You can use freeze panes to stop first row stable with scrolling. The way to do this is,

Go to the view tab and in the window group you can see freeze panes

Next click the arrow and select freeze top row.

This will make keep the first row visible while you scrolling.

And also you can use keyboard shortcut for do this job. It is ctrl + home button while you working at the bottom of your worksheet, it will get back you to the first cell of the sheet.  

Related Questions