Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I would like to know more about the features of Data sheet type lists.

  1. Can I use conditional modification to the data sheet rows, for example changing the color if a column value equal 'X' ?
  2. Can I use cascading effect in Data sheet view, for example based on Country would like to get city field...

  3. Can I change the default height of the data sheet view. If yes how?

  4. Can I view the datasheet in full screen ?
  5. Can I show long column headings in two lines?
  6. Can I permanently make the data sheet list to sort based on a particular column? Explanation - If I open the Data sheet type list - by default I would like to get the data sheet sorted on particular field?
share|improve this question
Next time I'd recommend breaking these down into separate questions; it's better to have one correct markable answer than several answers that deal with different parts. Luckily there's one brief answer for all these questions. :) –  Stuart Pegg Nov 15 '11 at 10:43
Will Take care of that in future Stuart :) –  Jithu Nov 15 '11 at 11:46

1 Answer 1

up vote 18 down vote accepted
  1. No
  2. No
  3. No
  4. No
  5. No
  6. No Yes, apparently:

Create a view and select a Sort By column, then set that view as the default view

The DataSheet view does not play ball. The problem is that the DataSheet view is a Microsoft Access generated data table, so there are none of the usual SharePoint hooks for interacting with it.

Here are some more related questions:

Q: Can I use JavaScript in the DataSheet view? Can I use JavaScript in 'Edit in DataSheet' mode?

A: No.

Q: Can I use a CEWP with a DataSheet view? Customising Data Sheet View

A: No.

Q: Can I add a Custom Control to a DataSheet View? How do I create custom control or action that works in a list's DataSheet view?

A: No.

Q: Can I have custom drop-down list values in the DataSheet View? Custom dropdown list field type in datasheet view (MOSS)

A: No.

Q: Can I-

A: No.

Edit: This post inspired me to write an article on some of the most common datasheet questions and answers: Pentalogic Blog: SharePoint Datasheet FAQ

share|improve this answer
SO non of my requirements can be done :) Very bad :) Thanks for spending time on this !! –  Jithu Nov 15 '11 at 11:47
+1 very clear ;-) –  Christophe Nov 19 '11 at 6:47
Question 6 Indeed I got it worked, created a view and selected required sort field and set that view as a default view. :) –  Jithu Nov 25 '11 at 10:40
@Jithu: :O Good call! I'll update my answer accordingly. It seems I got a bit carried away with my "No"s. :) –  Stuart Pegg Nov 25 '11 at 12:17
That's fine :) At least we got one yes :) –  Jithu Nov 25 '11 at 12:33

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.