How Can I Freeze Row or Column in Revit schedule?

[p003154c]

I am preparing a LandUse Schedule and it has around 50 Column in it , is it possible to freeze the 1st column or row of the schedule ?

[Ilic.Andrej]

What do you mean by "freeze"? You can hide things if that's what you want

[Sahay_R]

Are you trying to make it non-editable? That won't and can't happen, because the schedule is a live link to the model. If you want a static column, I would create it with linework,make it look right, not have the information in the schedule, and put them together on the sheet.

[ToanDN · Accepted solution]

You cannot Freeze Rows or Columns of a schedule in Revit like you can in Excel. 

You can duplicate the schedule and hide every column except for the one you want to show, open both schedule views and place them side by side.  Still, it doesn't work well if your schedules are long and need vertical scrolling.

[p003154c]

Thanks

[Anonymous]

Pretty silly to not be able to do such a simple thing as keeping the headers on screen while you scroll down the schedule! But I've got a pretty silly solution to it - stick post-its on your screen to mark the columns of interest. Those will stay in place if you scroll vertically!

[ToanDN]

[Anonymous]

I believe this functionality has been recently added to Revit 2020? The silly workaround is for earlier versions (my current projects are in R2018 and R2019). Glad they finally got this taken care of!

[vbose4KBYL]

What about horizontally?

[adelliQF46M]

yes..can anyone help for this matter?

[Sahay_R]

The feature to "freeze headers" in schedules was introduced in Revit 2020.2. Click the "Freeze Header" button in the

. or right-click in the schedule and select "Freeze Header“.You can also right-click a in a schedule and select Freeze Header. To unlock them, click the button a second time. This feature applies only to the current Revit session and to the specific schedule view you are working with. Freezing headers does not work in panel schedules or graphical column schedules. 

Freezing the first column however, is not an available feature yet. Possibly submit an idea? 

[adelliQF46M]

In this case I want to hide the horizontal row without lost the total volume,so my suggestion is maybe next time revit can provide the horiz freeze on the menu

[Susana_Duarte_LMSI]

Here are 2 ideas you can vote on. Please do so!

Thank you!

[Modern Schedules] Add ability to freeze schedule rows and columns - Autodesk Community

Schedules Operate like Excel - Autodesk Community