Susan, I forgot to tell you, not to forget to turn your numlock off on completion. Sean -----Original Message----- From: vip_students-bounce@xxxxxxxxxxxxx [mailto:vip_students-bounce@xxxxxxxxxxxxx] On Behalf Of Susan Curry Sent: 17 September 2009 12:44 To: vip_students@xxxxxxxxxxxxx Subject: [vip_students] Re: shortcuts in excel hi sean, i'll give this a go and let you know how i get on. many thanks for that. susan ----- Original Message ----- From: "Sean Kavanagh" <seany2@xxxxxxxxxx> To: <vip_students@xxxxxxxxxxxxx> Sent: Wednesday, September 16, 2009 7:11 PM Subject: [vip_students] Re: shortcuts in excel > Ahoy Susan > > Prior to using the short cut keys for subtraction, multiplication or > division, you must first of all turn your numlock on. This is the key on > your numeric key pad situated above the number 7! > > Like in your addition, ensure that the curser is in the cell in which you > require the answer to appear! > > To subtract: > Hold down your left "alt key" & press =! > Then type in your cell with the greater figure e.g. A1! > Then press the "dash key" located above the plus or pc curser! > Then type in your lesser cell e.g. A2 and press enter! > > To Multiply: > Hold down left "Alt key" & press =! > Type in your first cell e.g. B2! > Then press the "Star key" next to your - or minus key! > Then type in your multiplication cell e.g. B3 & press enter! > > Division: > Again hold down the left "Alt key" & press =! > Type in your cell with the amount you are going to divide e.g. C8! > Then press the "slash key" next to the numlock key! > Then type in your division cell e.g. C9 & press enter! > > Hope this makes sense! If not you may contact me off line, my email > address > is seany2@xxxxxxxxxx & if needs be I will contact you via land line. > > Sean > > > The short keys to sub > > -----Original Message----- > From: vip_students-bounce@xxxxxxxxxxxxx > [mailto:vip_students-bounce@xxxxxxxxxxxxx] On Behalf Of Susan Curry > Sent: 16 September 2009 10:02 > To: vip_students@xxxxxxxxxxxxx > Subject: [vip_students] shortcuts in excel > > hi folks, > > to add up a list of figures in excel i use the shortcut keys alt, equals > and > > then enter, does any one know the short cut keys to subtract, multiply and > divide? > > many thanks > > susan > best wishes > > susan > > > -- > I am using the free version of SPAMfighter. > We are a community of 6 million users fighting spam. > SPAMfighter has removed 1615 of my spam emails to date. > Get the free SPAMfighter here: http://www.spamfighter.com/len > > The Professional version does not have this message > > > > > > -- I am using the free version of SPAMfighter. We are a community of 6 million users fighting spam. SPAMfighter has removed 1615 of my spam emails to date. Get the free SPAMfighter here: http://www.spamfighter.com/len The Professional version does not have this message