How do you lock the top row and left column in Microsoft excel as in when you scroll down or right how do you get the top row 1 and the left column A to remain visible?
Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.