Loading...

Follow Ablebits Blog on Feedspot

Continue with Google
Continue with Facebook
or

Valid
When working with large datasets in Excel, you may often want to lock certain rows or columns so that you can view their contents while scrolling to another area of the worksheet. This can be easily done by using the Freeze Panes command and a few other features.
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Excel PivotTable is a powerful way to summarize large amounts of data and create summary reports. To make your reports more user-friendly and interactive, add visual filters, aka slicers, to them.
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Though very popular, the nested IF statement is not the only way to check multiple conditions in Excel. In this tutorial, you will find a handful of alternatives that are definitely worth exploring.
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
CHOOSE is one of those Excel functions that may not look useful on their own, but combined with other functions give a number of awesome benefits. At the most basic level, you use the CHOOSE function to get a value from a list by specifying the position of that value.
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Ablebits Blog by Svetlana Cheusheva - 1M ago
Just imagine this. You are working in Excel when all of a sudden you notice that you cannot move from cell to cell normally - instead of getting to the next cell, your arrow keys scroll the whole worksheet. Don't panic - simply turn the Scroll Lock off.
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
How to do a Vlookup without errors in Google Sheets? Take a closer look at the most common mistakes made when working with the VLOOKUP function.
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
In this tutorial, you will learn many different ways to do superscript and subscript in Excel: keyboard shortcuts, custom formats, writing superscripted and subscripted characters with a mouse, and more.
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
I am happy to let you know that the Compare Sheets tool is finally out! You can find it in Ablebits Ultimate Suite for Excel 2018.3.
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Are you stuck with calculating how many days there are since a certain date or until date? This tutorial will teach you an easy way to add and subtract days from date in Excel. With our formulas you can quickly calculate 90 days from date, 45 days before date, and count whatever number of days you need.
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
I am glad to let you know that we have finally released Ultimate Suite 2018.3. In this post, you will find a list of the essential changes and improvements.
Read Full Article
Visit website

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview