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

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