How to drag formula over thousand of empty rows with one click

If rows are empty, double click short cut on extend formula hand will not work. So what can you do? How can you resolve it?

The trick

Copy cells from left side column into the one that you want to update. There is likely that data exists in columns somewhere. Once data is there, you can use double click shortcut to extend the formula to all rows that you just copied.

Advertisements
This entry was posted in Tutorials/Tips and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s