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.

Splitting Excel Cells

Splitting Cells in Excel: How to Divide Cell Content Among Multiple Columns

If a table field contains several values, it often makes sense to split the respective Excel cell. Although the Microsoft spreadsheet program doesn’t offer a general function for this, you can split the cell content among multiple columns by configuring and using separators. We explain how you can use this option in your Excel document.

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 analyze double entries. Excel can automatically display these duplicates to you. Thanks to color 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.

Wait! We’ve got something for you!
Have a look at our great prices for different domain extensions.

Enter the web address of your choice in the search bar to check its availability.
$1/1st year
then $15/year
$1/1st year
then $15/year
$1.60/1st year
then $20/year
$1/1st year
then $25/year