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

microsoft excel

ResolvedVersion Standard

Nikki has attended:
Excel Introduction course

Microsoft Excel

How do I freeze the headings in the first row of the spreadsheet, so that they are visible from wherever I am in the data?

RE: Microsoft Excel

Top right hand corner of the tab just above the scroll bar is a little rectangle. Click and drag it onto the sheet and let go and headings will be frozen

Attached files...

Excel shot.bmp

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Excel 2010 Shortcuts - Start and End of the Worksheet

Did you know you can quickly move to either the beginning or the end of an Excel Worksheet using just a couple of keys on the keyboard?

Press Ctrl + Home key to move the cursor to cell A1

Press Ctrl + End key to move the cursor to the end of the current worksheet.

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.12 secs.