Quickly Fill Multiple Cells with a Value or Formula

Use the keyboard shortcut Ctrl+Enter to quickly fill multiple cells with a value or formula. For example, you may want to enter a bunch of 0's (zeros) in a range of cells. Or, you want to apply the same formula to a range of cells without changing the cell formats. 1. Select a range of cells2. Enter the value or formula3. Instead of pressing Enter afterwards, press Ctrl+Enter to fill the entire