Susan yes enter means <enter> David In message <000b01c527cf$7b03fe60$24a089d9@gaiacomputer>, Susan <susan.beggs@xxxxxxxxxxxx> writes >hi david >sorry, but when i enter the formula do i hit enter as nothing is happening >many thanks >susan >----- Original Message ----- >From: "David W Wood" <g3yxx@xxxxxxxxxxxxxxxxxxxxxxxxxxxx> >To: <jaws-uk@xxxxxxxxxxxxx> >Sent: Sunday, March 13, 2005 12:08 PM >Subject: [jaws-uk] Re: excel > > >Susan > >1. text to fit. >Select the columns in question. >Then from the menu choose >Format >columns >tab across to 'autofit' and press enter. >Job done. > >2. average. >If you want the average of a range of cells, in a cell remote from this >range enter the formula: >=avg(a10:b99). >Job done. >Do remember though, that their are three kinds of average in statistics. > >3. printing range. >Highlight your range. >Menu >file >print area. >You have then defined the area to print. >Having done this: >menu >file >print setup >and then define your preferences. > >David > > >In message <000901c527bb$2dbc2600$2ba089d9@gaiacomputer>, Susan ><susan.beggs@xxxxxxxxxxxx> writes >>hi >>can anyone help please? >>how do i find the average of any thing in excel? also how can i widen the >>cells >>to >>fit the text? >> >>if i only use the cells from a, to g, then go to print it out, how can i >>print >>it out >>without including the cells following g? >>then how can i print it out wherefore the cells i have filled is just on the >>print >>out and not just in one small corner of the page. >>Best Regards Susan. >> >>** To leave the list, click on the immediately-following link:- >>** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] >>** If this link doesn't work then send a message to: >>** jaws-uk-request@xxxxxxxxxxxxx >>** and in the Subject line type >>** unsubscribe >>** For other list commands such as vacation mode, click on the >>** immediately-following link:- >>** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=faq] >>** or send a message, to >>** jaws-uk-request@xxxxxxxxxxxxx with the Subject:- faq >> > -- David W Wood ** To leave the list, click on the immediately-following link:- ** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] ** If this link doesn't work then send a message to: ** jaws-uk-request@xxxxxxxxxxxxx ** and in the Subject line type ** unsubscribe ** For other list commands such as vacation mode, click on the ** immediately-following link:- ** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=faq] ** or send a message, to ** jaws-uk-request@xxxxxxxxxxxxx with the Subject:- faq