Ze A Cell On Excel For A For Free By Whitelisting

Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions.

If you want to easily edit two parts of the spreadsheet at once, splitting your panes will make the task much easier.

Frozen cells are rows or columns that remain visible while you scroll through a worksheet.

If you want to keep the top row of cells in place as you scroll down through your data, select Freeze Top Row.

To keep the first column in place as you scroll horizontally, select Freeze First Column.

If you want to unlock the frozen cells, click the Freeze Panes menu again and select Unfreeze Panes.

If the data you want to keep stationary takes up more than one row or column, click the column letter or row number after those you want to freeze.

Its not possible to freeze rows or columns in the middle of the sheet.

This freezes the columns or rows before the one you selected.

Click View. 2. Click Freeze Panes.

Select Freeze Top Row or Freeze First Column.

Ze A Cell On Excel For A For Free By Whitelisting

Please help us continue to provide you with our trusted how-to guides and videos for free by whitelisting wikiHow on your ad blocker.

If you really cant stand to see another ad again, then please consider supporting our work with a contribution to wikiHow.

How To Freeze A Cell On Excel For A Mac