Copying and pasting

[st3ady]

I am trying to make a simple Attendance Sheet for my company. At the top of each Person there is a row that says the Month and Year, which I want to stay the same. 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. I am using Excel 2000.

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

[VBA Noob]

Hi,

Try copy then select your destination cell and right click and choose paste special values.

To get to the last cell press where cursor is try Ctrl + the down arrow

this link has more shortcut keys

http://www.cpearson.com/excel/ShortCuts.htm

VBA Noob