How do I fixed top row on excel so it remains at the top when I scroll down.

HappySad

Hi. I want to keep to top row fixed (which has heading info) so that it remains at the top while I scroll down the spread sheet. How do I do this? What is this facility called?

Thanks

BonandDom

Go to data, and select feeze panes

Lagoon

View > Freeze Panes > Freeze Top Row

ManAtHome

Or could be Window>Freeze Panes (depends which version you have). If it's just a 'freeze panes' option (eg no 'top row' option), click into cell A2 before freezing (or B2 if you want to freeze column A as well as row 1).

HappySad

Thanks all - freeze panes is exactly what I needed!

ALSO - is there anyway of having a note attached to a row? One of my fields contains a lot of text, which I only want to reveal when clicked on.

Thanks

rmg1

They're called comments and are attached to a cell.
If you right-click on the relevant cell, you should get the option of "Insert Comment".

HappySad

Thanks rmg1.
Almost - but not quite what I'm after...
I want the comment to be an actual cell, so I have the option to expand/collapse, and so the expanded ones will print with the worksheet, or I can print a single row with expanded cell. OR perhaps a link to a report with excerpt in the cell.
Am I asking too much of excel, I'm used to using MS Access but my project falls between these 2 programs!

Thanks

EchoLocation

You can use a Macro to hide/unhide any row.

Sub RowToggle()

myrowstart = 4
myrowend = 4

If Rows(myrowstart & ":" & myrowend).EntireRow.Hidden = True Then
Rows(myrowstart & ":" & myrowend).EntireRow.Hidden = False
Else
Rows(myrowstart & ":" & myrowend).EntireRow.Hidden = True
End If

End Sub

Rather than have it run by clicking a cell, just insert a shape in the comment cell and assign this Macro to it.