Tuesday, July 10, 2012

How to Freeze a Cell or Column in Excel

I work with Excel allot in my job and use a ton of shortcuts.  I thought I would share this handle little tidbit with you all. 

How to Freeze a Cell or Column in Excel 

For Mac Excel 2011

Open excel Spread sheet, then Select the Layout tab from the toolbar at the top of the screen. Click on the Freeze Panes button and click on the Freeze Top Row option in the popup menu.

For PC office 2010

First off, head over to View tab, click Freeze Top Row to make the row labels appear, when you are scrolling.

Now if you want to freeze first column, Click Freeze First Columnto do the same with the columns.

No comments:

Post a Comment