The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Cells

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Cells

Resolved · High Priority · Version 2007

ReplyMon 18 May 2009, 14:03Delegate Abdur said...

Cells

how to freeze cells?

For upcoming training course dates see: Pricing & availability

ReplyMon 18 May 2009, 15:52Trainer Amanda said...

RE: cells

Hello Abdur

Thank you for your question and welcome to the forum.

I am assuming you are referring to using freeze panes?

To use the freeze panes in Excel 2007, go to the View tab, and click the Freeze Panes button within the Windows group of buttons.

You have three options:
Freeze top row (freezes first row only)
Freeze first column (freezes left most column only)
If you have selected a cell at the intersection of the rows and columns you would like to freeze, then select Freeze Panes to freeze both rows and columns.

I hope this helps.

Kind regards
Amanda

Tue 26 May 2009: Automatically marked as resolved.

Excel articles

· How To Disguise Error Messages In Excel 2007/2010
· How To Create Formulas In Excel
· Creating Top Tables With Excel
· Excel Brings You The Tools To Spice Up Your Spreadsheets
· Tools From Advanced Excel Courses: Goal Seek and Solver

Please browse our web site to find out more about
excel computer training and other Microsoft training courses.

Excel tip:

Quickly copy a formula across sheets

Suppose you have a formula in cell Sheet1!B2, say =A1*5%, that you wish to copy to cell B2 on Sheet2, Sheet3 and Sheet4. Instead of using copy and paste, try this: (1) Select Sheet1!B2. (2) Group Sheet1 with the worksheets Sheet2, Sheet3 and Sheet4 by holding down Ctrl and clicking on the tabs of the sheets to group them. (3) Press the F2 key, then immediately press Enter to copy the formula in Sheet1!B2 across the grouped sheets.

Remember to ungroup the sheets afterwards! Right-click on any tab and choose Ungroup Sheets to do that.

View all Excel hints and tips

Can someone please remind me how I display multiple columns in a combo box. For instance if I have a combox box with colums Fee Earner and Fees how to I make it display both of these and not just the name of the fee earner.

Grateful for some help here ..

» Forum post: Combo Box - display

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions