Excel 2007

The UK's most regular instructor-led training courses.
Training information: excel-courses-london · Excel courses · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Excel 2007

Jacob has attended:
Excel Introduction course

by - delegate Jacob [1 post] (2008 Mar 10 Mon, 16:48) Reply

How can I add cells quickly without typing in each indivdual cell?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	5	book now	£219	£235
2003	2008 Sep 17 Wed	Southwark	0	FULL
2003	2008 Sep 17 Wed	Bayswater	5	book now	£195	£205
2003	2008 Sep 19 Fri	Bloomsbury	6	book now	£214	£230
Full Schedule: See all 125 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Excel 2007

by - trainer Mark gold contributer [180 posts] (2008 Mar 14 Fri, 13:58) Reply

Hi Jacob

thank you for coming on the course hope you enjoyed things

Now the answer to your question is as follows, you can do this by using a fill command which will help you out. To do this make sure you have the cell you want to copy down or accross, then move to the bottom right hand corner of the cell where the black box is, then click and drag to fill the formula down

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please click reply or post it as a new question and we should be able to answer that!!

Hope this helps you

Many Thanks

Mark East
mark@microsofttraining.net

· Compare Different MS Excel Training Methods
· How to check for and reduce errors in Microsoft Excel
· Microsoft Excel Training: Not Just for Newbies Anymore
· Microsoft Excel Features and Functions for Accountants
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel

Please browse our web site to find out more about
excel-courses-london and other Microsoft training courses.

Excel tip:

Counting Non Number Cells (Text)

If you try to use the COUNT FUNCTION =COUNT(Cell range)with a range of cells with numbers and or containing text fields you wil find that that the text cells will be excluded from the the count. If you want to include them try the the COUNTA FUNCTION =COUNTA(Cell range). This counts both text and number cell values.

View all Excel hints and tips