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 addressis 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 andthen 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