Posts Tagged ‘excel’

Easily Convert Formulas To Values

Saturday, January 24th, 2009

I often see Excel users who need to replace formulas with values doing it manually by typing the value in each cell. If you’re one of those people, I’ve got a much easier way for you — and less chance of making a costly or embarrassing mistake.

A quick and easy way to convert formulas to values, rather than using Paste Special… Values, is by dragging the edge of a cell or range using the right mouse button, dropping it where you want to paste the values (even back to the original cells), and select Copy Here As Values Only.

Position your mouse pointer over the edge of a selected range of cell. The pointer will change to a four-headed arrow.With your left-mouse button, click and drag away from then back to its original position.

It’s so simple!

Replace formulas with values in Microsoft Excel

Replace formulas with values in Microsoft Excel

Welcome to The Excel Addict Blog

Wednesday, January 14th, 2009
Francis Hayes (The Excel Addict)

Francis Hayes (The Excel Addict)

Hi, my name is Francis Hayes. I have been using Microsoft Excel for more than 18 years and have become ‘addicted’ to the almost unlimited potential it gives to anyone who does a little digging for its hidden gems.

Most Excel users just use it as a plain spreadsheet. I’m much more curious and adventurous. For the past 18 years, I have been uncovering Excel’s hidden secrets that open up a new world of possibilities that 95%+ of Excel users don’t know about.

Over the years, I became frustrated because of the attitude of most Excel users who continue using Excel as a ‘glorified calculator’ even after been shown some of it’s time-saving, money-saving, frustration-decreasing, accuracy-assuring features.

In 2003, to release some of my frustration, I created my own website,, and started publishing a FREE weekly newsletter, Spreadsheet Tips From An Excel Addict to share my knowledge with an audience of Microsoft Excel users who ARE interested in expanding their Excel knowledge.

After more than 7 years and 18,000+ subscribers, I decided to create this blog to further spread my message to those who may be looking for better and faster ways to do things in Excel and want to differentiate themselves from the other 95% of Excel users.

It may be hard to believe, but just the fact that you’re reading this blog tells me that you are in the top 5% of Excel users.

My passion is helping others discover the amazing power hidden in Excel. If you’re as passionate about Excel as I am, I hope you will come back to my blog regularly to learn some of the things I have discovered over 18 years of using Microsoft Excel and want to share with the world.

P.S. If you love Excel as much as I do, get my weekly newsletter and see how learning a few of these tips every week will, over time, make your productivity soar beyond what you’ve ever thought possible.

Sign up NOW for free at