Category Archives for "Excel – Tips"

Speedup Excel VBA Macros with Protect UserInterFaceOnly

Excel , Excel - Tips

Many Excel macros run on protected worksheets. If you use the little piece of VBA code in this article they will run a lot faster. Let me give you an example. I just finished a very robust Return on Investment calculator that has seven sheets of data entry, revenue forecasts, and output reports. It uses […]

Read More

Find all Conditional Formatting on a Worksheet

Excel , Excel - Formatting and Reports , Excel - 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 […]

Read More

Amazing Artistry with Excel Drawing Objects!

Excel - Tips

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 […]

Read More

Make Small Changes to a Hand-Drawn Line

Excel - 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, […]

Read More

Quickly Change an Object’s Height or Width

Excel - 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.

Read More

Moving Objects a Small Amount

Excel - 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.

Read More

Select and Change Some Objects on a Worksheet

Excel - 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 […]

Read More

Inserting Multiple Lines (Line Breaks) in a Cell with Alt+Enter

Excel - Tips

I bet every Excel user has had it happen. You want to type a long line or paragraph in a cell and you press Enter to break line. Instead it enters the text in the cell. Without reformatting the cell for wrap text there’s a quick way to break a line and wrap it in […]

Read More

Adding the Developer Tab to the Excel Ribbon

Excel , Excel - Tips

Reading this will teach you one of the secret incantations need to move from mid-level Excel user to Excel power user. Hidden to the eyes of novice and mid-level Excel users is the Developer tab. It holds tools that give you extra Excel power – the power to add check boxes to turn IF statements […]

Read More