I want to use excel which came with the office that I bought for my computer. I have office 2003 and office 2007.
Question 1: How can I make at least one of the rows always stay up on top and have the rest of the rows be scrollable? I want one row to be the header with what each column means and always stay on time. I want to be able to scroll the data but keep the header on top.
I am looking up info, but how do I do if true or else statements that are complex. like: if certain cell equals 1, 3,5,7,8,10,or 12; this cell equals 1 else if certain cell equals 4,6,9,or 11; this cell equals 2, else this cell equals 3. or something like that.
I will use this thread to ask questions about excel or other office questions.