Excel tutorials, functions and advanced formula examples, page 22
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
How to export Outlook contacts to Excel 2016, 2013 or 2010
In this article I will show how you can quickly export contacts from Outlook 2013, 2010, 2007 and 2003 to an Excel spreadsheet. First I will explain how to use the build-in Outlook Import / Export function, and after that we will create a custom contacts view and copy / paste it to an Excel file. Continue reading
How to merge two Excel Worksheets by partial cell match
This article will show you how to quickly merge data from two Excel tables when there are no exact matches in your key columns, e.g. your unique ID in the first table may make up the first five characters of the ID column in your second table. I have tested all the solutions I present in this article, they work in Excel 2016-2007. Continue reading
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 2013 and Excel 2016. Continue reading
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
How to automatically highlight duplicates in Excel once something has been typed
This article will show you how to avoid duplicates in your table columns using built-in Excel tools. The solution works for Excel 2013, 2010, 2007, and it will take you just a few minutes to apply it to your table. Continue reading
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
Video how to: consolidate duplicate rows keeping unique data only
Watch our 2 minute video to learn how you can quickly merge duplicate rows into one using Combine Rows Wizard add-in. Continue reading
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
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
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
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
"Outlook Not Responding" error - working 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
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
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
How to disable Animation in Excel 2013
At first sight, Excel 2013 seems to have a more modern and stylish interface with animated movement of the selection box, smooth zooming and fluid switching between menus and worksheets, it looks cool! But if you have a slow computer you might find the animation annoying because all it will do for you is slow down the working process in the program. I've surfed different support forums and blogs to share all the discovered solutions with you. Continue reading
The promised update: ultimate set of tools for your Excel
The time has come for the update, Part Two! Upon receiving your feedback, I was standing over our developers while they were coding numerous improvements. Now you can take advantage of the new version and find your requests in the enhanced tools. Continue reading
How to open Excel files in separate windows
Tasks that seem to be non-standard, sometimes appear to be very popular. Opening Excel 2010 or 2007 workbooks in different windows is one of them. I've read all the complaints and solutions on the Office forums, and this post will try to provide the summary of the easiest ways to go. Continue reading
How to freeze header rows in Excel
With new Excel capacity to hold a million rows and numerous columns with numbers, it is easy to lose the connection between the value and its meaning on line 26935. This is one of the reasons Excel keeps the commonsense "Freeze" feature for you. It allows you to keep track of the data you are looking at without having to scroll back and forth to see the column or row labels. Continue reading
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
