Stupid Question about Microsoft Excel

yoviher

TCS Member
Thread starter
Top Cat
Joined
Jan 24, 2004
Messages
1,414
Purraise
1
Location
Puerto Rico... land of rice and beans.
My father has, in one of his investigations for the doctorate compiled a series of Excel databases of the baptisms that took place in the town of LoÃ:censor:za in northeastern Puerto Rico during the 19th century. Its every five years.

He needs to unite them all in a single Excel workbook, so as to make a graph defining the amout of births, male and female, black, white, slave, and so on every five years and its growth.

And I bring the totals of the first year in question, 1865. I get all the total births for that year pasted into the first row. There's like a hundred, and then divided by category, like sex, skin color, slave or free, and such.

I then try to paste into the second row the values for the year of 1870. There's like 60 births there, divided by category. But once I paste them, I get all those numbers of the year of 1870 turned down to zero! And I haven't yet found a way to figure it out. And they expect me to figure it out (When you live with two parents that need to be walked-through Microsoft Word, thats what you get). And I am not too good about Excel.

Anyone know how to figure this one out?
 

misscharlotte

TCS Member
Top Cat
Joined
Oct 19, 2003
Messages
1,205
Purraise
2
Location
Annville, PA
I'm not briiliant when it comes to Microsoft Excel but have you tried Paste Special instead of Paste? When you use Paste Special, you can specify to paste all functions and formulas.
 
Top