Enter and format data

Enter

Enter data manually in worksheet cells

Fill data automatically in worksheet cells

Enable Flash Fill in Excel

Create a list of sequential dates

Create a custom list

Paste options

Move or copy

Copy visible cells only

Move or copy worksheets or worksheet data

Move or copy cells and cell contents

Find

Find or replace text and numbers on a worksheet

Find and remove duplicates

Locate hidden cells on a worksheet

Select cells, ranges, rows, or columns on a worksheet

Format cells

Apply or remove cell borders

Hide or show gridlines on a worksheet

Use conditional formatting to highlight information

Format numbers

Available number formats

Format numbers

Format numbers as percentages

Format numbers as dates or times

Format a date the way you want

Format numbers as currency

Keeping leading zeros and large numbers

Create or delete a custom number format

Format text

Format text in cells

Change the case of text

Convert numbers stored as text to numbers

Wrap text in a cell

Align or rotate text in a cell

Worksheet

Hide or show worksheets or workbooks

Lock or unlock specific areas of a protected worksheet

Turn off Scroll Lock

Split panes to lock rows or columns in separate worksheet areas

Group or ungroup shapes, pictures, or other objects

Insert or delete a worksheet

Consolidate data in multiple worksheets

Rows and columns

Insert or delete cells, rows, and columns

Hide or show rows or columns

Change the column width and row height

Split text into different columns with the Convert Text to Columns Wizard

Freeze panes to lock rows and columns

Automatically number rows

Split text into different columns with functions

Combine two or more columns by using a function

Cells

Move or copy cells

Merge and unmerge cells

Combine text from two or more cells into one cell

Apply data validation to cells

More on data validation

Create a drop-down list

Add or remove items from a drop-down list

Remove a drop-down list

Create, apply, or delete a custom view

Customize the QAT (Quick Access Toolbar)

Customize the ribbon in Office

View two or more worksheets at the same time