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 October 25, 2023 Applies to: Microsoft® Excel® 2010, 2013, 2016, 2019, 2021 and 365 (Windows) You can freeze one or more rows in an Excel worksheet using the Freeze Panes command. If you...
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 October 15, 2023 Applies to: Microsoft® Excel® 2013, 2016, 2019, 2021 and 365 (Windows) You can remove or hide gridlines in Excel worksheets to simplify worksheet design. By...
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 May 26, 2022 Applies to: Microsoft® Excel® 2013, 2016, 2019, 2021 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 June 10, 2022 Applies to: Microsoft® Excel® 2013, 2016, 2019, 2021 or 365 (Windows) You can password protect worksheets and workbooks in Excel. If you want to prevent other users from opening...
Excel Shortcuts to Zoom In and Out in Your Worksheets (4 Shortcuts)

Excel Shortcuts to Zoom In and Out in Your Worksheets (4 Shortcuts)

Save Time in Microsoft Excel using Shortcuts to Zoom In or Out by Avantix Learning Team | Updated September 14, 2023 Applies to: Microsoft® Excel® 2013, 2016, 2019, 2021 and 365 (Windows) There are several mouse and keyboard shortcuts you can use to zoom in and out in...

Pin It on Pinterest