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
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Jan 29, 2018

Abdullah,

 

No matter if the content of the row is formulas or values!

 

Follow these steps:

  • Select the row and copy it.
  • Go to another location and press Ctrl+Alt+V to open the paste special dialog box.
  • Select Transpose and hit OK.

 

 

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

Thanks Haytham for your feedback

I wish it's that easy, Please check below snapshots for more information.

 

 

In column D all cells are a formula ='Abdullah'!B27

When I copy them to paste in another sheet [with the same steps you shared] it won't work as they are a formula, Please check below.

 

Hope it's clear now :)

 

Thanks,

Resources