Sort the table columns and use the table search field to find help topics.

Use the ‘Show entries’ dropdown to expand or reduce the number of items listed per page.

Use the first ‘A-Z’ column to reset the list.

A-Z: reset table	Help title and page link	Includes video	Main topic	Keywords	Function	Formula
A	Add an average line to a horizontal bar chart	Yes	Average line on a chart	Charts	No	No
A	Add an average line to a vertical bar chart	Yes	Average line on a chart	Charts	No	No
B	Remove blanks using Advanced Filter	No	Remove blank cells	Blank cells	No	No
C	CELL references and ranges	No	Absolute and relative cell references	Cell references	No	No
C	Fill down cells in a column	Yes	Fill down cells	Cells	No	No
C	Insert multiple rows or columns	Yes	Insert multiple rows or columns	Cells	No	No
C	Set equal columns or rows	Yes	Set equal column widths or row heights	Cells	No	No
C	Create a multi-level category chart in Excel	Yes	Multi-level category chart	Charts	No	No
C	CHOOSE function with LINEST in Excel	No	CHOOSE and LINEST functions	CHOOSE, LINEST	Yes	No
C	CHOOSE function with array	Yes	CHOOSE with array	CHOOSE	Yes	No
C	COMPARE more than two values in Excel	No	Compare values	Compare	No	Yes
C	Excel's CONCATENATE function	Yes	Create SQL statements using Excel's CONCATENATE function	CONCATENATE	Yes	Yes
C	CONDITIONAL formatting of non-sequential cells	Yes	Conditional formatting	Conditional formatting	No	No
C	Copy and paste a formula	No	Copy and paste	Copy paste	No	No
D	Insert current date	No	Date	DATE	Yes	No
D	Insert current date and time	No	Date and time	DATE	Yes	No
D	Create a dropdown list	Yes	Create a dropdown list with data validation	Data validation	No	No
E	Calculate and add error bar data to a chart	Yes	Calculate and add custom error bar data	Error bars	No	No
F	FORMULATEXT function	No	Display a formula in another cell	FORMULATEXT	Yes	Yes
G	Group and subtotal data	Yes	Group and summarize data	Group	No	No
I	IF function	Yes	IF	IF	Yes	No
I	IFERROR function	Yes	IFERROR	IF	Yes	No
L	Add a data label to one point on a chart	Yes	Add a data label	Label	No	No
P	Paste special with formulas	Yes	Add, subtract, multiply or divide a set of values by another value	Paste Special	No	No
P	Protect an Excel workbook	No	Protect a workbook	Protect	No	No
R	Generate random numbers with RANDBETWEEN	Yes	Generate random numbers	RANDBETWEEN	Yes	No
S	Calculate a RUNNING TOTAL in Excel	Yes	Running total	SUM	Yes	Yes
S	Excel sparklines	Yes	Sparklines	Charts	No	No
V	VLOOKUP in Excel	No	VLOOKUP example and spot the error test!	VLOOKUP	Yes	No
V	VLOOKUP with CONCATENATE	Yes	VLOOKUP with CONCATENTATE	VLOOKUP	Yes	No
W	Manage Excel worksheets	Yes	Manage Excel worksheets	Worksheet	No	No