Have you ever had a scenario where you write a formula and just want to show the value output only and get rid of the formula?

Here is an example of a formula:


Well I do not need the formula, bit I do want the last names only….hard copied!

Fortunately, I have discovered two ways that you can achieve this…



STEP 1: Select the area that contains the formulas.

Click CTRL+C

On the column that you want to place the values on, right-click and select Paste Values: 

You can see that the actual values are now stored in that column!


STEP 2: Here’s an alternative way.  Select the area that contains the formulas.

Right-click and hold on the right border.

Drag the border, whilst holding down the right-click on your mouse, to the area you want the values to be placed in.

Select Copy Here as Values Only.

You now have the actual values hardcoded!



If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

WEEKDAY function: Introduction The WEEKDAY function returns the day of the week corresponding to a date.  The day is given as an integer, ranging from 1 (Sunday) to 7 (Saturday).So if you want to find out on what day you were born, then the WEEKDAY function will remind you.DOWNLOAD WORKBOOKHelp...
Excel´s TEXT Function The TEXT function in Excel allows you to convert a numeric value to a specific format by using special format strings.If you have a date and want to show just the month or if you have a large number and want to show it in a thousands format , then the TEXT function is your sa...
In-Cell Bar Charts with the REPT Function When you are creating an Excel Dashboard and are limited by space and do not want to insert a chart, you can easily create an in-cell bar chart using the RPT (repeat) function.The RPT function uses the vertical bar character | as the first argument: text and references the va...
SUMIF Function: One Criteria & Sum Range The SUMIF function can also be used to apply the criteria to one range and sum the corresponding values in a different range.So if you have a list of Sales Reps in one list and their Sales in another list and want to Sum the sales of only one of the Sales Reps, then the SUMIF...