Microsoft Office Forums - View Single Post - How do I freezes The rows

Thread: How do I freezes The rows

View Single Post

Old

05-23-2019, 11:18 AM

ArviLaanemets ArviLaanemets is offline

ArviLaanemets is offline

ArviLaanemets uses Windows 8

Windows 8

ArviLaanemets uses Office 2016

Office 2016

Expert

Join Date: May 2017

Posts: 873

ArviLaanemets has much to be proud of

ArviLaanemets has much to be proud of

ArviLaanemets has much to be proud of

ArviLaanemets has much to be proud of

ArviLaanemets has much to be proud of

ArviLaanemets has much to be proud of

ArviLaanemets has much to be proud of

ArviLaanemets has much to be proud of

ArviLaanemets has much to be proud of

Default

To freeze top 3 rows only:
Scroll the sheet up, so top rows are visible;
Celect cell A4;
Freeze Panes.

To freeze e.g. Top 3 rows and left 2 columns:
Scroll the sheet up and left, so top rows and left columns are visible;
Select cell C4;
Freeze Panes.

Reply With Quote