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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
heading locking

ResolvedVersion 2010

Peter has attended:
Excel Intermediate course

Heading Locking

Having created a table for listing PAT tests, how do I lock line1 with the headings on so that the other lines pass up under it

RE: Heading Locking

Hi Peter, thanks for your query. Position the active cell at A2. Then from the ribbon choose the View tab, the Freeze Panes drop down and the Freeze Top Row option. That should lock row 1.

Hope this helps,

Anthony

Excel tip:

Shortcut for deleting all comments in a spreadsheet

If you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by:

1. Holding down Ctrl, then Shift, then O - this will select all cells containing comments in the worksheet you are looking at.

2. Right-clicking on one of the selected cells, and selecting Delete Comment from the menu that appears.

3. Clicking anywhere else in the spreadsheet to deselect comments - all comments should have disappeared from the spreadsheet.

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