Monthly Archives: March 2017

Tip #068 – Excel

Excel: More Ways to Play with the Fill Handle

Yet another use for the ever-flexible Fill Handle…

Here are some fast way to insert (yes…INSERT) cells using the Fill Handle.

Full tip: Excel tip

Tip #093 – Word

Word: (Almost) Instant Tables

Full tip: Word tip

Tip #104 – Windows

Windows: The French (keyboard) must be stopped!

In an earlier tip, I explained that you can accidentally change your keyboard language by pressing the [CTRL][SHFT] keyboard combination. Excel users (well, efficient Excel users) are more likely to do this because the keyboard shortcut for selecting to the very bottom of a range of data in Excel is [CTRL][SHFT] ↓

Since [CTRL][SHFT] caused the French characters to start appearing (you get an é when you type a ? mark) that same key combination ([CTRL][SHFT]) pressed once (if you have two keyboard languages installed on your computer) or twice (if you have three keyboard languages installed) can fix the problem – temporarily.

But who wants to have to keep fixing this issue manually?

Full tip: Windows tip

Tip #001 – Microsoft Office

Quick-Close Documents – not programs.

See that X at the top-right corner of your Word (or Excel or PowerPoint) window? That X closes the current program window. I say program window because it is possible to have more than one copy of the same program running at a time. Who hasn’t worked on two Word documents at the same time? Well then, you’ve had two Word program windows open…

Full tip here: Microsoft Office tip

Tip #002 – Excel

The Fastest Copy Method

You have typed a formula into a cell near the top of a column. You would like to COPY that equation to all the blank cells below you (stopping at the lower boundary of the other columns in your spreadsheet)…

Full tip here: Excel tip

Tip #010 – Word

The CHANGE CASE button ain’t so hot…

You’re in Word and you’ve typed some text in the wrong case (all lowercase when it should have been all uppercase, for example)…

Full tip: Word tip