Log in
x
or
x
x
Register
x

or

Excel Tips: Edit > Fill Cell Content

AutoFill

How to autofill alpha characters in Excel?

How to autofill formula when inserting rows in Excel?

How to autofill same cell from different sheets to a sheet in Excel?

How to autofill VLOOKUP in Excel?

How to autofill weekdays exclude weekends in a list of Google sheet?

Fill Blank Cells

How to enter/display text or message if cells are blank in Excel?

How to fill a default value if cell is blank in Excel?

How to fill blank cells with 0 or other specific value in Excel?

How to fill blank cells with dash in Excel?

How to fill blank cells with linear values in Excel?

How to fill blank cells with value above in Excel?

How to find and replace all blank cells with certain number or text in Excel?

How to prevent number increment when using AutoFill by dragging in Excel?

How to repeat a cell value until new value is seen or reached in Excel?

Fill Cells by Criteria

How to display default value based on anther cell in Excel?

How to display different text than the value in same cell?

How to display January (month name) if cell starts with 1(numbers) in Excel?

Fill Cells across Sheets

How to enter same data in multiple worksheets at once in Excel?

How to enter the same data/formula in multiple cells at once in Excel?

How to reference or link value in unopened/closed Excel workbook file?

How to reference same cell from multiple worksheets in Excel?

Insert Date or Time

How to auto add/enter current date/time in a cell with double clicking in Excel?

How to auto fill date or only weekdays sequence in Excel?

How to auto populate date in cell when adjacent cell is updated in Excel?

How to automatically enter date when data entered in a column?

How to display system time or date in Excel?

How to easily enter dates without slashes in Excel?

How to fill date by week in Excel quickly and easily?

How to fill weekdays or weekends only in Excel?

How to insert current date and time in Excel cell/header/footer?

How to insert current date and time in Excel?

How to insert current date into textbox?

How to insert current day or month or year into cell/header/footer in Excel?

How to insert current timestamp when data in another cell changes in Excel?

How to insert date stamp into a cell if ticked a checkbox in Excel?

How to insert timestamp automatically when data is updated in another column in Google sheet?

How to insert timestamp into specific cell when macro is run in Excel?

How to insert timestamp with seconds in Excel?

How to quickly insert current date with specific date format in Excel?

How to quickly insert timestamp in Excel?

How to record date and time automatically when cell changes?

How to retrieve date and time from computer in Excel?

How to update or insert (current) date and time by a Command Button in Excel?

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 Sequence Number

How to automatically fill increment cells in Excel?

How to automatically generate invoice number in Excel?

How to fill column with series repeating pattern numbers in Excel?

How to fill down IP Address with increment in Excel?

How to fill down sequence numbers skip hidden rows in Excel?

How to fill sequence dates without weekends and holidays in Excel?

How to fill series in backward, descending or decreasing order in Excel?

How to fill series of numbers in a filtered list column in Excel?

How to fill series or formula to a specific row without dragging in Excel?

How to quickly insert unique sequence numbers 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?

Others

How to get current time zone and display in cell in Excel?

How to handle if cell contains a word then put a text in another cell?

How to insert same text in every other row in Excel?

How to make a particular cell mandatory enter before closing workbook?

How to quickly add accent mark characters in Excel?

How to synchronously input or select cells across multiple sheets?