Ryan Clark

Want to know more about this list? In this guide, let’s talk about the user information list in SharePoint, what it does, and how to access it. Let’s get started. What is the user information list? Basically, this user information list is a hidden list that stores basic details about users who interact with a SharePoint site. It contains the following information: This list is also automatically populated when users access the site (more on this later). Well the information it collects, it’s easy to see that it plays a key role in features like permissions, alerts, and tasks. 👉 […]

What if you can’t access the gear icon? In this guide, I’ll show you how you can get to the list settings page of any list in SharePoint Online. Let’s get started. What’s in the list settings? As you already know, the list settings provide important tools for managing and customizing the lists. Here are the main options you will find: These will help you adjust your lists to meet specific needs. In fact, much of the magic that happens in SharePoint can only be accessed here. 🙂 Normal Way of Accessing the List Settings I write “normal” since this

Want to view your data in Excel instead? In this guide, I will walk you through different methods of exporting data from a SharePoint list to Excel. Let’s get started. From the SharePoint List View (Standard Method) What’s nice here is that the process is simple and quick. Simply access the list in the SharePoint site where it’s located, and click the export option from the command bar. Once you click export, choose from the options available: After choosing an option, the file download begins right away. If you’ve used the Excel option, it will download a .iqy file, which

Can you export a library to Excel? In this guide, I will show you how you can easily export a document library from SharePoint Online to Excel. Let’s get started. What does exporting a library mean? Basically, it allows you to take the data stored in the library and view it in an Excel workbook. Here’s what’s included in the export data: It’s important to note that exporting a library doesn’t include document contents or file versions. In a way, the export gives a snapshot of the data in the library, which can be updated manually in Excel if needed.

Want to publish directly to SharePoint? In this guide, I will give you a walkthrough on publishing an entire workbook straight to a SharePoint site. Let’s get started. Prepare the Workbook Before you can publish your workbook, you need to prepare it first. 🙂 Here’s what you need to do: Even if you limit what people can see in the browser, the entire Excel file is still saved on the SharePoint server. For this reason, always check that there are no sensitive or unnecessary data you don’t want others to see. How to Publish the Workbook Fortunately, publishing a workbook

Not sure how to create a list? In this guide, I will walk you through creating a list in SharePoint Online and how to add data to your list. Let’s get started. What are SharePoint lists? Lists are one of the core features in SharePoint Online, along with document libraries (they’re practically lists. Basically, you can use these lists to organize and manage data in a structured format for various purposes. Here’s what you can do with lists: You would definitely like lists since they’re highly flexible. You can use them in different scenarios — from simple to-do lists to complex project

Can’t find this web part? In this guide, let’s talk about the alternatives to the SharePoint page viewer web part in the modern experience. Let’s get started. What is the page viewer web part? As its name suggests, this web part displays web pages, documents, or folders within a SharePoint page. Basically, you can use it to embed content from external sources without having to leave SharePoint. This was widely used in the classic experience as it’s something like a “catch-all” embed web part. It’s no longer available in the modern experience as there are specialized embedding web parts available.

Want to remove unused or outdated lists? In this guide, I will walk you through deleting a list in modern SharePoint and what happens after that. Let’s get started. Who can delete a list? It’s good that not everyone can delete a list. 😅 Here are the types of users who can delete a list: Unfortunately, if you’re on this list, you won’t be able to delete that list that you’re thinking of. You can check with your SharePoint administrator and ask them to have the necessary permissions. 🙂 If you don’t have the right access, the delete option won’t

You might have already seen this coming. Coauthoring in SharePoint is now possible even with news and pages, not simply with office documents. Let’s talk about this new feature. 🙂 What is coauthoring in SharePoint? From the name, it allows multiple people to work on the same page or news post at the same time. It’s similar to how you can collaborate in Word or PowerPoint but within SharePoint’s environment. 🙂 Here’s what you can expect: The magic here is that teams will be able to reduce the need to take turns to edit the same page. Even if users