Freezing Excel Rows

Freezing Rows and Columns in Excel: A Guide

The bigger an Excel table is, the harder it is to maintain an overview. The problem is that cells like the header bar become hidden without the use of special formatting. The following article shows you how to freeze certain Excel columns and rows so they stay visible when scrolling.

Enabling macros in Excel

Enabling Excel macros: How to activate these practical scripts

For over three decades, Microsoft has offered Excel, an excellent solution for creating simple spreadsheets and calculating complex formulas and functions. In addition to its vast functionality, another benefit of Excel spreadsheets is that you can create and use macros to automate any process or task. We’ll show you how to enable macros in Excel.

Showing Duplicates in Excel

Identifying Duplicates in Excel

There are several reasons why you may want to find duplicates in Excel – to filter out errors or analyse double entries. Excel can automatically display these duplicates to you. Thanks to colour highlighting, you can instantly see which entries appear more than once in your tables. And the feature is easy to use: We’ll explain how it works.

Own your online success
IONOS takes care of your online challenges
Create your website with the perfect domain and the UK's fastest hosting!