Digital Art Zone

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.

In 2007 View > Freeze Panes has an option to freeze top row.  I don’t recall the syntax offhand for a list of values.

Thanks!

My first project in Excel is to make a calendar.

I hid two columns but now i do not want them hidden.  How do I select them to unhide them?

Miss Bad Wolf - 11 September 2012 05:54 PM

I hid two columns but now i do not want them hidden.  How do I select them to unhide them?

I have Office 2010; but I think the procedure for 2007 is similar:

To display hidden columns, select the columns adjacent to either side of the columns that you want to unhide.
Right click and select unhide from the menu.  (see attached)

Microsoft has a bunch of training on their website as well, if you get some time to look there: http://office.microsoft.com/en-us/training/excel-2007-training-courses-HA010218987.aspx

MBW I had a word with someone who is qualified to teach excel (amongst other things) and he says that what you want to do is not easy if you don’t know the basics of setting up spread sheets in excel.  He does say much the same as Anikad, find some basic training tutorials on line and go forward from there. What you want to do is one of the advnaced formulas. Even he would have to go dig up his old notes to find it, which is why he says that you should find some basic on line tuts.

I used Excel spreadsheets a lot when I was working, and I would have trouble thinking back to working this one out, as it is not something I used really.

Just plug another if inside the first one:
=if(A1=1;“Condition 1 is True”;if(A1=2;“Condition 2 is True”;“Neither condition is true”))

I know of the concept of nested if then else statements.

Thanks!  now I see the code to make the if then else statement, that is what I needed to know.

I’m much better at Excel than I am with 3D programs. Feel free to email me with any questions. Also search Microsoft’s website, they do have some Calendar templates which may or may not contain the functionality you’re looking for.
Rick

ragaray - 13 September 2012 07:19 AM

I’m much better at Excel than I am with 3D programs. Feel free to email me with any questions. Also search Microsoft’s website, they do have some Calendar templates which may or may not contain the functionality you’re looking for.
Rick

Would love to email you but I do not have your email address.  Can you pm me your email address please?

I think you would need it in format username at hostname dot com as the forums are still not posting email addresses.

PM sent.
Sorry about that, I know some forums allow users to send emails through the boards.

Yes.  If the person has allowed their email address to de displayed, all a person needs to do is click the profile button beneath a persons avatar, if you can see an email button there, then you can email the person.

You do not actually see the email address of the person you are sending the email to, but obviously they will see yours when they receive the email, and can then reply to you, if they want to.

chohole - 14 September 2012 04:27 AM

Yes.  If the person has allowed their email address to de displayed, all a person needs to do is click the profile button beneath a persons avatar, if you can see an email button there, then you can email the person.

You do not actually see the email address of the person you are sending the email to, but obviously they will see yours when they receive the email, and can then reply to you, if they want to.

That function does not work for me.  Every time I have tried that method I get this error:

Ah, OK   sorry I didn’t realise.

chohole - 14 September 2012 06:06 AM

Ah, OK   sorry I didn’t realise.

I do not think that regular forum members can use that feature or at least I cannot.  You are a forum admin so you have more privileges than most people here.