freezing rows and columns
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Freezing rows and columns

Freezing rows and columns

resolvedResolved · Low Priority · Version Standard

replyReply Wed 20 Feb 2008, 16:42Delegate Tracy said...

Tracy has attended:
Excel Advanced course

Freezing rows and columns

How do I freeze rows and columns at the top and side of a worksheet so that when I scroll through the headers remain visible.

For upcoming training course dates see: Pricing & availability

replyReply Sat 23 Feb 2008, 22:34Trainer Cress said...

RE: Freezing rows and columns

For freezing rows, click the small rectangle at the top right, just above the scroll bar. Drag it onto the spreadsheet and place it wherever you want to freeze to start. You can also go to window and freeze panes.

 

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

Excel tip:

Select blank cells automatically

Get Excel to find any blank (empty) cells in a region for you by:

1. Selecting the appropriate region from your spreadsheet.

2. On the menu bar, go to Edit - Go to.

3. Click the 'Special' button, then select Blanks and click OK.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard