Nederlands
Excel – format #value! or any errors away
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 […]
Excel – format #value! or any errors away
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 […]
Using the justify command
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 […]
Double-clicking tools in Excel
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, […]
Drag/Scrolling in Excel
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 […]
Using pictograms in Excel
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 […]
The filter function in Excel 365
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 […]
Shift/Click inner VCR controls in Excel
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 […]
Double-spacing data in Excel
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 […]
Copy page setups to other sheets
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, […]
Change dates like 20210225 to one Excel “can understand”
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 […]