enter data in man cells simultaneously in Excel

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 enter data in man cells simultaneously

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

excel enter data in man cells simultaneously


You can find similar Excel Questions and Answer hereunder

1) How to use data table function in Excel. It helps you go through various scenario when seeking a goal

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

3) How can I filter a table to get all records that have less than a particular value in a specific column?

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

5) How to import xml data into Excel using VBA

6) How can I filter and copy only filtered data using VBA?

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

8) How can I enter an Engineering or Mathematical equation like Binomial Theorem Equation in Excel?

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

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