Things to Know about SharePoint 2013 Quick Edit – Part 1

You may often have to edit properties or metadata for multiple items or documents after uploading. Editing items separately can be frustrating tasks. Wouldn’t it be nice if you could edit properties in one shot? In SharePoint 2010, you can perform bulk operations in Datasheet View. In essence, it allows you to bulk edit metadata items with “Excel-like” features. But there are three limitations:

  • Does not support Managed Metadata column.
  • Works with Internet Explorer only.
  • Requires Microsoft ActiveX Plugin.

Luckily, these limitations have been overcome with SharePoint 2013 Datasheet View.

The Concept of Quick Edit

The Datasheet View now has a new name – Quick Edit or Quick Edit view. According to Microsoft in their article Create, change, or delete a view of a list or library, “This view (Datasheet View) displays list and library items in a grid, similar to a spreadsheet. This view, also known as Quick Edit, can be helpful if you have to edit many items in a list or library at the same time.”image1

Notice that the term Inline Editing is sometimes used to refer to Quick Edit. Microsoft refers to it as edit inline, which is one editing option mentioned in articles like Add, edit, or delete list items. But Inline Editing is something different in SharePoint 2010, where it displays a form in the view that allows a user to edit the current row in the current view.


Major Improvements with Quick Edit

There are six major improvements including new features for Datasheet View:

  • Improved UI with a nicer spreadsheet format
  • Support for Managed Metadata column
  • Removal of ActiveX dependency (Now it uses the html/JavaScript technology.)
  • Support in cross-browser (Works with all browsers now.)
  • Supports Quick Edit in filtered view (In SharePoint 2010 Datasheet view, the filter you preset will be missing and you need to reset the filter.)
  • Supports Quick Edit within a Document Set (In SharePoint 2010, when you open a Document Set, the Datasheet View on the ribbon is disabled. To open a Document set in its own Datasheet view, you have to open Datasheet View for all documents first, locate the Document Set and then click it.)

How to Enable/Disable Quick Edit

To enable/disable Quick Edit, you need to navigate to List Settings > Advanced Settings.


Two Ways to Enter the Quick Edit Mode

There are two ways to enter the Quick Edit mode. One is using the Quick Edit command on the ribbon, and the other is using the shortcut edit at the top of the list.


In the document library, however, you can only use the command on the ribbon to open the library in the Quick Edit mode.


What You Can Do in Quick Edit Mode

The Quick Edit view allows you to change, add, delete and copy and paste the values of most fields including Text, Choice, Date, Number, Lookup, and Managed Metadata, although not all column features work nicely in Datasheet view. You can:

  • Add and rename columns directly from the spreadsheet (New feature)
  • Sort and filter data
  • Open the edit form if some data types are not supportable for edit (Item edit menu still works.)
  • Copy/move specific items or field values using hot keys (such as Ctrl + c, Ctrl + v, Ctrl + x)
  • Add rows to create new items and delete rows to delete items
  • Create list items by copying data from Microsoft Excel or other spreadsheet applications
  • Use the arrow keys to move around in the view
  • Quickly insert values by using Auto Fill Handle

To learn how to add several items at a time in Quick Edit mode by coping and pasting from a spreadsheet, see Video: Add items to a list.

To learn how to edit or delete items in a list quickly in Quick Edit mode, see Video: Edit or delete items in a list.

Not everything in Quick Edit works perfectly as there are still several limitations as well as degrades. In my next post, I will look at the main complaints found in Quick Edit and recommend some third party bulk editing tools that can remedy some of the issues.

52 Responses

  1. Mark Kamoski
    Mark Kamoski at |

    Great article. Please help. I can set the column order for some of the columns in my custom Content Type (document set) but some of the columns will not display in the order that I specify when creating a new item. Is there a trick to this? Thanks. — Mark Kamoski

  2. S Clark
    S Clark at |

    We migrated from Enterprise 2010 to Cloud 2013. I have Full Control to a list, but when I set Quick Edit to No, it hides ALL records from me. (Shows branding, navigation, and pagination, but no items.)

    ANY clues?

  3. Hazel
    Hazel at |

    Where is your next article that you refer to in this one please? Quick edit is turning out to be slow edit mfor me!

  4. Leona
    Leona at |

    Really Great list and I find useful information about how WordPress helps to build the big brands on the internet. Before reading this article I’m not aware of using WordPress CMS for big enterprises. But now I will recommend to my big enterprise clients.

  5. Cordell
    Cordell at |

    Really Great list and I find useful information about how WordPress helps to build the big brands on the internet. Before reading this article I’m not aware of using WordPress CMS for big enterprises. But now I will recommend to my big enterprise clients.

  6. Fendi
    Fendi at |

    I think that you hit the nail on the head. There is no such thing as a get rich scheme or free lunch.If you want to build a solid online business, it would take hard work, dedication and lots of time.At the end of the day, it will be all worth, if its financial freedom you after. I look forward to checking out your site and learning more.RegardsRoopesh

  7. Stan
    Stan at |

    Hello Daniel,Each vendor has their own requirements for the personnel they would like to hire. When you visit their booth, they will inform you about the requisite qualifications for the various roles they have open. We also suggest that all visitors to the Fair walk with a CV highlighting their experience and education to leave with the hiring managers.

  8. Choree
    Choree at |

    The Totals option doesn’t seem to work in Datasheet mode for a list in SP2013. Has SharePoint deprecated this feature?

  9. Alexander Cope-Norris
    Alexander Cope-Norris at |

    Does anyone know how I can set onchange events for either specific fields on the “quick edit” view or for any changes to the row as a whole? I am aware of calculated columns, but want to use a row to calculate transaction total and display to the user before the record is committed / saved. Thanks :)

  10. Cornell Armbrester
    Cornell Armbrester at |

    Right here is the perfect webpage for anybody who really wants to find out about this topic. You know a whole lot its almost hard to argue with you (not that I personally will need laugh out loud). You certainly put a new spin on a topic which has been written about for years. Great stuff, just great!

  11. Sree
    Sree at |

    Great Article. Thanks for the same.

    A small query in SharePoint Quick Edit. Is there any way in Quick Edit to populate a column value based on a drop down change (another lookup column in the list)?

    VIJAY KUMAR at |

    HI SIR,

  13. Brittney
    Brittney at |

    My Datasheet view opens in “edit” mode right away. How can I get it to open in a “view” mode and use Quick Edit when I need to make changes?

  14. Chethan
    Chethan at |

    I Have created 2 views one as Default view and another view based on product and i have selected items which needs to be displayed in product view as only few items needs to be filled here, however when i try and fill form by selecting new, i am getting all others fields which i do not want to be basically i am all items as is in default view i am not getting specific filed which i need to fill when i select New and fill details in form.

    Can someone help?


  15. Science Fanatic
    Science Fanatic at |

    If you can’t explain what you’re doing and why you’re doing it to any intelligent layman, that really means that you don’t understand it yourself. Allan Bromley, former President of the American Physical Society

  16. at |

    Hahahaha selten so gelacht!

  17. BestJeana
    BestJeana at |

    I have noticed you don’t monetize your website, don’t waste your traffic, you
    can earn extra bucks every month because you’ve got high quality content.
    If you want to know how to make extra $$$, search for: Ercannou’s essential adsense alternative

  18. Ellen Preston
    Ellen Preston at |

    I am having a similar problem with the web version. I want to do a bulk load into Quick Edit, but the columns are not displaying in the custom order that I set up. They are defaulted to the order that a different admin created them in, which would have a lot of extra work to reformat my data file. How can I force the edit feature to the right column order?

  19. Health and Fitness
    Health and Fitness at |

    I gotta bookmark this site it seems very helpful invaluable

  20. Web Design Methods & Templates
    Web Design Methods & Templates at |

    whoah this weblog is fantastic i love reading your posts. Stay up the good paintings! You realize, a lot of people are searching around for this information, you could aid them greatly.

  21. venkat
    venkat at |

    How display all items in Quick Edit if my list is having >5K items?

  22. Southern Home Improvement
    Southern Home Improvement at |

    Definitely, what a great blog and enlightening posts, I definitely will bookmark your website.All the Best!

  23. Litigation
    Litigation at |

    As I web site possessor I believe the content matter here is rattling excellent , appreciate it for your efforts. You should keep it up forever! Good Luck.

  24. เปลี่ยนบัตรเครดิตเป็นเงินสด

    Hi there superb blog! Does running a blog similar to this take a large amount of work?
    I’ve absolutely no knowledge of computer programming however I
    was hoping to start my own blog soon. Anyways, if you have any ideas or techniques for new blog owners please share.
    I know this is off subject nevertheless I just wanted to ask.

  25. best solution for biofinity toric
    best solution for biofinity toric at |

    So i have a lot of questions lol.. I hope you don’t mind..
    But about the peroxide solution, i was wondering since
    you mentioned it is for all soft lenses, i also can use the peroxide
    solution on colored contact lenses without fading the color of the contacts
    lenses right? Sorry for sounding stupid i just want to know :), so
    it is possible to use the peroxide solution everyday to
    soak the contact lenses (for at least 4hours or more) but if i
    am in a hurry and can’t use the peroxide to soak my lenses in for like 1 day i can use the normal
    contact lens solution to rub them before putting it in my eyes?
    (Not that the peroxide lens will have a chemical
    reaction with the normal contact solution)??
    And my last question is do you dye your own hair
    :)??? Sorry for so many questions. But thank you for your help!

  26. photography lighting
    photography lighting at |

    Good site! I truly love how it is simple on my eyes and the data are well written. I’m wondering how I could be notified whenever a new post has been made. I’ve subscribed to your RSS which must do the trick! Have a great day!

  27. us home improvement
    us home improvement at |

    My husband and i felt now fulfilled that Ervin managed to do his investigations because of the ideas he came across through the web site. It’s not at all simplistic to simply possibly be giving freely steps which a number of people could have been making money from. And we all do know we’ve got the website owner to appreciate for that. The most important explanations you made, the simple site navigation, the relationships you help to engender – it’s most powerful, and it is leading our son in addition to the family understand that article is thrilling, which is very fundamental. Thank you for the whole lot!

  28. at |

    A fact that a lot of people must comprehend is if you cannot dedicate
    lots of time weekly and daily to analyze the Forex market which could literally take years to adequately learn and
    understand then locating a trading program and funds manager certainly are a must.
    If there’s room to create significant savings
    for that homeowner, it may pay to cause them to at least consider it.
    Pluses represent a positive advantage for the specific niche of client.


    Thank you for the good writeup. It in reality was once a entertainment account it.

    Glance complex to far introduced agreeable from you!
    By the way, how could we keep up a correspondence?

  30. at |

    I love reading an article that can make people think.

    Also, many thanks for allowing me to comment!

  31. at |

    Hey very nice blog!! Guy .. Excellent ..
    Superb .. I will bookmark your website and take the feeds additionally?
    I’m happy to find so many useful info right here in the put up, we need develop
    extra strategies in this regard, thank you for sharing.
    . . . . .

  32. at |

    I am actually grateful to the holder of this site who has shared this impressive post at at
    this place.


    Hello to every single one, it’s in fact a nice for me to go to see this site,
    it includes precious Information.


    What i don’t understood is in truth how you’re not
    really much more neatly-appreciated than you may be now.
    You’re so intelligent. You know thus significantly in terms of this
    matter, produced me individually consider it from a lot of numerous angles.
    Its like men and women are not involved unless it’s something to do with Lady gaga!
    Your own stuffs outstanding. Always deal with it up!


    We absolutely love your blog and find the majority of your post’s to be
    exactly I’m looking for. can you offer guest writers to write content to suit your needs?
    I wouldn’t mind publishing a post or elaborating on most of the subjects you write
    concerning here. Again, awesome web site!


    There is certainly a great deal to know about this topic.
    I like all of the points you have made.


    I visit each day a few web sites and websites to read articles or
    reviews, however this weblog gives feature based posts.

  38. 강원 랜드 앵벌이
    강원 랜드 앵벌이 at |

    This post will assist the internet people for creating new
    blog or even a weblog from start to end.

  39. 슬롯머신 알고리즘
    슬롯머신 알고리즘 at |

    There is certainly a great deal to know about this issue.

    I like all the points you’ve made.

  40. 마카오 바카라 후기
    마카오 바카라 후기 at |

    Hurrah! Finally I got a web site from where I can really take useful information regarding my study and knowledge.

  41. 홀덤 룰
    홀덤 룰 at |

    Amazing! Its genuinely remarkable piece of writing, I have
    got much clear idea regarding from this post.

  42. 룰렛 필승법
    룰렛 필승법 at |

    This paragraph is really a pleasant one it helps new web people, who are wishing in favor of blogging.

  43. cod 카지노
    cod 카지노 at |

    Hi there, for all time i used to check blog posts here early in the daylight, since i
    like to find out more and more.

  44. 바카라 가입머니
    바카라 가입머니 at |

    Thanks very interesting blog!

  45. 텍사스 홀덤 포커
    텍사스 홀덤 포커 at |

    Hi, I desire to subscribe for this website to get newest updates, therefore where can i do it please help.

  46. healthy meals
    healthy meals at |

    First i wantt to say great post! here iss a
    excerpt from mmy recent article tht i think you would like:
    “Good health is of prime significance to everyone. We need to be healthy and balanced, loaded with bountiful energy, audio sleep, and also fit and also disease complimentary body, which will provide us a sense of on the whole well being. In order to be healthy and fit we require to exercise healthy living styles with appropriate food behaviors and workout. We can not be healthy and balanced if we are lazy as well as sluggish. We require to strive both physically and emotionally to be fit and healthy. Besides workout, we additionally require to consume healthy foodstuffs staying clear of fast food, which make us sluggish and also boring. If you more than weight and also overweight you will experience health problems. So you require to keep an optimal body weight to be healthy and balanced.” if
    you wanbt to read more follow the link =]

  47. 홀덤 포커
    홀덤 포커 at |

    There is definately a great deal to know about this issue.
    I really like all of the points you made.

  48. 홀덤 전략
    홀덤 전략 at |

    Hi there! This is my first comment here so I just wanted to give
    a quick shout out and say I genuinely enjoy reading through your blog posts.
    Can you suggest any other blogs/websites/forums that deal with the same subjects?
    Thank you!

  49. 싱가포르 카지노 후기
    싱가포르 카지노 후기 at |

    Excellent items from you, man. I have be aware your stuff previous to and you are
    just extremely fantastic. I actually like what you have
    obtained right here, certainly like what you
    are saying and the best way during which you are saying it.
    You’re making it entertaining and you continue to take care of to stay
    it wise. I can’t wait to learn much more from you.
    That is actually a wonderful site.

  50. sex
    sex at |

    I am genuinely glad to read this webpage posts which consists of lots
    of helpful data, thanks for providing these information.

  51. 배터리게임주소
    배터리게임주소 at |

    I’ve learn some just right stuff here. Certainly worth bookmarking for revisiting.
    I surprise how so much effort you set to create this type of great informative web site.

  52. 캐나다 카지노
    캐나다 카지노 at |

    wonderful points altogether, you simply received a emblem new reader.

    What may you suggest in regards to your put up that you made some days in the past?
    Any sure?

Leave a Reply