Excel tutorials, functions and advanced formula examples, page 23
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
Take your Ultimate Suite to the next level
There is a lot of different software around us. Some of it really simplifies life, and some of it just doesn't. I want our Suite to fall under the first category. As this year started, I began collecting all the feedback our customers send to us to understand how we can make Ultimate Suite your reliable assistant in Excel... Continue reading
Got Office 2013? Ablebits add-ins are in!
Are you always the first to try new stuff? Here's something you'll like: all our add-ins support Microsoft Office 2013 starting today! Continue reading
Trim Spaces app for Excel - remove trailing and leading spaces
If you already moved to Office 2013 and miss Trim Spaces in your Excel, follow simple steps to regain the tool for finding and removing leading and trailing spaces in your worksheets... Continue reading
Outgoing Email Checker - Never hesitate before hitting Send
If you use Outlook as a primary tool for business communication, your e-mail is a great part of your professional image. However, the more e-mails we send, the more likely we are to make simple e-mail mistakes that can cost us reputation or even career. So we decided to go through the silliest of these mistakes and create a tool that will help you avoid them... Continue reading
Tutorial with Excel examples about Macros
Many people think that it is extremely hard to learn Excel Macros, but it is not. This article contains some nice and simple Examples to automate your daily tasks in Excel... Continue reading
How to rotate Excel charts or worksheets: quick tip
Certain worksheets or charts may look much better if you change their orientation. So in today’s how-to article we’ll have a look at how to rotate Excel table or chart. Continue reading
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
Microsoft Excel Charts: Tips, Tricks and Techniques
Some tips, tricks and techniques for better looking charts in Microsoft Excel. Continue reading
Excel Add-ins Collection by Ablebits: Faster and better
Lots of Excel users like Ablebits Add-ins Collection for its ability to speed up many tedious and time-consuming tasks they perform daily in Excel. There’s no limit to perfection, so our developers have been working hard on the collection optimization and finally introduced some really dramatic changes... Continue reading
