Skip to main content

Excel Tips: Edit > Fill Cell Content

Insert Random Data

Generate random number by given certain mean and standard deviation in Excel

How to generate only random even or odd numbers in Excel?

How to generate random character strings in a range in Excel?

How to generate random date quickly in Excel?

How to generate random decimal/integer numbers in Excel?

How to generate random number without duplicates in Excel?

How to generate random positive and negative numbers in Excel?

How to generate random value based on assigned probability in Excel?

How to generate random value from a given list in Excel?

How to generate random weekday or weekend date in Excel?

How to generate random Yes or No in Excel?

How to insert random (integer) numbers between two numbers without repeats in Excel?

How to quickly generate random password in Excel?

How to quickly generate random time in Excel?

How to randomly fill values from a list of data in Excel?

Insert Workbook Information

Get and insert the created time and last modified time in cells

How to get and insert the last modified user name in Excel?

How to get current workbook name in Excel?

How to get the active workbook location/path in Excel?

How to get the current sheet number of a workbook?

How to get the next sheet name in Excel workbook?

How to insert current Excel file location in a cell of Excel?

How to insert file name or path into cell / header or footer in Excel?

How to insert filename in header/footer/cell without extension in Excel?

How to insert last modified date in Excel header or footer?

How to insert last saved timestamp into worksheet cell in Excel?

How to insert page number into cell / header / footer in Excel?

How to quickly insert file path into Excel?

How to quickly insert sheet names in cells in Excel?

How to quickly insert windows username in cell in Excel?

How to reference tab name in cell in Excel?

How to reference worksheet by index number instead of name in Excel?

How to return filename without extension to cell?

How to set cell value equal to tab name in Excel?