WebHere’s how to do it: 1. Open your Excel spreadsheet and select the row below the row or rows you want to freeze. 2. Click on the “View” tab in the ribbon at the top of the screen. Baca juga: Edit Copy Shortcut Excel. 3. Click on the “Freeze Panes” dropdown menu and select “Freeze Panes”. 4. WebThis takes you away from the reference row and column i.e cell A1, where you might need to revisit frequently. You will also agree that when you are working on one such worksheet, you might have to navigate into deep rows and columns. Image by Phil Whitehouse via Flickr.You will agree that an Excel sheet can run up to thousands of rows and columns.

How to Freeze Multiple Rows and Columns in Excel - YouTube

WebJun 20, 2024 · In case you want to lock several rows (starting with row 1), carry out these steps: Select the row (or the first cell in the row) right below the last row you want to … WebBy splitting the worksheet, you can scroll down in the lower pane and still see the top rows in the upper pane. To split this worksheet as shown above, you select below the row where you want the split – selecting row 13 splits the worksheet below row … incharge of westerville water treatment plant

Freeze Panes in Excel (In Easy Steps) - Excel Easy

WebJun 6, 2024 · Step 1: Select the row below the one you want to freeze. Image: Maria Diaz / ZDNet. If your table's header is on row 3, then select row 4. The row above the one selected is the one that will freeze. WebIn conclusion, we have seen four different methods to freeze rows and columns in Excel. Method 1 freezes only the top row, and Method 2 freezes only the first column. If you … WebOn the View tab, click Freeze Panes > Freeze Panes. Excel 2016 Select the row below the row (s) you want to freeze (select row 6, if you want to freeze rows 1 to 5). On the View … income tax return for mixed income earner