Here are the best uses of the Arrow keys in Excel with Scroll Lock mode turned on. Pressing Ctrl+Shift+Up, Down, Left, or Right Arrows selects the current cell and all cells above, below, to the left, ...

VSTACK and HSTACK are dynamic array functions, meaning the result spills from the cell in which you type the formula, and any changes to the data in the source arrays are reflected in the stacked ...

Adding numbers can be made considerably easier by learning the proper techniques. Among these arithmetic strategies, the "Make 10" method gives kids more self-assurance and speeds up calculations.

Similar to the way astrology and personality types can reveal a lot about you, so can numbers. Welcome to the field of numerology, where making calculations based on your birth date can reveal digits ...

In a previous tip I explained how to display numbers with leading zeros. I also explained in another tip how to format numbers with a leading zero. Here I am going to explain how to display that ...

The following samples show how to build the simplest Office Add-in with only a manifest, HTML web page, and a logo. They will help you understand the fundamental parts of an Office Add-in. For ...

Sometimes it's not possible to separate data yourself before putting it into an Excel spreadsheet. Often, the information from old data files gets lumped into a single cell. The same can happen if you ...

Calculate the difference between two values in your Microsoft Excel worksheet. Excel provides one general formula that finds the difference between numbers, dates and times. It also provides some ...

Microsoft Excel is a powerful database management tool with all sorts of in-depth problem-solving functions and dynamic formatting. To make the most of it, though, you need to know the basics. Using ...

Applying shading to alternative rows (zebra stripe rows) in Excel makes your sheet easier to read. The effect, also known as banded row, allows your eyes to keep their place more easily when you’re ...