Dec
13
How to replace formulas with their values in Excel
Here are good tips to save your time - 2 fastest ways to replace formulas in Excel cells with their values. Both hints work for Excel 2019, 2016 - 2003. Continue reading
Tutorials, videos, useful tips for Excel, Outlook and Google Sheets, page 21
Dec
12
How to sum and count cells by color in Excel
Even though Microsoft Excel has a variety of functions for different purposes, none can count or sum by color of a cell. Aside from third-party tools, there is only one possible solution - create your own functions. Continue reading
Dec
6
How to insert and run VBA code in Excel - tutorial for beginners
This is a short step-by-step tutorial for beginners showing how to add VBA code (Visual Basic for Applications code) to your Excel workbook and run this macro to solve your spreadsheet tasks. Continue reading
Dec
6
How to fix "Cannot start Microsoft Outlook. Unable to open Outlook window" error
Unable to open your Outlook? In this article you will find really working solutions for "Cannot start Microsoft Outlook" problem. The fixes will help you open Outlook again with no errors, the solutions work in all versions of Outlook 2016, 2013, 2010, 2007 and lower and on all systems. Continue reading
Dec
3
How to remove carriage returns (line breaks) from cells in Excel
In this tip you'll find 3 ways to remove carriage returns from Excel cells. You'll also learn how to replace line breaks with other symbols. All solutions work for Excel 2013, 2010 – 2003 Continue reading
Nov
29
How to remove, merge and clean up duplicate contacts in Outlook
In this article you will learn how to merge duplicate contacts in Outlook 2016 and 2013 without using any third-party tools, and how to keep your contact list clean in the future. Continue reading
Nov
20
Sync Google Calendar with Outlook 2016, 2013 and 2010
This article explains how to sync your Google Calendar with Outlook 2016, 2013 and Outlook 2010; it also provides an overview of free tools and services to help you choose the approach best suited for your needs. Continue reading
Nov
15
3 ways to remove spaces between words / numbers in Excel cells
3 quick ways to remove extra spaces between words to 1 or to delete all spaces from Excel cells. Using trim formula, using Excel Find & Replace, using special Excel add-in to clean up cells' content. Continue reading
Nov
12
Why an email gets stuck in Outlook and how to make it send
Email messages may be stuck in the Outbox folder for various reasons. In this article we will try to figure out why this happens and how to make a hanging message send. This will help you understand what exactly can force a message to hang and how to prevent this from happening in the future. Continue reading
Nov
8
How to quickly extract domain names from URLs in Excel
A few tips and pieces of advice will help you get domain names from a list of URLs using Excel formulas. Two variations of the formula let you extract the domain names with and without www. regardless of the URL protocol (http, https, ftp etc. are supported). The solution works in all modern versions of Excel, from 2007 through 2016. Continue reading
Nov
6
How to delete or resend an email message stuck in Outlook's Outbox
The article explains how you can quickly remove or resend emails that are stuck in your Outbox. The solutions work on all systems and all versions of Outlook 2016, 2013, 2010 and lower. Continue reading
Oct
29
How to change the row color based on a cell value in Excel
Learn how to quickly change the color of the entire row based on a single cell's value in your Excel worksheets. Tips and formula examples for number and text values. Continue reading
Oct
20
How to prevent duplicates in a column in Excel
Today I'll tell you how to prevent duplicates from appearing in a column of your Excel worksheet. This tip works in Microsoft Excel 2013, 2010, 2007 and lower. Continue reading
Oct
18
Two ways to change background color in Excel based on cell value
In this article, you will find two quick ways to change the background color of cells based on value in Excel 2016, 2013, and 2010. Also, you will learn how to use Excel formulas to change the color of blank cells or cells with formula errors. Continue reading
Oct
13
How to merge two columns in Excel without losing data
From this short article you will learn how to merge multiple Excel columns into one without losing data. Continue reading
Oct
4
How to set automatic out of office reply (away message) in Outlook
In today's busy world, we all need a break sometimes, even from our emails. But whether you're off on vacation or a business trip, you don't want to leave your contacts hanging. In this article, we'll guide you through the process of setting up automatic replies for different Outlook versions and account types. Continue reading
Oct
1
How to remove all blank rows in Excel
In this quick tip I will explain why deleting Excel rows via select blank cells -> delete row is not a good idea and show you 3 quick and correct ways to remove blank rows without destroying your data. All solutions work in Excel 2016, 2013 and lower. Continue reading
Sep
26
How to enter the same data (formula) into all selected cells at a time
In this quick tip you will learn about 2 fast ways to enter the same formula or text into several Excel cells at a time. It is very useful if you need to insert the formula to all cells in a column or fill all blank cells in a table with the same value (e.g. "N/A"). Both tricks work in Microsoft Excel 2013, 2010, 2007 and lower. Continue reading
Sep
20
How remove multiple (all) hyperlinks from Excel worksheets at a time
In this short article, I'll show you how you can quickly remove all unwanted hyperlinks from an Excel worksheet at once and prevent their occurrence in the future. The solution works in all Excel versions starting from Excel 2003 through modern Excel 2016 and Excel 2019. Continue reading
Sep
19
How to Add a Watermark to a Worksheet in Excel
Do you still think that you can’t add a watermark to your Excel worksheet? I have to say that you are all abroad. You can mimic watermarks in Excel 2010 and 2013 using the HEADER & FOOTER TOOLS. Do you wonder HOW? Read the article below! Continue reading
Sep
10
How to create / update a table of contents in Microsoft Word
If you are a document writer, this article will be very useful for you. You will learn how to insert a table of contents into your document, modify and update it just in a few clicks. Also, I’ll show you how to make your document look good using Word’s built-in heading styles and the multilevel list option. Continue reading
Sep
5
How to compare two columns in Excel and delete duplicates (highlight, color, move)
It will take you about 10 minutes to read this article and in the next 5 minutes (or even faster if you choose the 2nd solution described in the article :) you will easily compare two Excel columns for duplicates and remove or highlight the found dupes. Okay, the countdown is started! Continue reading
Sep
4
How to sort in Excel by row, column names and in custom order
In this article I will show you how to sort Excel data by several columns, by column names and by values in any row. Also, you will learn how to sort data in non-standard ways, when sorting in alphabetical or numerical order does not work. Continue reading
Aug
29
Two best ways to convert numbers to words in Excel
In this article I will show you two quick and free ways to convert currency numbers into English words in Excel 2019, 2016, 2013 and other versions. Continue reading
Aug
27
How to save Excel chart as image, copy or export it to Word & PowerPoint
In this article you will learn 4 quick ways to save your Excel chart as an image (.jpg, .png, bmp. etc.), copy or export it to another file such as a Word document or PowerPoint presentation. Continue reading
Aug
22
"Outlook Not Responding" error - solutions for hanging, freezing and crashing problems
This article explains how to resolve problems with Outlook hanging, freezing or crashing. Our 9 working solutions will help you fix the "Outlook Not Responding" issue and bring your Outlook back to life Continue reading
Aug
7
How to view Outlook Email Headers (internet headers)
Microsoft hid one really handy and essential feature – the possibility to view message headers. The truth is that it contains a lot of information for you to retrieve... Continue reading
Aug
2
30 most useful Excel keyboard shortcuts
Learn the most useful Excel keyboard shortcuts to manage workbooks, format data, work with formulas, navigate between worksheets and more. Continue reading
May
17
How to avoid automatic data formatting in Excel
Excel is a helpful program when you have standard tasks and standard data. Once you want to go your non-standard-Excel way, some frustration is involved. Especially when we have large data sets. I came across one of such formatting issues when I dealt with our customers' tasks in Excel. Continue reading
Apr
12
Enter multiple lines in a single Excel cell
When you have a lot of text in your Excel cells it can be a good idea to show it on more than one line. But how? Every time you enter text into a cell it longs to be on one line however long it is. Here is how you can insert more than one line into one cell on your worksheet... Continue reading
