Recent Discussions
A button to transpose data into a destination table
Hi, I have a table filled with data that I need to be pasted into a final blank table but the destination table is larger than the original table. Also the data needs to be sorted by one column and the column order doesn't match. See image. This is a process that needs to be carried out by people with limited experience of excel or even computers, hence thinking that a button linked to a macro might be a solution, but open to any solutions! Thanks
Autocorrect "Replace text as you type" no longer working in comments
I'm a college English professor. I've been using MS Word's Reviewing features for years (decades?) to offer feedback on student essays. I mainly make bubble comments in the margins of the document (CMD-OPT-A or Insert > Comment). Until recently, my Autocorrect "Replace text as you type" feature was working in the comments (my fumbly fingers mistype things like "differnet" and I've even added some shortcuts like "dangmod" to "dangling modifier"). But as of maybe a few months ago, my comments no longer autocorrect. I haven't changed any settings, and the function works in the body text of the document. I have a 2023 Macbook Pro running Sequoia 15.7.1, and I'm using MS Word for Mac Version 16.101.3. Anybody have the solution for this? I've spent years training myself to use MS Word's Reviewing so I can be very efficient with my time (I know all the keyboard shortcuts, etc.), but if autocorrect no longer works, I'll probably just switch to Google Docs or something. Thanks for any help you can give.Automating Microsoft 365 with PowerShell Second Edition
The Office 365 for IT Pros team are thrilled to announce the availability of Automating Microsoft 365 with PowerShell (2nd edition). This completely revised 350-page book delivers the most comprehensive coverage of how to use Microsoft Graph APIs and the Microsoft Graph PowerShell SDK with Microsoft 365 workloads (Entra ID, Exchange Online, SharePoint Online, Teams, Planner, and more). Existing subscribers can download the second edition now free of charge. https://office365itpros.com/2025/06/30/automating-microsoft-365-with-powershell2/
Excel font rendering blurry when zoomed out (Windows 11, Microsoft 365)
Hello Community, I’m experiencing an issue with Excel (Microsoft 365) on my new Windows 11 ASUS touchscreen laptop. The text in Excel becomes noticeably blurry when zooming out, but looks fine when zoomed in. This problem does not occur in other applications (like browsers) and did not happen on my older Windows 10 laptop running the same version of Excel. What I’ve tried so far (with Microsoft Support): • Tested in Safe Mode → still blurry • Checked ClearType text and confirmed scaling at 100% • Verified “Optimize for best appearance” is already set • Installed Office updates and restarted device • Disabled all add-ins • Disabled hardware acceleration in Excel • Updated graphics drivers and adjusted GPU scheduling • Removed second monitor → no change • Compared display settings and Excel files between devices • Checked Excel Options for missing settings (e.g., Hardware Graphics Acceleration toggle not visible) • Remote session with support agent confirmed the issue persists Observations: • Only affects Excel (not other apps) • Text looks fine when zoomed in, but blurry when zoomed out • Blurriness persists even after updates, safe mode, and driver changes • Same Excel version works fine on Windows 10 • Touchscreen and scaling differences were considered but ruled out Has anyone else experienced this issue with Excel on Windows 11 (especially on ASUS touchscreen devices)? Is this a known rendering limitation, or are there any reliable workarounds/fixes to improve text clarity when zooming out? Thanks in advance for any insights! See the attached below for your reference: with blurry: without blurry issue:
Having a hard time keeping the data in one line with a pivot table
Hey folks, I am trying to get a pivot table where all the information I need is in one row, but no matter what I do each column is in a different row. Here's the data I need to make into one line for each column. Co Code Batch ID File # Batch Description Pay # Tax Frequency Temp Cost Number Temp Rate Reg Hours Overtime Hours PER Hours 3 Code PER Hours 3 Amount PTO Hours 3 Code PTO Hours 3 Amount FLH Hours 3 Code FLH Hours 3 Amount SF1 Hours 3 Code SF1 Hours 3 Amount PTA Hours 3 Code PTA Hours 3 Amount SF3 Hours 3 Code SF3 Hours 3 Amount HP4 KroHrs 534040 Kronos HR 1 6009-18067 8.2 HP4 KroHrs 534040 Kronos HR 1 6009-18067 8.15 HP4 KroHrs 534040 Kronos HR 1 6009-18067 3.33 HP4 KroHrs 534040 Kronos HR 1 6009-18067 10.03 HP4 KroHrs 534040 Kronos HR 1 6009-18067 5.7 HP4 KroHrs 534040 Kronos HR 1 6009-18067 SF3 2.4 HP4 KroHrs 534040 Kronos HR 1 6009-18067 8.17 HP4 KroHrs 534040 Kronos HR 1 6009-18067 SF3 4.82 HP4 KroHrs 534040 Kronos HR 1 6009-18067 10.13 HP4 KroHrs 534040 Kronos HR 1 6009-18067 10.17 HP4 KroHrs 534040 Kronos HR 1 6009-18067 8.12 HP4 KroHrs 534040 Kronos HR 1 6009-18067 2.4 HP4 KroHrs 534040 Kronos HR 1 6009-18067 SF1 8.15 HP4 KroHrs 534040 Kronos HR 1 6009-18067 4.82 HP4 KroHrs 534040 Kronos HR 1 6009-18067 SF1 3.33 HP4 KroHrs 534040 Kronos HR 1 6009-18067 SF1 10.03 HP4 KroHrs 534040 Kronos HR 1 6009-18067 SF1 5.7 HP4 KroHrs 534040 Kronos HR 1 6009-18067 SF1 8.2 HP4 KroHrs 534040 Kronos HR 1 6009-18067 SF1 8.17 HP4 KroHrs 534040 Kronos HR 1 6009-18067 SF1 10.13 HP4 KroHrs 534040 Kronos HR 1 6009-18067 SF1 10.17 HP4 KroHrs 534040 Kronos HR 1 6009-18067 SF1 8.12 HP4 KroHrs 518634 Kronos HR 1 6005-10000 1.23 HP4 KroHrs 518634 Kronos HR 1 6005-17134 8.1 HP4 KroHrs 518634 Kronos HR 1 6005-10000 0.45 HP4 KroHrs 518634 Kronos HR 1 6005-10000 1.97 HP4 KroHrs 518634 Kronos HR 1 6005-10000 3.75 HP4 KroHrs 518634 Kronos HR 1 6005-10000 5.7 HP4 KroHrs 518634 Kronos HR 1 6005-10000 1.45 HP4 KroHrs 518634 Kronos HR 1 6005-10000 0.38 HP4 KroHrs 518634 Kronos HR 1 6005-18233 1.6 HP4 KroHrs 518634 Kronos HR 1 6005-17134 8.1 HP4 KroHrs 518634 Kronos HR 1 6005-G0167 0.32 HP4 KroHrs 518634 Kronos HR 1 6005-17134 8.08 HP4 KroHrs 518634 Kronos HR 1 6005-17134 6.38 HP4 KroHrs 518634 Kronos HR 1 6005-10000 0.5 HP4 KroHrs 518634 Kronos HR 1 6005-17134 5.75 HP4 KroHrs 518634 Kronos HR 1 6005-17134 4.03Practical Graph: Creating a Multi-Workload User Activity Report
Microsoft 365 comes will many usage report APIs covering different workloads. This article explains how to use PowerShell to extract usage data for multiple workloads to combine together to create a holistic view of user account activity within a Microsoft 365 tenant. https://practical365.com/holistic-usage-report/
Trying to transfer information from one excel sheet to another.
Hello, I'm new and just learning how to work excel, I was wondering how or what formula would I use to make it so that when I put information on one sheet it would transfer over to another excel sheet. For example, I would put the information on Sheet1, and it would transfer over to Sheet2 on a specific cell.
Loop development has seemingly stopped
Our team adopted Loop since many of us prefer the personal knowledge management system style of Notion or Obsidian to other classic note-taking and sharing software. However, many core features are still not present that have been Day 1 features of these other tools, and a quick check of the Loop Roadmap leads me to believe that most features will be security/governance focused. That's disappointing if true, because right now Loop is clearly inspired by those tools, but incredibly far behind in a way that makes it hard to justify their continued use. For example: Cannot embed documents inside Loop-- in Notion you can just drag and drop a PDF to upload, and the /embed command lets you put an interactive document inside the page Cannot select multiple pages to re-arrange structure No Copilot to perform page cleanup-- Notion lets you use AI to fix formatting, and it works very well. No command palette-- this is a must for operating in a knowledge management system No Mac app No mind map a la Obsidian I could continue to produce these examples, but I am hoping to find out that once some core governance features are completed, Microsoft will be focusing some development efforts on improving this platform-- we hope it is not abandonware a few years into it's launch.
I need to speak to a person at Microsoft
Firstly, I don't know if this is the correct place to ask, if not, I apologise, and would be greratful if I could be directed to the correct medium. So..... *** I am writing this on behalf of someone else *** His account has been locked after he had been hacked and infected with a virus, and Microsoft will not unlock it. However, they have decided (today) to take his money for his 365 subscription, that he can't use, and doesn't want. When looking for a way to cancel it, the answer is log-in to his account and cancel it himself. BUT, he can't log in because the account is locked. He has tried looking for a phone number to speak to someone, but cannot find any. He has tried looking for a Live Chat, but, (if it exists) it is only available after he logs in. He just wants to cancel the subscription, and get a refund. Can someone please give me a contact number - preferably in the UK, but any English speaking representitive, in any countrty will do. Thanks,Compliance licenses at tenant level
Hi, We are a small organization of about 200 employees, and we have following requirements. DLP policies configuration at Exchange, OneDrive, SharePoint BYOD security Users should not be able to send files outside the org And so on as we evaluate We already have M365 Business Premium. However, after researching we figured out that M365 Business premium will alone not solve our requirements. May be compliance license will. We want to apply security policies at tenant level in our organization but definitely do not want every user to get licenses as this will be expensive for us and there is no requirement at all for our users. The question is, Is there a way to solve the above scenario?
Python in Excel - not in toolbar
I have MS Excel (Current Channel) via an M365 - Business Premium license I have Python in Excel; I know this because if I type '=py' in a cell and hit tab I get a python cell with the green [py] box. However, I do not get the Python group in the Formula toolbar... why?? This grouping is supposed to have the 'Insert Python', 'Initialization', and 'Reset' controls in a grouping named Python. Subsequently, I have had to create a custom grouping with the relevant python controls added manually... What is the cause of the python controls missing from the Formula toolbar?Resubmitted response overrides original response instead of making a new entry
Hi, I have a Microsoft Form that allows respondents to edit their submissions after submitting. Last week when someone resubmitted their response, it created a new entry in the Excel sheet which is what I prefer since it triggered a Power Automate flow. However, I ran it again this week and now it seems to override the original response in the Excel sheet. This does not trigger the flow, which is a big issue. Does anyone know why this might be happening/how to fix it? Thanks in advance!
Account blocked
My account has been blocked and when I try to reset my password and do the verification with my phone number, it says it isnt available. I then put in a different email to send the code too and I have filled out the recovery form but it has rejected me, even though, I put all the correct information in. I have tried over and over. Everything comes in to that email so I really need access back for work purposes as well as private. Please can someone help me as I cant speak to a customer support agent!Understanding the Different Types of Cloud Services (IaaS, PaaS, SaaS)
Cloud computing has revolutionized the way businesses and individuals access and manage technology resources. Instead of owning and maintaining physical servers or software, cloud services allow users to rent computing power, storage, and applications over the internet. However, not all cloud services are the same. The cloud ecosystem is broadly divided into three main categories: Infrastructure as a Service (IaaS), Platform as a Service (PaaS), and Software as a Service (SaaS). Understanding these models helps organizations choose the right cloud strategy based on their needs, scalability goals, and technical expertise. https://dellenny.com/understanding-the-different-types-of-cloud-services-iaas-paas-saas/Public vs Private vs Hybrid Cloud Models Explained
Cloud computing has revolutionized the way businesses store, manage, and process data. But as organizations shift from traditional IT infrastructures to the cloud, one crucial question arises: which cloud deployment model is right for you? To answer that, let’s break down the three main types of cloud models — public, private, and hybrid — and explore their benefits, drawbacks, and ideal use cases. https://dellenny.com/public-vs-private-vs-hybrid-cloud-models-explained/Why Businesses Are Moving to the Cloud Top 5 Benefits Driving Digital Transformation
In the past decade, cloud computing has shifted from being a trendy tech term to an essential business strategy. From startups to global enterprises, organizations across industries are migrating to the cloud to enhance agility, reduce costs, and stay competitive in an increasingly digital world. But what exactly makes the cloud so transformative? Let’s explore the top five benefits driving this massive shift. https://dellenny.com/why-businesses-are-moving-to-the-cloud-top-5-benefits-driving-digital-transformation/Excel desktop application crashes when trying to share or copy link
For the last couple of weeks when I've attempted to share an Excel file from the desktop app (multiple different files) the application crashed and closes out. The file are all saved to my personal OneDrive. It only seems to affect the files from my SharePoint, and only when trying to share through the desktop app. I can open it on the web version and share. I tried sharing a file that was opened through a SharePoint site and it seemed to work.
Recent Blogs
- Recent changes reduce false positives, better reflect real accessibility needs, and help you prioritize addressing truly impactful issues.Oct 20, 2025
- October 17 marks a quiet revolution. On this day in 1979, VisiCalc shipped—the first electronic spreadsheet—and suddenly, anyone with a computer could model ideas, track budgets, and make decisions f...Oct 17, 2025
