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