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. Table of Contents:What is the user information list?How are users added to the list?How to Access the Hidden User Information ListMethod 1: Direct URLMethod 2: Site settingsUser Information List in Different SharePoint Versions 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 […]

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. Table of Contents:What’s in the list settings?Normal Way of Accessing the List SettingsWhat if you can’t access the toolbar?Accessing List Settings Using the List GUIDDon’t Panic Right Away 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.

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. Table of Contents:From the SharePoint List View (Standard Method)Automatic Export Process with Power AutomateHow about exporting large SharePoint lists?Differences Between Exporting to Excel and CSVExporting Data to Excel 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,

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. Table of Contents:What does exporting a library mean?Method 1: Export to ExcelMethod 2: Excel’s Data Tab for Metadata ExportPractical Use Cases 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

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. Table of Contents:Prepare the WorkbookHow to Publish the WorkbookMethod 1: Save directly to SharePointMethod 2: Uploading via SharePoint LibraryWhy Publish the  Workbook 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

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. Table of Contents:What are SharePoint lists?What methods can you use to create lists?Step-by-Step Guide to Creating a ListStep 1: New listStep 2: Select the methodStep 3: Name your list and add a descriptionCustomizing the List1. Adding and modifying columns2. Conditional formattingHow to Add Data to Your List1. Manually adding items2. Edit in grid view3. Using forms to add dataManaging List ViewsAdditional List Features1. Version control2. Approval settings3. Task

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. Table of Contents:What is the page viewer web part?The Challenge of Moving to Modern SharePointAlternative Web Parts to Recreate the Page Viewer Experience1. File Viewer Web Part2. Embed Web Part3. Link Web PartUsing SPFx Web Parts for More Flexibility 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

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. Table of Contents:Who can delete a list?Deleting a List in SharePoint OnlineWhat happens after deletion?How to Restore What You Deleted 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

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. 🙂 Table of Contents:What is coauthoring in SharePoint?How Coauthoring Works in SharePoint Pages and NewsPractical Use Cases for CoauthoringThe Future of Coauthoring in SharePoint 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