Articles in Office | UserComp.com

Disable Long-Press Ctrl Keyboard Shortcut in MS Word Interrupting Workflow

Users encountering an issue where continuously long-pressing the Ctrl key interrupts their MS Word workflow. This article explains how to disable the Layout Options MS Word shortcut associated with the long-press Ctrl key.

Displaying Different Data Series in a Datatable Chart: Showing Percentage Growth Rates

Learn how to display different data series in a datatable chart and calculate simple percentage growth rates for Series1 and Series2 within a category. Example: Series1 in Category1 grows by 19.7%, while Series2 decreases by 11.6%.

Filter Function: Column Values in Tech Support - Product Lists and Associated Data

Learn how to effectively use the filter function to manage and analyze product lists and associated data in tech support. This article includes practical examples and tips for using this powerful feature.

MSWord Table Contents Overlaps/Covers Header or Footer: TOC Gets Cut Off on Page Footer in Win11 Office 16

Users encounter an issue where the Table of Contents (TOC) in MSWord for Win11 Office 16 overlaps or covers the header or footer, causing the TOC to get cut off on the next page. This article provides a solution to the problem.

Teams Updates: Restored Image Sizes Differ After Recent Reboot

Yesterday, after rebooting, Teams updated and now posts with large images show different sizes. This article explains the issue and suggests potential solutions.

Teams Displays Messages Twice on Two Accounts: Prevention

Learn why Teams displays messages twice on two accounts and how to prevent it from happening.

Setting up Azure DevOps pipeline connection in MSTeams for master/main branch builds

Learn how to set up alerts in MSTeams channel whenever software build pipeline completes in Azure DevOps, using master/main branch.

Error 26 when Connecting to SQL Server Browser after Installation

After installing a new version of SQL Server Express, you uninstalled the previous version but now encounter an error (26) when trying to connect to the SQL Server Browser. This article provides instructions to help resolve the issue.

Outlook Application Trying to Access Email Address Information at Startup: A Permanent Solution

Learn how to permanently block an Outlook application from accessing email address information during startup.

Mirroring and Flipping Excel Cell Timeduration Data

Learn how to mirror and flip the timeduration data in Excel cells for efficient data analysis. This tutorial covers copying and pasting hh:mm:ss formatted data.

Preserving Capital Letters in ExitPaint Text Regime: A Guide

Learn how to preserve capital letters when adding a big capital letter picture to a 16*16 pixel BMP using Microsoft Paint in ExitPaint Text Regime.

Automatically Filter Large Datasets: Pivot Table Reference in Tech Support

Learn how to automatically filter large datasets using Pivot Tables in Excel. This tech support article provides a step-by-step guide for sorting items and updating table references.

Filtering and Sorting Large Datasets: Selecting Items for PivotTables

Learn how to filter and sort large datasets to select specific items for use in PivotTables.

Microsoft Access (2007-2016) - Form: ListBox Can't Find Current Record

Learn how to resolve an issue where the ListBox in a Microsoft Access form (2007-2016) does not display the current record when a value is selected in the ComboBox.

Disabling AutoCapitalization in New Outlook

New Outlook versions automatically capitalize letters in emails. Here's how to disable this feature.

Maintaining Internal Bookmarks When Creating a New Document with Multiple Bookmarks

Learn how to keep internal bookmarks linked when creating a new document with multiple bookmarks using different tools.

Configuring Customized Rule Mail Folder in Outlook for Microsoft 365 (MSO) Version 2402, Build 16.0.17328.20282, 64-bit

Learn how to identify and configure the location of customized rule mail folders in Microsoft Outlook for Microsoft 365 (MSO) Version 2402, Build 16.0.17328.20282, 64-bit.

Excel: Connecting and Grouping Associates with Power Query

Learn how to connect and group associates in Excel using Power Query. This tutorial covers data cleaning and Power Query scripts for merging PDF files and preparing data for analysis.

Combining Stacked and Clustered Columns in Excel Charts: A Pareto Analysis Example

Learn how to create a combined stacked and clustered column chart in Excel and apply Pareto analysis to identify the main causes of a problem.

Requesting Editing Permissions for MS Outlook Calendar Resources

An employee requested company admin to grant permissions for managing specific resources in MS Outlook Calendar.

Understanding Excel Custom Filter Hierarchy for Columns

Excel's custom filter hierarchy for columns works similarly to the filter date column hierarchy (Year > Month > Day > Time). Learn how to apply and manage column filters in Excel.

Strange Excel 365 Font Behavior after Aptos Update (Editing Cells)

Users report experiencing strange font behavior in Excel 365 after an Aptos update. The Narrow (11pt) default font changes unexpectedly while editing cells.

How to Disable the Research Pane in Microsoft Office: A Step-by-Step Guide

Learn how to stop the Research Pane from appearing in Microsoft Office Excel, Word, or PowerPoint. This quick and easy guide will walk you through the process of disabling research options per file.

Using GREP/Regex in Adobe InDesign: A Practical Guide

Learn how to use GREP (Global Regular Expression) and Regex (Regular Expression) in Adobe InDesign to find and replace text efficiently. This article provides a practical guide with examples using various search patterns.

Not able to Open Copy Folder using Hyperlink in OneNote: A Solution

Users report an issue where they are unable to open a copy folder using a hyperlink in OneNote. This article provides a possible solution to the problem.

Adding Custom Domain to Cloudflare Workers & Pages: Menu Instead of CNAME Records

Learn how to add a custom domain to Cloudflare Workers & Pages using the menu instead of CNAME records.

Removing Duplicate Lines based on Specific String: Two Similar Cases

In this tech support article, we will guide you through the process of removing duplicate lines based on a specific string in two similar cases using different text editors: Vim and Notepad++.

Adding Background Box Words as Subtitle Format in techsupport site

Learn how to add background box words as subtitle format in techsupport site using ASS subtitles. Follow the instructions below.

Autoclosetag in VSCode: XSLT/XPath Extension Not Working for Editing XSL Files

This article discusses a common issue with the Autoclosetag feature in VSCode's XSLT/XPath extension while editing XSL files. We'll explore potential solutions and workarounds.

Creating Hyperlinks to Sheet Names in Lookup Sheets: A Workbook Navigation Guide

Learn how to create hyperlinks to sheet names in a lookup workbook using VBA for seamless navigation between sheets.

Calculating Sum Profits with Multiple Criteria in Tech Support

Learn how to calculate sum profits based on multiple criteria in tech support. Column V is working fine, but you want to add additional criteria. Let's explore how to do it.

Customizing Outlook: Set Dedicated Background Color for Mailbox

Learn how to set a dedicated background color for your mailbox in Outlook, for your email accounts with different providers.

Identifying Number of Cells with Certain Colour in Excel

Learn how to identify and count the number of cells with specific colours in Excel using formulas.

VBA: Row Pastes Need to Check Last Blank Column, Not the One Before

In VBA code, when pasting data, it currently pastes data up to the last blank cell in column C. However, sometimes there are blank cells, which can cause issues. This article explains how to modify the code to check for the last blank column instead.

Removing On-Printable Characters in Notepad++ with Another Text Editor

When copying and pasting text from Notepad++ to another text editor, on-printable characters like small black boxes (xFBxFF) may cause unexpected results. Learn how to avoid this issue by using a different text editor.

Change Title Bar Color in Microsoft Office 2019 Applications

Learn how to change the title bar color in Microsoft Office 2019 applications, including Word, Excel, and PowerPoint. This article does not apply to Microsoft 365 versions. Possible solutions include using a winater tweaker.

Change Title Bar Color in Microsoft Office 2019 Applications

Learn how to change the title bar color in Microsoft Office 2019 applications, including Word, Excel, and PowerPoint.

Advanced Sorting: Alphanumeric Orders and Column Synchronization

Learn how to sort columns alphanumerically and ensure they remain synchronized using Excel's SORTBY formula.

Google Sheets: Selecting Part of a Full Row with Shift Space

In Google Sheets, pressing Shift Space selects the entire row. However, if you want to select only part of a row, press Shift Space again without releasing it to extend the selection. Here's a step-by-step guide.

Regexp Multiple Lines Grep: Finding Matches Across Newlines

Learn how to use regular expressions (regexp) with the grep command to search for patterns across multiple lines in a file. This article provides examples for Linux, Windows, and MacOS.

Automate Sending Existing Gmail Emails Based on Criteria with Workflow

Learn how to set up a workflow to automatically send existing Gmail emails based on certain criteria using IFTTT and Power Automate.

Managing Multiple Entries in a Single Excel Cell: Unique Products vs. Shared Components

Learn how to manage unique products and shared components in a single Excel cell. This article provides practical solutions and SEO-optimized tips for handling list components with multiple entries.

Mac: Unexpected Behavior of ctrl+D in Python

When using MacOS, pressing ctrl+D in Python does not quit the interpreter as expected. Instead, the terminal suspends the process with 'zsh: suspended'. This article provides a solution.

Prevent Host Computer Locking using Remote Desktop with HoloLens on Windows 10

Learn how to prevent your host computer from locking while using Remote Desktop with HoloLens on Windows 10.

Opening Computer Management in Visual Basic using a Button

Learn how to open Computer Management in a Visual Basic application using a button and the Process.Start method.

Creating a Temporary US Phone Number for SMS using API: A Python Guide

Learn how to create a temporary US phone number for receiving SMS using Python and APIs from receive-smss.com and anonymsms.com.

Populating OneDrive Folder for Local Backup without Affecting Remote Files

Learn how to create a local OneDrive backup without affecting remote files after re-installing Windows.

Reading Maildir Files: A Guide for Windows Users

Learn how to read Maildir files on Windows, browse emails, run keyword searches, filter and sort data, extract attachments, and display emails.

Line Replacement vs. Newlines: A Tech Support Dilemma

The recent update of FFmpeg has caused some confusion for users who are used to the old way of working with text files. When a line is replaced, it prints a newline character. This can lead to irritating results and slow down the process. In this article, we will explore the difference between line replacement and newlines and provide some solutions for those who are experiencing this issue.

Pulling Data Across Worksheets in Google Sheets: Label1

Learn how to transfer data labeled as 'Label1' from column F in Worksheet 1 to column A in Worksheet 2 in Google Sheets.