Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

When a row of data is to be converted into columns

A) Copy the cells in row, select the same number of cells in columns and paste

B) Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK

C) Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click

OK

D) Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark

Transpose check box and click OK

Microsoft Excel Microsoft Office MS Office tools ICDL
user-image
Question added by FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials
Date Posted: 2015/05/17
Upvote (3) Views (33) Followers (8) Answers (7) Report Question
Write an Answer
Register now or log in to answer.
Ahmed Maher allam
by Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions

Right clik Copy then right click and choose transpose the fourth option under paste 

Vina Sankaranarayanan
by Vina Sankaranarayanan , Operation Executive , BNY Mellon PVT LTD

Answer is------------- option B)

FITAH MOHAMED
by FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials

B) >>>>>>>>>>>>>Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK

Bijumon Chandrahasan
by Bijumon Chandrahasan , Sr. Payroll and Compensation Officer , TRICONSTRUCT WLL - QATAR

B) Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK

Deleted user

B) .............................. is the correct answer

Jithin kumar

a) copy the cells in row,select the same number of cells in columns and paste

Deleted user

Copy the range of cells in a row , go to the cell where you want to paste data,right click on that cell  select tarnspose option or  press 'ctrl+alt+ v' then select transpose & then press enter....

Write Your Answer
More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.

Get Help