ElyxAI

1184+ Excel How-To Guides

Step-by-step tutorials to master Excel. Quickly find the solution to your problem.

1184 results

Remove Duplicates

Data Manipulation

Find Duplicates

Data Manipulation

Highlight Duplicates

Data Manipulation

Sort Data

Data Manipulation

Sort by Date

Data Manipulation

Sort by Color

Data Manipulation

Sort Alphabetically

Data Manipulation

Filter Data

Data Manipulation

Filter by Color

Data Manipulation

Filter by Date

Data Manipulation

Use Advanced Filter

Data Manipulation

Find and Replace

Data Manipulation

Transpose Data

Data Manipulation

Split Text to Columns

Data Manipulation

Merge Columns

Data Manipulation

Combine Cells

Data Manipulation

Concatenate Text

Data Manipulation

Extract Text from Cell

Data Manipulation

Remove Extra Spaces

Data Manipulation

Clean Data

Data Manipulation

Convert Text to Numbers

Data Manipulation

Merge Cells

Formatting

Unmerge Cells

Formatting

Wrap Text

Formatting

Change Column Width

Formatting

Change Row Height

Formatting

AutoFit Column Width

Formatting

Apply Conditional Formatting

Formatting

Create Data Bars

Formatting

Use Color Scales

Formatting

Add Icon Sets

Formatting

Create Custom Number Format

Formatting

Format Dates

Formatting

Format as Currency

Formatting

Format as Percentage

Formatting

Add Borders

Formatting

Change Cell Background Color

Formatting

Use Format Painter

Formatting

Freeze Rows

Rows Columns

Freeze Columns

Rows Columns

Freeze First Row

Rows Columns

Freeze First Column

Rows Columns

Unfreeze Panes

Rows Columns

Hide Rows

Rows Columns

Hide Columns

Rows Columns

Unhide Rows

Rows Columns

Unhide Columns

Rows Columns

Group Rows

Rows Columns

Group Columns

Rows Columns

Insert Rows

Rows Columns

Insert Columns

Rows Columns

Delete Rows

Rows Columns

Delete Columns

Rows Columns

Delete Blank Rows

Rows Columns

Create Dropdown List

Validation

Create Dependent Dropdown

Validation

Restrict Data Entry

Validation

Allow Only Numbers

Validation

Allow Only Dates

Validation

Create Input Message

Validation

Need help with Excel? Try ElyxAI

Our AI assistant can help you create formulas, analyze your data and automate your Excel tasks.

Try for free