How to paste exact value into another cell?
 

I am curious if there is an easier way to paste an exact value into an
adjacent column. Currently, I am using the paste special function but this
is tedious? Is there a keyboard shortcut to do this? For example, column 1
has a value which is derived from a formula (x * 12 months) and I want
columns 2-6 to have the same value as column 1. If you copy and past the
value, it will update the formula for that column. Any advice?

How to paste exact value into another cell?
 

I have created a spreadsheet named quickPaste.xls in
http://www.HelpExcel.com/examples
--
http://HelpExcel.com




"Lewis0205NC" wrote:

I am curious if there is an easier way to paste an exact value into an
adjacent column. Currently, I am using the paste special function but this
is tedious? Is there a keyboard shortcut to do this? For example, column 1
has a value which is derived from a formula (x * 12 months) and I want
columns 2-6 to have the same value as column 1. If you copy and past the
value, it will update the formula for that column. Any advice?

How to paste exact value into another cell?
 

Your question isn't very clear. What is the formula in column 1 (do you mean
column A?)? Does it refer to one of the columns into which you are trying to
paste the value? What formula updates when you paste special values?

A little clarity from you will likely generate a helpful response.


"Lewis0205NC" wrote:

I am curious if there is an easier way to paste an exact value into an
adjacent column. Currently, I am using the paste special function but this
is tedious? Is there a keyboard shortcut to do this? For example, column 1
has a value which is derived from a formula (x * 12 months) and I want
columns 2-6 to have the same value as column 1. If you copy and past the
value, it will update the formula for that column. Any advice?

How to paste exact value into another cell?
 

This is exactly what I was wanting to do but how did you paste the values in
the other columns?

"galimi" wrote:

I have created a spreadsheet named quickPaste.xls in
http://www.HelpExcel.com/examples
--
http://HelpExcel.com




"Lewis0205NC" wrote:

I am curious if there is an easier way to paste an exact value into an
adjacent column. Currently, I am using the paste special function but this
is tedious? Is there a keyboard shortcut to do this? For example, column 1
has a value which is derived from a formula (x * 12 months) and I want
columns 2-6 to have the same value as column 1. If you copy and past the
value, it will update the formula for that column. Any advice?

How to paste exact value into another cell?
 

Right-click on the Sheet1 tab and "View Code"

The copy/pasting is done with event code.

I would add one more line to the code after Target.Select

Application.CutCopyMode = False


Gord Dibben MS Excel MVP

On Wed, 17 Jan 2007 12:51:01 -0800, Lewis0205NC
wrote:

This is exactly what I was wanting to do but how did you paste the values in
the other columns?

"galimi" wrote:

I have created a spreadsheet named quickPaste.xls in
http://www.HelpExcel.com/examples
--
http://HelpExcel.com




"Lewis0205NC" wrote:

I am curious if there is an easier way to paste an exact value into an
adjacent column. Currently, I am using the paste special function but this
is tedious? Is there a keyboard shortcut to do this? For example, column 1
has a value which is derived from a formula (x * 12 months) and I want
columns 2-6 to have the same value as column 1. If you copy and past the
value, it will update the formula for that column. Any advice?