Clicking this option makes the first column visible as you scroll the remaining spreadsheet. How To Freeze Panes In Excel For Mac Krista Joy Vetetokrista Joy Veteto. To freeze the top row in an Excel spreadsheet go to the View tab then to the Freeze Top Row button. Freeze the First Column of a Worksheet.įollow these three easy steps to get that header to stay in placeTo freeze the top row of a worksheet. To freeze the first row and column open your Excel spreadsheet. Want to freeze multiple rows andor columns.
How To Freeze A Row In Excel So It Remains Visible When You Scroll To Better Compare Data On Different Parts Of A Spreadsheet Business Insider India Once you choose this action the top row stays in place as you scroll down the rest of the spreadsheet.Įxcel for mac freeze top row. With this option you can only see the top row as you scroll the remainder of the spreadsheet.