Articles in Office | UserComp.com

Creating Cross-Page Borders in Microsoft Word: A Single Cell Solution

Learn how to create cross-page borders in Microsoft Word using a single cell technique. This method can help you maintain consistent formatting across page breaks.

Creating an Excel Product Cross-Reference Tool for Shipping vs. Received Amounts

Learn how to create an Excel tool to cross-reference and compare shipping and received amounts in company invoices.

Google Docs: Incorrect Table Page Numbering

Users report an issue with incorrect page numbering in tables within Google Docs. This article provides a solution to the problem and demonstrates it through screenshots.

Setting the Background Color of a Textbox in MS Access

Learn how to set the background color of a textbox in MS Access using VBA. This article covers setting the background color to Blue with Accent 1 and Lighter 80%.

Randomly Selecting Cells in Excel: A Tech Support Solution

Learn how to randomly select cells in Excel using various methods. This tech support article provides step-by-step instructions for Excel users.

How to Copypaste Values of Cells in Excel: A Quick Way

Learn how to copypaste values of cells in Excel using the F9 function or by using the keyboard shortcut Ctrl+C and Ctrl+V. This quick tip will save you time and effort.

Arial Font Always Shows as Italic in Microsoft Office Applications

Users report an issue where the Arial font in Microsoft Office applications (including WordPad) appears as italicized by default. Changing the font back to normal does not resolve the issue. In this article, we will discuss possible solutions to this problem.

Changing Arrow Style in Microsoft Word: Wide Triangle instead of Default

Learn how to change the arrow style from the default to a wide triangle in Microsoft Word using the InserttabShapes button.

Excel: Conditional Formatting Cells based on Row Differences

Learn how to apply conditional formatting to cells in Excel based on differences between rows. Follow these simple steps to color-code or highlight cells based on specific conditions.

Creating Non-Collapsable Headings in Microsoft Word

Learn how to create non-collapsable headings in Microsoft Word. This article provides step-by-step instructions for order of getting text not to collapse, shifting around headings, and making the first phrase text as headings.

Google Forms Autofill Suggestions Not Working: Faster Submissions

Experiencing issues with Google Forms Autofill Suggestions not working and slowing down your submission process? Learn potential solutions and optimize your experience.

Resolving Conflicts with Altcodes and Application Hotkeys: A Tech Support Guide

Learn how to resolve conflicts between Altcodes and application hotkeys on both Linux, Windows, and MacOS systems. This tech support article provides step-by-step instructions for enabling the Hex Numpad registry key.

EAP-TLS SSL Handshake Failure: Unknown CA (Fatal, Level: 1)

This article explains the causes and solutions for the EAP-TLS SSL handshake failure with the 'Unknown CA' error message.

Capitalize First Letter of Everything in Excel Formula in Excel 2019 (Windows)

Learn how to modify an Excel 2019 formula to capitalize the first letter of every character using the PROPER function.

WezTerm Horizontal/Vertical Split Shortcut on macOS

Learn how to enable horizontal and vertical split shortcuts in WezTerm terminal app on macOS.

Getting (Slowly) Away: Troubleshooting a Sluggish Gmail Experience

Recently, I've been experiencing some inconvenience with my Google account, specifically with Gmail. It seems to be getting slowly away from me. In this article, we'll explore some potential solutions to help you overcome a sluggish Gmail experience.

Getting Away from Gmail: A Convenient Solution for Google Account Issues

Recently, I've been experiencing issues with my Google account, specifically with Gmail. Instead of waiting for a resolution, learn about a convenient alternative.

Automatically Increment Academic Grade Year with Excel Formulas

Learn how to create a formula in Excel that automatically recognizes and increments the academic grade year for a table of students.

Permanently Disable Outlook's Annoying Ad Bar: A Tech Support Guide

Learn how to permanently disable the promotional messages and ads in Outlook mail client for Microsoft 365 subscribers.

Regular Expressions: Replace Text Strings in MS Word Document with GRXXX

Learn how to use regular expressions to replace text strings in an MS Word document with a specific format, such as GRXXX.

AutoFill Step Formula: Troubleshooting XLOOKUP Calculated Column Issues with Phone Number Sources

Learn how to troubleshoot XLOOKUP calculated column issues when working with phone number sources in Excel.

Extracting Autocomplete Email Addresses Stored in Outlook for General Use

Learn how to extract autocomplete email addresses stored in Outlook for general use, even if you don't use the contacts feature.

Calculating Fees for $3.5M Following a Specific Formula in Excel

Learn how to calculate fees for $3.5M using a specific formula in Excel: 7% for the first million, 0.5% for the second million, and 0.3% for the third million.

MS Access Refuses to Create Correct Lookup Relationship: A Step-by-Step Guide

Learn how to troubleshoot and resolve MS Access lookup relationship issues when trying to create a relationship between short text fields in the 'data' table ('test' field) and another table.

Outlook Web App: Unable to Preview PDF Attachments in Exchange 2019

Users of Outlook Web App on Exchange 2019 encounter issues previewing PDF attachments. This article provides solutions to resolve the problem.

Cross-Referencing Two Worksheets with Columns for Email Matching

Learn how to cross-reference and match email addresses between two Excel worksheets using VBA.

Creating Hellish Footnotes in MS Word on Mac

Learn how to resolve issues with creating footnotes in MS Word on a Mac.

Thunderbird: Pre-filled WeTransfer Link for HTML Signatures

Learn how to set up a pre-filled WeTransfer link for your HTML signatures in Thunderbird email client.

Deleting a Spreadsheet from Outlook on Windows, Mac, and Linux

Learn how to delete a spreadsheet attached to an email in Outlook for Windows, Mac, and Linux.

Using SUMIFS Function: Dropping List Data from One Sheet to Another

Learn how to use the SUMIFS function in Excel to combine data from two different sheets. In this tutorial, we'll walk you through the steps to sum data based on conditions from one sheet and display the results in another.

Connecting Google Calendars in Thunderbird

Learn how to connect and sync multiple Google Calendars with Thunderbird, including the Agenda and Contacts calendars.

Managing Computer Gain/Loss with Variable-Sized Lots Using FIFO Method in Excel

Learn how to manage computer sales and purchases using the First In First Out (FIFO) method and variable-sized lots in Excel. This tutorial covers calculating overall costs, creating receipts, and tracking profit/loss.

Automatically Selecting Series Scatterplot in Excel 365: A Step-by-Step Guide

Learn how to automatically select series in a scatterplot in Excel 365. This tutorial provides a step-by-step guide to help you easily identify and select the desired series for further analysis.

Accessing LAN Devices: WireGuard VPN Setup with Peers Behind Different VPN Clients

Learn how to access LAN devices when setting up WireGuard VPN with peers behind different VPN clients. This article covers the steps for a WireGuard server with public IP, AWSEC2 running Ubuntu, and new WireGuard configurations.

Conditional Formatting Base Cells in Excel: Color Cells Near '1' Red and '2' Green

Learn how to apply conditional formatting in Excel to color cells near specific values, such as '1' and '2'. In this tutorial, we'll show you how to make cells red when they're near '1' and green when they're near '2'.

How to Free Up Storage Space in Outlook.com Accounts: A Tech Support Guide

Learn how to free up storage space in your Outlook.com account. This tech support article covers solutions for web apps, Windows, MacOS, and iPhone apps.

List Currently Installed Office Applications Programmatically: Office Editions and Apps

Learn how to programmatically list currently installed Office applications, including editions like Word, Excel, and Outlook, on both Windows and Linux systems.

Accessing External Public URL in Helm Chart

This article explains how to access an external public URL using a Helm chart. We will use the provided example of an ingress resource in a Helm chart located at <https://github.com/rcbandit111/external_domain_helm_chart_poc/blob/main/pod-chart/templates/ingressresource.yaml>.

Maintaining Connections: Keeping Network Interfaces Alive When Physically Disconnected

Learn how to configure network interfaces to stay active even when physically disconnected. This tip is particularly useful for tinkerers and system administrators.

VBA Code: Lookup Value in Column (Sheet2) Matches Value in Column (Sheet1) - One-Click Data Validation

In this article, we will walk through creating a one-click data validation solution using VBA code in Excel. The code checks if a value in Column C of Sheet1 matches a value in Column X of Sheet2. If a match is found, the cell is validated and returns True. If not, it returns No.

Splitting a Long Single-page PDF into Multiple Pages

Learn how to split a long single-page PDF into multiple pages while keeping the horizontal size. This guide applies to various operating systems like Linux, Windows, and MacOS.

Deleting Specified File Names with Wildcards in Tech Support: OneDrive Installation

Users may encounter issues during OneDrive installation where certain files with specified text names are deleted unintentionally using wildcards. This article explains how to avoid deleting unwanted files and provides a solution for those who have already experienced this issue.

Determining Access to Exchange Admin Center: Disabling Read Receipts in Outlook