locked
SharePoint 2013 DataSheet View Column width RRS feed

  • Question

  • In SharePoint 2010 our users were able to adjust the column width when viewing a List or Library in DataSheet view.   This feature seems to be absent in SharePoint 2013's datasheet view.  The column widths are static, and in many cases, frustratingly narrow for the fields they serve.  Does anyone know of an out of the box solution that would allow column widths to be adjusted by the user?  If not is there a 3rd party solution that includes this functionality?
    Saturday, February 9, 2013 12:09 AM

Answers

  • You're absolutely right, there are too many columns in the datasheet.  Unfortunately, this is a business requirement set by users who are accustomed to working with Excel.  They like all their data available and editable in front of them.

    It's evident that we've lost a few "Excel-like" features in SP2013's datasheet view.  We've decided to go with larger fixed column widths  in custom styles.  There is always the option to export the list/library to Excel and work with a linked workbook.

    Nevertheless, thank you for your input.

    • Marked as answer by jpv-1341 Friday, March 1, 2013 7:38 PM
    Friday, March 1, 2013 7:38 PM

All replies

  • Can you try to navigate to Library -> Modify View and in the Edit View page set the Style to Basic Table? The view should get set to how it was in SP 2010. Let me know if this is what you needed and if I got the issue correctly.

    Monday, February 11, 2013 9:05 AM
  • Thank you for your response.  I tried your proposed solution, but it seems Style options are only available in Standard Views.  I'm working with SP2013's Datasheet View which doesn't have Style options.  The current concern I have with SP2013's Datasheet View versus SP2010's Datasheet View is the column widths are not adjustable by the user as they were in the past.  The client has asked us to make this particular library view as "Excel-like" as possible.  Some of the columns are so narrow that they're displaying 1-2 words before wrapping down.  I'm sure our client will complain if they can't use the interface to widen the columns and improve readability.
    Monday, February 11, 2013 6:40 PM
  • Well, are there too many columns in the datasheet view? There are two things that may help you:

    1. I tried to create a custom datasheet view on a folder and the columns rendered fine for me. I however was using the default column selection (Type, Name, Modified By, Modified, Created By, Created). The names are pretty large and appear correctly. Maybe reducing the number of columns would help you.

    2. Else, create a new view. Create View -> Custom View in Sharepoint Designer and then select custom columns with Type 'Multiple Lines of Text'. This however, wouldn't allow the users to select the column widths but will certainly help in showing up the entire title/name as they appear on the columns.

    This is all that comes to my mind at present.

    Tuesday, February 12, 2013 6:02 AM
  • You're absolutely right, there are too many columns in the datasheet.  Unfortunately, this is a business requirement set by users who are accustomed to working with Excel.  They like all their data available and editable in front of them.

    It's evident that we've lost a few "Excel-like" features in SP2013's datasheet view.  We've decided to go with larger fixed column widths  in custom styles.  There is always the option to export the list/library to Excel and work with a linked workbook.

    Nevertheless, thank you for your input.

    • Marked as answer by jpv-1341 Friday, March 1, 2013 7:38 PM
    Friday, March 1, 2013 7:38 PM
  • I am struggling with the same issue. It looks like the datasheet view is now raw html/JavaScript so I am going to try and overlay the resized from Jquery UI to see if I can get back this feature. I will post again if it works. Otherwise, I would love to know if anyone else figures this out.
    Saturday, March 2, 2013 8:34 AM
  • I am dissapointed. It seems to be a lot of functionallity that disappeared in Datasheet view when switching from Sharepoint 2010 online to 2013 online. In addition to set column width, I also miss double-click to add and access attached files, Excel style copy cells, easy scroling, etc. Or have I missed something? Is it possible to revert back to 2010 datasheet style?
    Thursday, April 25, 2013 12:44 PM
  • I am really disappointed also. We had several linked web parts in datasheet view that no longer work. I don't get it - we have been useing this extensively in SharePoint since 2007. Our users would constantly Copy/Paste between Excel and SharePoint datasheet view lists on a daily basis. Now that functionality is gone. Any suggestions for a work around?

    John Fletcher

    Wednesday, May 8, 2013 3:50 PM
  • Count me as also disappointed.  The 2010 Datasheet view was very useful...What they are calling "datasheet" in 2013 is simple NOT. 

    GIVE US A THIRD OPTION- 2010 Style Datasheet.

    Friday, June 21, 2013 4:13 PM
  • One more disappointed user
    Wednesday, August 14, 2013 12:59 PM
  • what if we have absolutely different business requirement? Was it too complex to save existing functionality?! I wish to have ability to create columns in datasheet view as it was – easy!
    Wednesday, October 23, 2013 11:40 AM
  • Add another disappointed SP developer. I guess I'm going nto have to write an app to get that functionality back.

    Bad show, guys, an upgrade is supposed to ADD functionality, not remove it.


    G. Steele at Sedgwick

    Wednesday, October 29, 2014 5:27 PM
  • Has there been any more progress on custom column widths? This is the number 1 complaint of our users. Some of them have taken to dumping files on network shares instead of in the document library (which we want to avoid). We have been using a Bamboo webpart that allows columns to be resized, but it doesn't quite tick all of the boxes of Quick Edit view. Certainly the bulk metadata editing is not as easy.
    Wednesday, March 18, 2015 1:32 AM
  • Check out new SharePoint add-in from Sharepointalist - List Booster - it enables column resize in regular view and quick edit view - http://www.spbooster.com


    Paul Shkurikhin http://blog.sharepointalist.com


    Tuesday, June 9, 2015 12:35 AM
  • Our organization just upgraded to SharePoint 2013 about 2 months ago, and the loss of the datasheet functionality is huge!  What were they thinking?

    I thought I was missing something obvious, but the display behavior of the datasheet is unacceptable and makes it almost unusable.  Since there's no longer a WYSIWYG environment in SharePoint Designer, you seem to require higher developer skills just to change column properties?  Unbelievable.

    This is another one of the features in SharePoint that should be much closer to the "surface".  Along with a Today or Date() function that could be used in calculations :)

    Tuesday, March 22, 2016 12:51 PM
  • I totally agree with this comment.

    How can I tell my users that they can't anymore:

    • Drag and drop columns to reorder them
    • Adjust Datasheet View Column Width
    • Adjust Datasheet View Column Height
    • Select all items on a page using the quick select key Ctrl + A
    • ...

    Moreover the performance fo this quick edit view seems to be very poor : 100 to 150 items can be copied/paste at a time, which is ridiculous.

    What alternative solution does Microsoft propose ? Particularly in SP Online, as I could find some non-MS tools (not free, like Kwizcom) for SP 2013/2016 on prem, but nothing at all for SP Online.

    Wednesday, May 18, 2016 12:23 PM
  • This new Data Shiet view is terrible.  Why would you drop useful functionality from a product?  Bogus!

    Wednesday, June 15, 2016 8:42 PM
  • I know of a work around but would be interested in a solution. What I have had to do is lengthen the Title of the Column.  Appears column length is based on space required for title.
    Thursday, September 1, 2016 9:29 PM