Advanced List editing in SharePoint Online

Getting large amounts of data quickly into SharePoint lists can be cumbersome unless you use the Quick Edit mode of SharePoint. This tutorial will show you how to place a list into Quick Edit mode and then make changes just like you do using a spreadsheet by navigating the cells.

The tutorial will also show you how to copy and paste from an appropriately formatted spreadsheet in Excel on your desktop directly into a SharePoint list.

Using Quick Edit mode is the best way to work quickly with SharePoint lists and this tutorial will get you started.

Simple controls in SharePoint Online missing


Out of the box a SharePoint Online Document Library displays what is known as simple controls just below the Document Library name as highlighted above. These button are typically new, upload, sync, edit, manage and share.


However, you may see a situation where they are no longer displayed as shown above.

If you want them back, here’s what you need to do.

The reason they are no displaying is because the current view of the document library is not based on the default view style.


You’ll need the rights to change the Document Library, but if you can select the Library tab at the top of the page to reveal the Ribbon Menu.

On the Ribbon Menu locate the Manage Views section, on the left hand side. Then select Modify View as shown above.


Scroll down to the bottom of the page that is displayed and open the Style option.

As you can see above, the current style is set to Shaded.


Change this to Default and Save the changes.


You should once again see the simple controls as shown above. Unfortunately, you may also lose some of the functionality that you desired with the previous style. At this point in time you can have one or the other option but not both.

Introduction to Views in SharePoint Online

Views are a way in SharePoint that you can display information in a different layout. You can have as many views as you want for most items in SharePoint, making it a very flexible way to focus on what is important and avoid distraction.

This tutorial video will show you how to create new views as well as make them the default. You’ll see how to configure views to display different fields and automatically sort, filter and group information.

Views are available in most elements in SharePoint, from Document Libraries to Lists to Calendars and more. They are a key way to ensure that people focus on the right information.

Introduction to Email Alerts in SharePoint

Setting email alerts in SharePoint is a great way to receive notification when something changes. This video will show you how to configure and use such alerts for a Document Library on both the complete Library as well as an individual item.

Email notifications need to used in moderation as it is very easy to become quickly swamped but the frequency of alerts SharePoint send by default. This video will also show you how to customise this frequency to ensure you only get the information you need, when you need it.

Although the video only show the alert configuration process on a Document Library it is possible to configure most elements in SharePoint for email alerts in the same manner.

Used appropriately, email alerts in SharePoint provide an important way to be kept up to date about information you are collaborating on within a team.

Ask us Webinar’


If you want to know more about things like Office 365 and actually see them in use then make sure you register for our upcoming Ask Us Webinar at:

After some news and updates we’ll throw the floor open to anyone who wants to ask a question. We’ll then do are best to answer and if possible we’ll show you on screen.

The webinar will be recorded and made available to the Cloud Business Community on demand at the completion.

I’d love you to attend and give us you questions so that everyone on the call can learn.

I hope to see you at the event.

Need to Know podcast–Episode 71

An interesting episode with Ben Dampney from DigitIT as we discuss the challenges with recruiting and retaining good quality staff.

Ben has been gracious enough to share with us his recent experiences with locating his first employee. He takes us through the whole process and provides a lot of practical advice on how to get the best results. There is plenty of practical advice in this episode when it comes to recruitment that would benefit most businesses. I thank Ben for his willingness to share with us in this episode.

You can listen to the episode at:

or subscribe to this and all episodes in iTunes at:

The podcast is also available on Stitcher at:

Don’t forget to give the show a rating as well as send me any feedback or suggestions you may have for the show.

Episode resources


The Small Business technology podcast