Apply Formula to an Entire Column in Excel (5 Easy Ways)




About this tutorial:

Video duration: 00:06:04
In this video, I will show you five easy methods to apply a formula to an entire column in Excel.

The following methods are covered in this video:

1. Using Fill Handle: This is one of the fastest ways and you can have the entire column filled with a quick double-click on the Fill Handle

2. Using Control + Enter: For this to work, you need to select the entire range and then enter the formula and use Control Enter instead of ‘Enter’

3. Using keyboard shortcut: This uses the Control + D keyboard shortcut to copy the content from the cell above. When you select a range, it applied the…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads