WebStep 1. Split the screen. To split the screen horizontally, place the cursor over the dash above the scroll bar at the far right of the spreadsheet just above the up arrow. The cursor becomes two lines with up and down … WebJun 24, 2015 · 1 Answer. To keep an area of a worksheet visible while you scroll to another area of the worksheet, you can lock specific rows or columns in one area by freezing or …

How to make top row always stay visible in Excel?

WebHow do I make the rows stay while scrolling in Excel? Select the cell in the upper-left corner of the range you want to remain scrollable. Select View tab, Windows Group, click Freeze Panes from the menu bar.Excel inserts two lines to … WebHow to keep first column visible when scrollingIn this excel tutorial for beginners, I’ll show you how you can always keep the first column of your worksheet... bsctf

How to fix a row and column in Excel when scrolling

WebSteps to Lock Rows/Columns in Excel. Go to the View tab and click the Freeze Panes button. From the drop down menu select if you want the header row, the first row of data, or the header column, the first column of data to be frozen. I will select Freeze Top Row to lock the first row in place. That’s it! WebMar 16, 2024 · Follow these steps to freeze only the first row in your sheet. Go to the View tab.; Click on the Freeze Panes command in the Window section.; Choose the Freeze First Column option from the menu.; This will result in Column A getting locked in view when you scroll to the right of the sheet. WebStep 1: Select the cell E1. This is because the first four columns are to be frozen. Step 2: In the View tab, click the “freeze panes” drop-down under the “window” section. Select “freeze panes,” as shown in the … bsctc employee directory