Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

none

ResolvedVersion 2010

david has attended:
Excel Introduction course

None

none

RE: none

Hi David

Thanks for attending the Excel Introduction training yesterday.

If you have any questions please go to www.stl-training.co.uk and sign in with your email address and your delegate account password.

Thanks
Doug
STL

Fri 9 Sep 2016: Automatically marked as resolved.

Excel tip:

Freeze Rows and Columns to keep lables displayed

You can freeze rows and columns in your worksheet so they don't move.

This allows you to keep row and column labels displayed on your screen as you move through a large worksheet.

Click below and/or to the right of the cell(s) you want to freeze. (NB. Excel freezes ALL the rows above and ALL the columns to left of the selected cell)

Click on the 'Windows' menu and selct 'Freeze Panes'.

Lines appear in your worksheet. The required rows and columns are frozen and remain on your screen as you move through your worksheet.

To unfreeze rows and columns, click on 'Window' menu and select 'Unfreeze Panes'.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.