How to Freeze Rows in Excel (One or Multiple Rows)

How to Freeze Rows in Excel (One or Multiple Rows)

Freeze One or More Rows in an Excel Worksheet by Avantix Learning Team | Updated January 25, 2026 Applies to: Microsoft® Excel® 2016, 2019, 2021, 2024 and 365 (Windows) You can freeze one or more rows in an Excel worksheet using the Freeze Panes command. If you freeze...
How to Show or Hide Gridlines in Excel

How to Show or Hide Gridlines in Excel

Show or Hide Gridlines in Excel Worksheets (+ Shortcuts) by Avantix Learning Team | Updated June 2026 Applies to: Microsoft® Excel® 2016, 2019, 2021, 2024 and 365 (Windows) You can remove or hide gridlines in Excel worksheets to simplify worksheet design. By default,...
How to Lock Cells in Excel (3 Ways)

How to Lock Cells in Excel (3 Ways)

Easily Lock Cells in Excel Worksheets by Avantix Learning Team | Updated June 26, 2026 Applies to: Microsoft® Excel® 2016, 2019, 2021, 2024 or 365 (Windows) It's easy to lock cells in Excel to protect data or formulas. This is typically a two-step process. First,...
How to Password Protect Your Excel Worksheets and Workbooks

How to Password Protect Your Excel Worksheets and Workbooks

Protect Worksheets and Workbooks in Excel by Avantix Learning Team | Updated January 25, 2026 Applies to: Microsoft® Excel® 2016, 2019, 2021, 2024 or 365 (Windows) You can password protect worksheets and workbooks in Excel. If you want to prevent other users from...
How to Zoom In and Out Excel (6 Ways with Shortcuts)

How to Zoom In and Out Excel (6 Ways with Shortcuts)

Zoom In and Out in Excel Using Keyboard Shortcuts, the Ribbon and the Status Bar by Avantix Learning Team | Updated June 30, 2026 Applies to: Microsoft® Excel® 2016, 2019, 2021, 2024 and 365 (Windows) You can save alot of time by learning how to quickly zoom in and...

Pin It on Pinterest