Can’t find why you can’t sort that column? In this short guide, I will explain why you can’t sort that person column and suggest what you should do instead. Let’s get started. Table of Contents:Possible Reasons Why Columns Can’t Be SortedSolution: Disable “Multiple Selections”Step 1: Edit the columnStep 2: Turn off multiple selectionsStep 3: Check the columnWhat’s different with person columns? Possible Reasons Why Columns Can’t Be Sorted The truth is that some columns in SharePoint can’t be sorted because of their data type or settings. For example: Person or group columns are a little tricky as they’re basically references […]

Feeling annoyed with the constant alerts about a ‘newer version’? In this guide, I will show you a few ways to remove your Excel workbook from the updates in SharePoint Online. Let’s get started. Table of Contents:Removing Your Workbook1. Save a Local Copy2. Create a New Workbook + Copy Contents3. Create a Workbook Copy + RenameWhat happens after you remove your workbook? Removing Your Workbook If you think you’re the only one who gets annoyed with this “recommendation”: Well, you’re not alone. 🙂 Fortunately, it’s quite easy to remove your Excel workbook from the updates. 1. Save a Local Copy

Not seeing your column in the group by option? In this guide, I will explain the issue that you’re facing when trying to group by category column in SharePoint Online. Let’s get started. Table of Contents:Possible Reasons for Grouping Issues1. Incompatible column types2. Choice field settings3. Managed metadata columnsHow to Troubleshoot Grouping ProblemsWorkarounds for Unsupported Column Types Possible Reasons for Grouping Issues No need to scratch your head anymore as the reasons are already known: 1. Incompatible column types The most common culprit here is the column types as some of them don’t support grouping, which can cause issues. Here

Got some changes on who manages what? In this guide, I will walk you through changing the authorization for a list in SharePoint Online quite easily. Let’s get started. Table of Contents:Changing Permissions for a ListStep 1: Access the permissions pageStep 2: Stop inheriting permissionsStep 3: Specific what you want to doWhy manage the list permissions?Always Use the Least Privilege Principle Changing Permissions for a List Fortunately, changing the permissions in a list is straightforward. Step 1: Access the permissions page The first step is to navigate to the list you want to manage. When you’re there, click the gear

Want to separate your Excel file? In this guide, I will show you an easy way of separating your Excel workbook from SharePoint so it won’t receive updates. Let’s get started. Table of Contents:What happens after disconnecting a workbook?How to Separate Excel Workbook from SharePoint UpdatesStep 1: Open the Excel file using the desktop appStep 2: Check out the fileStep 3: Save a local copyPotential Issues and How to Avoid What happens after disconnecting a workbook? Since you’re thinking about separating your workbook, it’s important to know what happens after you do that. 😅 Here’s what would happen: Well, the

Can you link a word in a document to anywhere? In this guide, I will show you how to create a link from a word in SharePoint Online in few simple steps. Let’s get started! Table of Contents:What is a hyperlink?How to Create a LinkStep 1: Open the page in edit modeStep 2: Insert the linkStep 3: Add the URLCommon Issues and Troubleshooting What is a hyperlink? You must’ve heard about hyperlinks already. Basically, they’re clickable elements that can direct users to another webpage or document, even outside SharePoint. Some common ways they’re used in SharePoint include: But mostly when

Want to save your Google Sheets? In this guide, I will show you some methods you can use to save your Google Sheets file to Sharepoint. Let’s get started. Table of Contents:Does a straight method exist?Method 1: Download and  upload as ExcelMethod 2: Share link to Google SheetsMethod 3: Use third-party tools for bulk migration Does a straight method exist? Unfortunately, there isn’t a direct method out-of-the-box that will enable you to move Google Sheets to SharePoint. But some alternatives exist: While these work, there’s no fully seamless process for transferring a Google Sheets file to SharePoint Online in native

Want to link different words? In this guide, I will show you how to link two words on the same page in SharePoint Online quite easily. Let’s get started. Table of Contents:Link Two Words on the Same SharePoint PageStep 1: View the SharePoint pageStep 2: Select the source word/wordsStep 3: Create the anchorWhat are internal links in SharePoint? Link Two Words on the Same SharePoint Page Okay, I’ve got a bad news and a good news. The bad news is, although you can technically link two “regular” words on the same page, it won’t anchor or scroll through. The good

Got some guests whose access is expiring soon? In this guide, I will show you how to easily extend the SharePoint external user access for those nearing expiration. Let’s get started. Table of Contents:What is the SharePoint guest expiration policy?How Expiration Policies Work at the Tenant and Site LevelsHow to Extend External User Access in SharePointStep 1: Site permissionsStep 2: Extend buttonCommon Issues and How to Resolve Them What is the SharePoint guest expiration policy? The short of it is that this policy is designed to manage the access of external users who are invited to collaborate on content. Here’s