Excel 2007: Freeze or unfreeze rows and columns

See more Excel 2007 demos at http://office.microsoft.com/en-us/help/FX100485311033.aspx With the Freeze Panes command in Microsoft Office Excel 2007, you can make sure specific rows and columns stay visible while you scroll. Watch the demo to learn how to freeze and unfreeze rows and columns, and make viewing your worksheet a snap.

Category:

Science & Technology

Tags:

• microsoft
• office
• excel
• demo
• training
• freeze
• rows
• columns
• spreadsheet
• worksheet
• unfreeze
• lock
• 2007
• how
• to

[strenaus]

Thank you!

[tarekyahia]

How u can block the 1st 3 cels not the only 1st one?

[atulmishram]

thank u

!!



[kingjohn630]

Thanks. I love the voice too.

[leppos]

Freezing multiple columns and rows at the same time seemed impossible... until I saw this video (big thanks!). I understand that Microsoft wanted to make this feature as simple as possible but that made it "highly illogical" and almost impossible for the user to figure out by himself

[billyyhman]

thanks!! was sooo blind trying to finding the freezing panel...until i came across the video

[HEEEEEEEEHAA]

I want to freeze a "SELECTED" piece of panes but I dont think there is a function for this.

[RussinoProductions]

Thank you soooooo much, this helped me a lot. I used to work with excell so long ago and was thinking about how to freeze the rows for 2 days now before you saved me:)

[caquito10]

thank you so much!!! helped me a lot!!!

[khalednedved]

wow thx much this help alot