Category Archives for "Shortcuts"

Find all Conditional Formatting on a Worksheet

Excel , Shortcuts , Tips

Ever try to find conditional formats on a worksheet when the worksheet is showing all cells with unformatted appearance? It’s guaranteed to drive you bonkers and waste your time. Here’s how to do it VERY quickly. Use the Go To Special command. Press F5 or Ctrl+G to display the Go To Special dialog box. Click […]

Continue reading

Amazing Artistry with Excel Drawing Objects!

Excel , Shortcuts

Many years ago I took classes in Sumi-e and calligraphy because I love how their simplicity can communicate so much with clarity. When I saw the artwork that Japanese artist Tatsuo Horiuchi had created with Excel drawing objects I was almost speechless. When you create Excel dashboards you may have used Excel drawing objects or […]

Continue reading

Make Small Changes to a Hand-Drawn Line

Excel , Shortcuts , Tips

Excel has some excellent drawing tools. In fact, there is a Japanese artist who has created amazing artwork using Excel. But, getting the drawing tools to do exactly what you want takes a little finesse. Here are a few tricks. First, draw an arc, curve, or scribble. To do this, 1. On the Insert tab, […]

Continue reading

Quickly Change an Object’s Height or Width

Excel , Shortcuts , Tips

Change an objects height or width quickly using the keyboard. Click on the object to select it. Now, hold down the Shift key as you press the left or right arrow key to change the width or press the up or down arrow key to change the height.

Continue reading

Moving Objects a Small Amount

Excel , Shortcuts , Tips

When you want to position drawn objects to an exact position don’t use the mouse. Instead move the object into the general position using the mouse. Magnify the view to 200% or more so you can see more detail. Select the object and use the arrow keys to move it in small increments.

Continue reading

Select and Change Some Objects on a Worksheet

Excel , Shortcuts , Tips

To select some objects on a worksheet, but not others, click on the first object, and then hold down Shift or Ctrl as you click on the other objects. The objects can be pictures, shapes, charts, and clip art. To resize selected objects, select the ones you want to change, and then drag a corner […]

Continue reading

Keystrokes for Troubleshooting Formulas

Excel , Formulas , Shortcuts , Tips

Go ahead admit it. You’ve made a mistake, at least one. I know I’ve made tons of them, especially in Excel, but then again, when you’ve been using Excel since 1984 like I have, you’ve probably made most of the mistakes – multiple times. Luckily I’ve learned a few handy tips on quickly debugging formulas. […]

Continue reading

Document your formulas right in the cell!

Excel , Formulas , Shortcuts , Tips

I’ve had worksheet amnesia so many times it’s not funny. I’ve learned not to make my formulas too complex or I’ll forget how they work. So now if the logic is arcane or I’m going to pass the worksheet to a client or co-worker I put documentation right in the formula. (Remember, what goes around […]

Continue reading

Excel Chart Shortcut Key

Charts , Excel , Shortcuts , Tips

Using an Excel chart shortcut key makes it quick and easy to create and view a chart. If you like what you see, then you can just as quickly move it to any worksheet you select. To quickly create a chart in Excel, select a cell in the data you want charted. If the block […]

Continue reading