Quiz gia excel

[bundy]

Έχω στο excel ένα πίνακα 1 2 3 4 5 6

7 8 9 10 11 12

8 4 6 2 7 5

.

.

και θέλω όλες οι γραμμές η μια μετά την άλλη να γίνουν μια στήλη

δηλ

1

2

3

4

5

6

7

8

.

.

.<p>γίνεται αυτό κάπως?

[accrual]

Macro & Visual BASIC

[bundy]

telika vrika mia poly diestramenh lysh

mesw excel-access-word-excel

mporei na th skeftei kaneis?

[Trelius]

Fainetai pws auto pou theleis na kaneis prepei na to kanei h Function Transpose() tou Excel. Dokimase thn

[bundy]

ksereis pos xrisimopoihtai ayti h synartisi?

mallon prepei na oriseis kapoio pinaka

Den katafera na ton orisw giati mou zitaei na orisw sthles grammes....

[Trelius]

<blockquote><font size="1" face="Verdana, Helvetica, sans-serif">quote:</font><hr>Originally posted by bundy:

<strong>ksereis pos xrisimopoihtai ayti h synartisi?

mallon prepei na oriseis kapoio pinaka

Den katafera na ton orisw giati mou zitaei na orisw sthles grammes....</strong><hr></blockquote><p>Den thn exw xrhsimopoihsei alla tha vreis paradeigma edw http://www.zdnet.com/pcmag/pctech/content/solutions/ss1716a.htm

[bundy]

Eyxaristw file

telika prepei na pathseis ctrl+shift+enter anti gia enter

alla ayth h synarthsh apla metatrepei ena pinaka ston anastrofo

Egw thelw oles oi grammes na ginoyn 1 sthlh<p>H lysh einai poly pontiakh:

1)kaneis import ton pinaka sthn access

2)dhmiourgeis report poy na exei ta pedia to ena katw apo to allo

3)ta kaneis export to word

4)paste sto excel