microsoft excel

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

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

Microsoft Excel

resolvedResolved · Low Priority · Version 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:

Create and delete borders

To put a border around the outside of a selected range, press Ctrl+Shift+&. Use Ctrl+Shift+_ (underscore) to remove any borders from a range.

View all Excel hints and tips


Server loaded in 0.09 secs.