Absence Tracking (97-2000)

Hey there,

We have a pretty big company here, and I was assigned the task of creating an absence tracking spreadsheet to be used for 2007. I found a great template on microsoft's office website, but it is made for 2005.

you can download it here:
http://office.microsoft.com/en-us/te...561561033.aspx

And now for my n00by questions: I am trying to change where it says 2005 in each employee row to 2007. Simple enough right? Well when I copy and paste, it automatically changes the 2007 to 2008, 2009, 2010, and so forth. How can I make this value remain the same all the way down? It also automatically changes the month name to the next one, so if I copy and paste a row with January in it, the next one will be February and so on.

Also, is there a way to do the replace function across all sheets at once?

Also, I get frustrated when I have to get to the bottom of a spreadsheet with a ton of data in it, I click on the scroll bar on the right and pull down and I drag down, and I either go too far or not far enough, is there a quick and easy way to get to the last row? Thanks for any help

The quick way to select all the data in a contiguous column is to hold down the shift key and while hitting end and then the down arrow.

Another useful one is control-shift-8 which selects al the data in a block

I could reproduce the probelm with the dates, it sounds like there might be a formula in your copy which I can't see in mine.