How can I freeze/ lock first row/ column of a Confluence table?

[Karina Sidorenko]

I can't apply any filter to the table as there's no option to open and edit as a macros. 

[Joe Davids]

Hello Karina

Just to elaborate on the answer above

Using the Table Filter Macro

Select the  Table View Tab

and Select 1 or 2 for the Freeze first N rows or first N columns

[Surya RK]

Thank you. Very helpful.

[Katerina Kovriga _Stiltsoft_]

Hi there,

As this question mentions our Table Filter and Charts for Confluence app, we are happy to introduce its new macro – Table Spreadsheet.

Our new macro allows you to work with fully functional Excel spreadsheets right in Confluence.

You’ll be able to use cells’ formulas, filters, conditional formatting, etc., create pivot tables and charts from the page view and edit mode.

The Table Spreadsheet macro is available for Cloud and Server/Data Center.

[Stiltsoft support]

And now you may also check two more macros from our spreadsheets' family:

• The Spreadsheet from Table macro that allows you to turn your manually created and macro generated (such as Jira Issues, Page Properties Report, etc.) tables into fully functioning live sheets.
• The Table Spreadsheet Include macro that allows you to reuse your spreadsheets' data across your Confluence instance.

We hope it helps your cases!

[Andrey Khaneev _StiltSoft_]

Hello Karina,

You need to use Table FIlter macro to freeze colunms / rows and to filter a table.