Tips

Have you ever shared a link to a spreadsheet with many worksheets and wanted to let people open a specific worksheet by default when they access the link? This is a commom need, but Excel remembers the last worksheet you were on, and launch that worksheet directly when you opened the file the next time. For the convenience, you may have bulit a navigation worksheet that contains links to all the worksheets in your spreadsheet. This article will tech you how to make a link to the navigation worksheet specifically. ...

Everybody knows that, after promoting Windows 11 for many years, Microsoft is ending the support to Windows 10. Users will no longer receive the updates after October 14, 2025, unless they get Extended Security Updates (ESU). ESU was previously a paid only service, but now, Microsoft has provided another choice in free of charge to those who are still not ready for Windows 11 yet. Microsoft 365 users can benefit from this change. ...

You’ve likely had this experience: needing to download software from the internet, possibly for long-term use or perhaps just temporarily, but not being sure whether it’s safe. Even with antivirus software installed, there’s no guarantee that all risks will be intercepted. Features of Sandbox Those with virtual machine experience might say: “Why not just test it on a virtual machine? If there’s an issue, you can just restore from a snapshot.” While a virtual machine is indeed a solution, it is much more cumbersome compared to Windows Sandbox. Windows Sandbox offers the following advantages: ...

In the course of our daily office routines, we often encounter a common dilemma: how can we confirm whether we have an active Microsoft 365 subscription? Whether it is for accessing the latest features or ensuring seamless use of Office applications, this knowledge is paramount. Worry not, I will guide you step-by-step to verify whether or not you hold this subscription, ensuring that you arrive at an answer in the shortest time possible. ...

When we deal with Excel tables containing a lot of plain text, it is easy to get visually fatigued looking at a lot of black and white data. At this time, we can use a shortcut key to beautify the table in one second, making it easier to read. I recorded a short video to give you a visual experience of how it works. As you can see from the video, I did the following: ...