Forum Discussion

abdullah.alduhaishi's avatar
abdullah.alduhaishi
Copper Contributor
Jan 29, 2018

Excel Challenge

Hi All, Your kind support appreciated with below Excel case... How to copy a raw [put in mind the row is formula and not a value] and paste it in another sheet as a column ? Since it's a formul...
excel
abdullah.alduhaishi's avatar
abdullah.alduhaishi
Copper Contributor
Jan 30, 2018

 

Thanks Haytham for your feedback :)

 

I wish it's that simple, please check below snapshot's for better understanding.

 

In column D, all cells are a formula [='GSM GAP'!G63], If I implement your shared steps the result won't appear, Please check below snapshot.

 

Hope it's clear now.

 

Thanks again for your help :)

 

Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Jan 30, 2018

I didn't know that the cells you have in column D are cell references!

 

In this case, you have two choices to choose one of them:

 

#1 Get rid of the formulas and paste them as values by just choosing Values option in addition to Transpose as the below screenshot:

 

 

 

#2 Before you apply the steps in the previous answer, do change the cell references in column D as follows:

Replace this: 

='GSM GAP'!G63

With this:

='GSM GAP'!$G63

Apply this change to all cells in column D, and then copy and paste into another location by following the steps in the previous answer.

  • abdullah.alduhaishi's avatar
    abdullah.alduhaishi
    Copper Contributor
    Jan 30, 2018
    Dear Haytham,
    BIG thanks from the hart,

    The first solution didn't work, so I used the second.

    2# didn't work but it gave me another way to do my task, so thanks a lot for your kind support.

    Best Regards,,,,

Resources