Log in
x
or
x
x
Register
x

or

Excel Tips: Insert > List

Custom List

How to create alphabetical series list in Excel?

How to create and fill new custom lists quickly in Excel?

How to create bulleted list in a cell or multiple cells in Excel?

List of All Combinations or Permutations

How to generate a list of all possible 4 digits combinations in Excel?

How to generate or list all possible permutations in Excel?

How to generate unique combinations in Excel?

How to list / generate all possible combinations in Excel?

List of Dates or Weekdays

How to create a list of weekdays/business days in Excel?

How to list all dates between two dates in Excel?

How to list all days as date in a specified month in Excel?

How to list all Mondays / Fridays in a month in Excel?

List of File or Folders

How to import multiple file names into cells in Excel?

How to list all file names from a folder and sub-folders into a worksheet?

How to list all filenames in a folder and create hyperlinks for them in Excel?

How to list all files in folder and subfolders into a worksheet?

How to list all folders and subfolders in Excel?

How to list all open workbooks and easily shift between workbooks in Excel?

How to quickly list the picture names/file names of a folder to Excel cells?

List of Sheet Names

How to create a dynamic list of worksheet names in Excel?

How to create a table of contents for all spreadsheets tab name with hyperlinks in Excel?

How to create and list all worksheet names from a workbook?

How to get list of sheets names in Google sheets?

How to list all visible or hidden sheets from workbook?

How to list all worksheets and switch sheet with shortcuts in Excel?

How to populate a Userform ComboBox with all sheet names in Excel?

List of Unique Values

How to compare two columns and list differences in Excel?

How to create a list of unique values from multiple worksheets in Excel?

How to create a unique alphabetically sorted list from a column in Excel?

How to populate combo box with unique values only in Excel?

How to quickly create unique list (remove duplicates) from a given column in Excel?

List Values by Criteria

How to list all matched instances of a value in Excel?

How to list all numbers between two or more numbers in Excel?

Others

How to create a dynamic list without blank in Excel?

How to create a list from same cells across multiple sheets in Excel?

How to create scrollable list / area in worksheet?

How to generate all prime numbers between two given numbers in Excel?

How to generate lottery numbers in excel?

How to list all comments to a new worksheet or workbook in Excel?

How to list all formulas in Excel?

How to list all opening (currently running) applications in Excel?

How to list all pivot tables from a workbook?

How to list all table names in Excel?

How to list column header names in Excel?

How to list named ranges in Excel?

How to quickly create simple to do list in Excel?

How to quickly list all hyperlinks in Excel?