Posts Tagged 'Excel tips', page 17

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

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

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

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

Bring classic toolbar back to Office 2010, 2007

If you use Microsoft Office 2007/2010 and you are still not used to the new interface, or the Ribbon is the only reason that stops you from upgrading, here are several suggestions how to integrate the old and the new and get familiar command bars in Office 2007-2010... Continue reading

View Excel workbooks side by side

You’d like to compare two Excel worksheets and need to open and see them side by side. However simple it may seem, each time they appear in the same window. That’s frustrating! So we will show you how to view two Excel files (.xls or .xlsx) side by side in this step by step tip. Continue reading

Look up with Lookups in Excel

When you need to find information in a table of data, the lookup functions in Excel can help you do it. While there was a lookup wizard in earlier versions of Microsoft Excel that made the process of creating a lookup quite easy, this is no longer available in Excel 2010. Now, when you need a lookup formula you'll have to create it manually. Read this post to harness the power of lookups for your Excel worksheets... Continue reading

Get rid of "The file is corrupt and cannot be opened" in Excel 2010

Usually when upgrading you expect nothing but improvements. So it can be really disappointing when after moving to Excel 2010 you have no chance to access your xls. file. You understand what I’m talking about if you ever encountered the "The file is corrupt and cannot be opened" error in Excel 2010. Still think it can’t open? Actually it can! Continue reading

Applying multiple Subtotals to your Excel table

Using Subtotals is much more flexible than I put in my previous post about it. Here I would like to expand – literally - the Subtotal function to show some other options that might help you do the work ... Continue reading

How to Consolidate Data in Excel 2013 - 2003

There are many ways to consolidate data in Microsoft Excel. You can use the Table feature and its associated filters, you can create PivotTables, or you can consolidate large amounts of data into a summary form. In this post I'll show you how to use the Consolidate data feature in Excel to take data from a series of worksheets – or workbooks – and summarize them into a single worksheet. Continue reading

Creating and using Custom Lists in Excel

If you have to work with a spreadsheet that will always have the same list of information, or maybe you just don't want to use copy/paste every time, it would be most beneficial to have a pre-set list stored so that Excel can help you with what you are trying to do. Having a Custom List is the way to go and I'm going to show you how you can create a custom list in Excel. Continue reading

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Ultimate Suite 2018.5 for Excel
60+ professional tools for Excel 2019-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard