The basic SUM function in Excel is sufficient for adding a variety of numbers across a range of cells. However, what if you only need to add a few numbers that match a specific criteria from a range of cells? If that is so, add th...
Excel includes a Move or Copy option that enables users to move or copy a worksheet with all its formatting and data intact. So if you ever need to set up a new Excel worksheet based on a spreadsheet in another workbook, you can q...
In other articles, I’ve already told you about Data Set and Icon Set conditional formatting options in Excel. In addition to those, you can also select Color Scales conditional formatting. That adds a two or three color sca...
Excel is one of the best spreadsheet applications that has a multitude of functions to select from. Among those functions is SUMPRODUCT. That’s a function that takes one or more arrays of numbers and adds the sum of their pr...
Excel has a multitude of functions that you can add to spreadsheets. Among them is the Count function, which is a handy statistical tool that counts spreadsheet cells. This is how you can add three Count functions to your Excel 20...
If your Excel spreadsheet includes lots of blank rows you can delete them by right-clicking a row and selecting Delete. However, there’s another, and better, way to delete blank rows from Excel spreadsheets. To begin, simpl...
A progress bar is something that provides feedback on a given process. Most will be familiar with download progress bars that show you how much of the software has been downloaded in percentage terms. You can also add progress bar...
If you have an Excel spreadsheet with lots of data it might take a while to manually check through it for duplicated values. One way that you can quickly find duplicated cell values is with the Conditional Formatting option. When ...
Excel 2010/2013 has plenty of formatting options for spreadsheets. Among them are Excel conditional formatting options with which you can format spreadsheet cells based on their numerical values. You can add icons, based on a cond...
Excel 2010, like other MS Office applications, has plenty of keyboard shortcuts. There are Excel hotkeys for formulas, spreadsheet formatting, inserting and editing data and more besides. These are a few of the more notable hotkey...
Excel 2010/2013 doesn’t have any specific options that add watermarks to spreadsheets. However, you can still add watermark images and text to spreadsheets. Add the watermarks to the spreadsheets with Excel’s header and footer too...
If you have to change multiple cell cases in an Excel spreadsheet it’s not essential to delete and re-enter their content. Excel has three functions with which you can change the case of text. With those you can enter a function w...
Those who have very large Excel spreadsheets can reduce them in size by removing a few rows or columns. Excel 2010/13 includes Hide/Unhide options with which you can temporarily remove columns and rows from view. As such, you don’...
Whether you have a full Excel package or an Excel Starter alternative, there are numerous display options which you can customize your spreadsheets with. You can find them by clicking the File tab and then Options. Then select Adv...
