Using the drag down feature to quickly copy information in SharePoint Online

Office 365 / SharePoint Blog

Some of you may have seen this feature in Excel, where you have the ability to quickly fill rows with same information. I am finding on my personal SharePoint task list that waiting for SharePoint to complete the “Assigned to” field is somewhat cumbersomeSharePoint: Data sheet drag down - cross hairs, since I’m the only one who is ever assigned tasks on my own SharePoint task list. Luckily, SharePoint Online has that same feature in DATASHEET view. You see this datasheet view when you choose Quick Edit if it’s available for your list.

Do you see that little blue square at the bottom of this cell?

SharePoint: Data sheet drag down - filledWhen you place your mouse over it, it turns into a cross hair, and you can drag it down as many cells as you need.

It will then copy and paste the information from the first cell into the cells below, as shown.


Leave a Reply

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

You are commenting using your 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