How do I create a formula for an entire column in excel?



How do I create a formula for an entire column in excel?..

Answer / Antesh Kumar Manjhi

To apply a formula to an entire column, type the formula in the first cell of the desired column and then click on the lower-right corner of that cell (the 'fill handle') and drag it down to copy the formula across all the cells in the column.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

How do I match data in two columns in excel?

1 Answers  


How do I add multiple tabs in excel?

1 Answers  


How do I duplicate a sheet?

1 Answers  


What is concatenate in excel?

1 Answers  


What is sheet tabs in excel?

1 Answers  


How do you merge cells using the keyboard?

1 Answers  


How do I show a value instead of formula in excel?

1 Answers  


How do I show only duplicates in excel?

1 Answers  


How do I cross reference two excel sheets?

1 Answers  


How do I find duplicates in multiple columns?

1 Answers  


How can you check whether the pivot table is modified or not?

1 Answers  


What is the main function of microsoft excel?

1 Answers  


Categories