enter data in man cells simultaneously in Excel

Q109. In Excel, how can I enter information in multiple cells simultaneously?

For example, in the Sheet to capture daily sales data, since 01st October is a Sunday (Holiday), I want to enter 0 across all columns.

excel enter data in man cells simultaneously

To do it in Excel, here is the answer:

a) Select all cells that need to have the same value (the selection could be non-contiguous as well). In the formula bar, enter desired value (0 in this case) . Click "Ctrl+enter"

excel excel enter data in man cells simultaneously

b) All the selected cells are updated with value entered in Formula Bar as shown below.

excel excel excel enter data in man cells simultaneously


You can find similar Excel Questions and Answer hereunder

1) How can i filter multiple columns simultaneously in Excel

2) Applying a countif formula only to visible cells in a filtered list in Excel

3) How can I use SUMPRODUCT to summarize my raw data?

4) I have a complex WorkSheet with lot of fields and data - How can I quickly find the cells that have formulas?

5) I have read that Merging cells should be avoided if possible. In Excel, how can I then make my Title appear in the center of my Data Table?

6) I have data arranged in rows of information. Is there any way I can enter new data through a form instead of entering it directly in SpreadSheet?

7) How can I plot 2 series on the same chart with different scales / measurement unit for Values (Ex: Pareto chart)?

8) I have 2 sets of lists from 2 different reports - how can I select the cells with differences?

9) Is there a way to easily shade alternate rows in a data range for improving readability?

10) I have to retrieve data from a specific column in a Table. In Excel, how can I do that?

11) How can I identify all cells with Data Validation in my WorkSheet?

12) How can I quickly remove all blank cells in a data range?

13) How can I enter a text in a cell with subscript and superscript?

14) How can I fill a series of data automatically?

15) How do I add a symbol like Triangle / Inverted Triangle for indicating trends in a cell using VBA?