The Paste Special: Values Function

 If you use Excel to create formulas, you will inevitably need to move the data result of those formulas somewhere else. We spoke a little about this in the “Holding Down the Fort – Anchors” post, but in that post what we actually did was move the formula (when we move a formula, as long as its anchored, we move the result also).

But what if you want to move ONLY the data, WITHOUT    the formula? This is where the “Copy & Paste Special - VALUES” comes in to play. By copying the formulas, then selecting the Paste Special option, you can select Values from the dialog box and paste only the result.

Throughout the years and the different versions of Excel, there have been different methods of accessing the Paste Special dialog box. Some have a button the tool bar, while others don’t. Since I don’t know which version you have, there is one method to access the Paste Special dialog box that works with all versions: Alt+E+S. (I find it quicker this way anyway!)

To use this shortcut and go directly to the Past Values function, just add a V to that shortcut: Alt+E+S+V. Striking the Enter Key (or clicking the OK button) will apply your selection (Values) and you will then have removed all the formulas while keeping the values.


Keep Excelling!

Do you like this post? Comment below and / or share on Facebook or Twitter!

Going Places? - Hyperlinks

Do you have cells with hyperlinks? Maybe it's an email address or a web address in a cell that you need to change. Editing that cell is not as easy as simply clicking on it! You see, if you simply click on a cell with a hyperlink, it will open that hyperlink! Excel will open you browser and take you to that website, or open up your email client to send an email to that email address!

There are three ways that quickly come to mind to actually select that cell without activating the hyperlink.

The first method I suggest is based on our Using the Name Box blog post. Just type the address of the cell you want to edit in the name box, and Excel will take you there.

The second method I suggest is to simply click the cell beside that one and navigate using your keyboard arrows to the cell that contains the hyperlink.

The third method is using your mouse cursor to click the cell, but don't simply click it - click and hold it for a few seconds. This will bypass the hyperlink activation and allow you to select the cell.

As you can see, Excel is VERY versatile. There is usually more than one way of doing something. Have you found any different way of getting around this? Leave a comment below and let us know!

Keep Excelling!

Do you like this post? Comment below and / or share on Facebook or Twitter!

My Favorite Excel Function

OK, let’s get down to some Excel business. This post will focus on my absolute favorite Excel shortcut. You'd think that for someone like me who uses Excel extensively day in and day out it'd be something extravagant; NOPE! My favorite Excel function is simply "Ctrl-z"; the "undo" function! If I had a nickel for every time this nifty little function has saved my behind, I'd be a rich man! 

Sure you can easily grab your mouse and click on the "Undo Arrow" or even click on Edit / Undo