How do I put the same data in multiple cells in Excel?

To enter the same data into multiple cells in Excel simultaneously, select the cells and use the Ctrl+Enter shortcut.

Here's a breakdown of the process:

1. Select the Cells: Highlight all the cells where you want to input the same data. These cells can be adjacent or non-adjacent. To select non-adjacent cells, hold down the Ctrl key while clicking on each cell individually.

2. Type the Data: With the cells selected, ensure that one cell is the active cell (it will appear with a more pronounced border). Type the data you want to appear in all the selected cells into this active cell.

3. Press Ctrl+Enter: Instead of just pressing Enter, press and hold the Ctrl key, then press Enter. This command will fill all the selected cells with the data you typed.

Example:

Let's say you want to enter "Pending" in cells A1, B5, and C10.

1. Click on A1, then hold down Ctrl and click on B5, and then on C10.
2. Type "Pending" (it will appear in the active cell, likely A1).
3. Press Ctrl+Enter.

Now, cells A1, B5, and C10 will all contain the word "Pending".

This method is a quick and efficient way to populate multiple cells with identical information in Excel.