how do i freeze top row in excel for mac

How Do I Ze Top Row In Excel How To Freeze A

Its the Inventory List template that comes with Excel, in case you want to play along.

Switch to the View tab, click the Freeze Panes dropdown menu, and then click Freeze Top Row.

On the View tab, hit the Freeze Panes dropdown again, and this time select Unfreeze Panes.

To do that, switch to the View tab, click the Freeze Panes dropdown menu, and then click Freeze First Column.

In our example, it lets us keep the inventory ID column visible while we scroll through the other columns of data.

In this case, youll need to freeze a group of rows or columns.

Obviously, freezing just the top row wont work this time, so well need to freeze a group of rows at the top.

In our example, we want row five to stay on screen, so were selecting row six.

To select the row, just click the number to the left of the row.

Note that a thick gray line will always show you where the freeze point is.

Here, were selecting Row C because we want Row B to stay on screen.

Now, our column showing the months stays on screen as we scroll right.

How Do I Ze Top Row In Excel How To Freeze A

Youve seen how to freeze a group of rows or a group of columns.

Looking at Employee Attendance spreadsheet again, lets say we wanted to keep both the header with the weekdays (row five) and the column with the months (column B) on screen at the same time.

Here, we want to freeze row five and column B, so well select cell C6 by clicking it.

And it can really help when navigating large, complicated spreadsheets.

He has more than 30 years of experience in the computer industry and over 20 years as a technical writer and editor.

Hes written hundreds of articles for How-To Geek and edited thousands.

Hes authored or co-authored over 30 computer-related books in more than a dozen languages for publishers like Microsoft Press, OReilly, and OsborneMcGraw-Hill.

Hes also written hundreds of white papers, articles, user manuals, and courseware over the years.

Since we launched in 2006, our articles have been read more than 1 billion times.

How Do I Freeze Top Row In Excel For Mac