web analytics
How to Apply a Formula to an Entire Column in Excel? Options
codeling
Posted: Tuesday, May 16, 2017 1:39:17 PM

Rank:Advanced Member
Groups: Member
Joined: 12/11/2015
Posts: 916
Points: 3849

If I select a cell containing a formula, I know I can drag the little box in the right-hand corner downwards to apply the formula to more cells of the column. But if I need to do this for 300,000 rows, Is there a short-cut, similar to ctrl+space, that will apply a formula to the entire column, or to a selected part of the column?

Sponsor
Posted: Tuesday, May 16, 2017 1:39:17 PM
 
codeling
Posted: Tuesday, May 16, 2017 1:39:54 PM

Rank:Advanced Member
Groups: Member
Joined: 12/11/2015
Posts: 916
Points: 3849

Try double-clicking on the bottom right hand corner of the cell (ie on the box that you would otherwise drag).

SO5425210 example

Users browsing this topic
Guest

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.


© 2017 Digcode.com. All rights reserved.