Probably the easiest way to not display errors like #VALUE! or #DIV/0! in an already existing worksheet is to use Conditional Formatting. Here’s how: Select all the cells you want […]

Read More

What is this command, anyway? It’s a way of reflowing text. You can get it from the Editing section of the Home tab: Or from the Vertical section of the […]

Read More

Double-click the format painter keeps it “alive” to click on several cells without having to click it again. You cannot double-click Shape tools – But if you right-click a tool, […]

Read More

Did you know that if, in a large worksheet, you drag the cursor-that is, you click in cell A20, for example, hold the mouse button down and then drag the […]

Read More

Anything in the clipboard can be pasted onto a chart Clicking on the coins, copy (ctrl/c), click on a series, Home/paste (or ctrl/v): Right-dick on the series, use Format Data […]

Read More

The Excel FILTER function filters a range of data based on supplied criteria, and extracts matching records. The purpose is to filter a range with given criteria. The return value […]

Read More

In the tab VCR-type scrolling controls, If you hold the shift key down while clicking one of the inner two controls, you will scroll a “page” of tabs (all the […]

Read More

How can we insert fast a blank row in a list after each row? Here’s a technique to double-space your data which is faster than any macro could do it […]

Read More

If Sheet1 has the setup you want and Sheet2 is to receive the same settings. Most of the people, they repeat all the Page setup settings for every sheet. Instead, […]

Read More

Suppose you are looking at a worksheet which contains dates which can’t be formatted as “real” dates because of their structure: Select the date(s), and use Data tab, Text-To-Columns. which […]

Read More