Posts Tagged 'Excel tips', page 16

How to split cells in Excel: Text to Columns, Flash Fill and formulas

In this article you will find several options to split cells and entire columns in Excel 2016, 2013, and lower. See how to use Text to Columns to split cell contents by delimiter, Flash Fill to separate cells automatically, and formulas to extract names, text and numbrs in different cells. Examples and screenshots will help you choose the right approach for splitting your data in Excel. Continue reading

How to print row and column headers of Excel spreadsheets on every page

Today I'd like to tell you about a small but important feature tucked away in Excel 2013 and its previous versions. In this article you'll learn how to make header rows and column headers print on each page. Continue reading

How to merge rows in Excel without losing data

This article provides solutions for 4 different scenarios of merging rows in Excel. See how you can quickly merge multiple rows without losing data; how to combine duplicate Excel rows, how to repeatedly merge blocks of rows, and how to consolidate matching rows from two different spreadsheets. Continue reading

How to swap columns by dragging and other ways to move columns in Excel

In this article you will learn a few methods to move columns in Excel tables. You will see how to drag columns with a mouse and how to swap several non-contiguous columns. The latter is often considered unfeasible, but I'll show you a tool that allows moving even non-adjacent columns in Excel 2016, 2013, 2010 and lower. Continue reading

How to view, change and remove document properties in Excel

The time has come to tell you about different types of document properties, the ways of viewing and changing them in Excel 2013 and 2016. In this article you’ll also learn how to protect your document from any modifications and remove personal information from your Excel worksheet. Continue reading

Working with Maps in Excel 2013

Yes, now it is possible to work with nice charts that have Maps in Excel 2013. The latest version comes with the Power View. It is an extremely powerful reporting tool. Sometimes we need to get sales reports and we want to identify regions and patterns of sales related to the customers. In this article you will learn how to create cool reports in Excel. We will show countries, cities and specific geographical points. This article is for newbies who want to learn about this exciting area. Continue reading

How to add titles to Excel charts

If you don’t want to get lost in all the charts in your Excel worksheet, then spend some minutes to read this article and learn how to add a chart title in Excel 2016-2010 and have it dynamically updated. I’ll also show you how to add descriptive titles to the axes or remove a chart or axis title from a chart. There’s nothing to it! :) Continue reading

How to filter and sort by cell color, font color and icon in Excel

From this short tip you will learn how to quickly sort cells by background and font color in Excel 2016, Excel 2013 and Excel 2010 worksheets. Continue reading

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 2016, 2013-2003. Continue reading

How to count and sum cells by color in Excel

In this article you will learn how to count cells by color in Excel and get the sum of colored cells. These solutions work both for cells colored manually and with conditional formatting. You will also learn how to filter cells by several colors Continue reading

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

How to remove carriage returns (line breaks) from cells in Excel 2016, 2013, 2010

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

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

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

How to change the row color based on a cell's 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

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

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

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

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

Combine Excel worksheets of the same name into one spreadsheet

This article describes 3 possible ways to merge the same name worksheets across multiple workbooks into a single Excel sheet, and explains how to choose the solution that best meets your needs. 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