Author: oneminuteofficemagic

Instantly Make the Settings Gear Icon Appear in SharePoint

One of my colleagues in the Microsoft 365 world posted this on his blog today, and it makes me so happy… When you are going to a SharePoint site, often the Settings Gear icon in the upper-right corner takes 5 to 10 seconds to load. That is a pain when you really just want to get to permissions or site contents. But with this little hack, you can get the gear to show up instantly with a single click. Here’s how that works…

Remove toggle for Calendar in Teams

As you might have noticed, Microsoft Teams has a new Calendar experience that you’ve been able to toggle on and off. The new experience is designed to more closely mirror your Calendar experience in Outlook. Microsoft announced this morning that they will be removing the toggle switch in September, and at that point everyone will be in the new experience. Here’s the Microsoft announcement wording:

Using a Data Entry Form in Microsoft Excel

Here’s a new one I just learned about today… When entering data into an Excel table, I was used to just adding data to the cell, tabbing to the next cell, and repeating until I was done. If the table required horizontal scrolling, it could get a bit cumbersome. But then I learned you can use the built-in Data Entry Form in Excel to enter that data. Here’s how that works…

Line breaks within a cell in Microsoft Excel

Not being an Excel guru (or maybe even a novice!), I have run into issues before where I have data in a cell and I want to have a line break within the cell to continue typing. However, when I hit Enter, it goes to the next cell. I finally learned how to keep that line break in the same cell, and I’ll share it with you now… and also help myself to reinforce that skill. 🙂 Here’s how it works…