Digital Art Zone

 
   
1 of 2
1
OT excel questions
Posted: 11 September 2012 04:31 PM   [ Ignore ]
Addict
Avatar
RankRankRankRank
Total Posts:  7990
Joined  2004-07-21

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.

 Signature 

Hello, Sweetie!
click me to save my dragon eggs

Who is cuter Loki or Thor?


Play Runescape

Profile
 
 
Posted: 11 September 2012 04:37 PM   [ Ignore ]   [ # 1 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  8697
Joined  2007-11-06

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

 Signature 

PostgreSQL CMS FAQ

Product Updates: Non-Genesis/G2 DIM Zips starting July 2013
Non-Genesis Items with Metadata
Plugin Version Numbers for DS 4.5
Updated Genesis Products

Profile
 
 
Posted: 11 September 2012 05:45 PM   [ Ignore ]   [ # 2 ]
Addict
Avatar
RankRankRankRank
Total Posts:  7990
Joined  2004-07-21

Thanks!


My first project in Excel is to make a calendar.

 Signature 

Hello, Sweetie!
click me to save my dragon eggs

Who is cuter Loki or Thor?


Play Runescape

Profile
 
 
Posted: 11 September 2012 05:54 PM   [ Ignore ]   [ # 3 ]
Addict
Avatar
RankRankRankRank
Total Posts:  7990
Joined  2004-07-21

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

 Signature 

Hello, Sweetie!
click me to save my dragon eggs

Who is cuter Loki or Thor?


Play Runescape

Profile
 
 
Posted: 11 September 2012 09:13 PM   [ Ignore ]   [ # 4 ]
Member
Avatar
Rank
Total Posts:  228
Joined  2004-09-11
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)

Image Attachments
Captureexcel1.JPG
 Signature 

MY DAZ STORE
PicoBytes game

Profile
 
 
Posted: 11 September 2012 09:43 PM   [ Ignore ]   [ # 5 ]
Power Member
Avatar
RankRankRank
Total Posts:  1749
Joined  2012-04-14

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

Profile
 
 
Posted: 12 September 2012 04:59 AM   [ Ignore ]   [ # 6 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  15980
Joined  2003-10-09

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.

 Signature 

Chohole’s Space        Neil’Vs Freebies and stuff        Autumn Bryce Rendering Challenge        September Freebie Challenge
My DAZ 3D Gallery    11915

Profile
 
 
Posted: 13 September 2012 03:31 AM   [ Ignore ]   [ # 7 ]
Active Member
Avatar
RankRank
Total Posts:  820
Joined  2007-01-08

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”))

Profile
 
 
Posted: 13 September 2012 05:45 AM   [ Ignore ]   [ # 8 ]
Addict
Avatar
RankRankRankRank
Total Posts:  7990
Joined  2004-07-21

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.

 

 Signature 

Hello, Sweetie!
click me to save my dragon eggs

Who is cuter Loki or Thor?


Play Runescape

Profile
 
 
Posted: 13 September 2012 07:19 AM   [ Ignore ]   [ # 9 ]
Member
Rank
Total Posts:  142
Joined  2010-02-05

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

Profile
 
 
Posted: 13 September 2012 04:08 PM   [ Ignore ]   [ # 10 ]
Addict
Avatar
RankRankRankRank
Total Posts:  7990
Joined  2004-07-21
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.

 Signature 

Hello, Sweetie!
click me to save my dragon eggs

Who is cuter Loki or Thor?


Play Runescape

Profile
 
 
Posted: 13 September 2012 07:37 PM   [ Ignore ]   [ # 11 ]
Member
Rank
Total Posts:  142
Joined  2010-02-05

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

Profile
 
 
Posted: 14 September 2012 04:27 AM   [ Ignore ]   [ # 12 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  15980
Joined  2003-10-09

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.

 Signature 

Chohole’s Space        Neil’Vs Freebies and stuff        Autumn Bryce Rendering Challenge        September Freebie Challenge
My DAZ 3D Gallery    11915

Profile
 
 
Posted: 14 September 2012 05:22 AM   [ Ignore ]   [ # 13 ]
Addict
Avatar
RankRankRankRank
Total Posts:  7990
Joined  2004-07-21
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:

Image Attachments
emailproblemwithforumin092012.jpg
 Signature 

Hello, Sweetie!
click me to save my dragon eggs

Who is cuter Loki or Thor?


Play Runescape

Profile
 
 
Posted: 14 September 2012 06:06 AM   [ Ignore ]   [ # 14 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  15980
Joined  2003-10-09

Ah, OK   sorry I didn’t realise.

 Signature 

Chohole’s Space        Neil’Vs Freebies and stuff        Autumn Bryce Rendering Challenge        September Freebie Challenge
My DAZ 3D Gallery    11915

Profile
 
 
Posted: 14 September 2012 06:22 AM   [ Ignore ]   [ # 15 ]
Addict
Avatar
RankRankRankRank
Total Posts:  7990
Joined  2004-07-21
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.

 Signature 

Hello, Sweetie!
click me to save my dragon eggs

Who is cuter Loki or Thor?


Play Runescape

Profile
 
 
   
1 of 2
1