Excel

The UK's most regular instructor-led training courses.
Training information: best training · Microsoft-office-training uk-in

Resolved · Low Priority · Version 2007

2 posts

ReplyThu 23 Apr 2009, 15:42Delegate Yelena said...

Yelena has attended:
Dreamweaver 8 Introduction course

Excel

Can a table range be extended once set?

Version	Date	Location	Places available	Book	Next place rate (£)		List price
MOS/MCAS exam 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice	List price
2003	Wed 18 Aug 2010	Limehouse	3		£75	£75	£75

870 posts

ReplyFri 24 Apr 2009, 16:06Trainer Rajeev said...

RE: Excel

Dear Yelena

Thank you for attending Upgrade to Office 2007 course!! I hope you enjoyed the course and benefited from it.

Yes the Format as table facility normally does select the entire data in your range but if you want to include more data then you can simply start adding text on the right hand side of the last column or below the last row in the data table. You will observe that it will automatically include that within the data table.

But f you wish to include lots or rows and columns in the existing Format as Table facility before you start typing data
Then please scroll up to the last cell of the table and you should be able to see a blue dot on the bottom right hand corner. Drag that however many rows you would like to include and then drag to right to include however many columns you would like to include.

I hope this has answered your query.

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 post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Fri 1 May 2009: Automatically marked as resolved.

· Fill Your Skills Gap With Microsoft Office
· Automate Manual Tasks with Microsoft Office Macros
· Excel And Access, Working In Harmony
· How To Paste Without Slicing Your Fingers
· Office Keyboard Shortcuts: Universal & Specific

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

Microsoft office tip:

Prevent macros from running when you start Applications

Macros are automated programs that can help you speed up your work. They can be embedded in caommands like AutoExec which will make them run as soon as an application like MS Word or MS Access are launched.
Sometimes it is useful to be able to switch off this function, and then can be done by the following method.
Hold down the SHIFT key when you click on the icon to start the program. This will suppress any automated macros.

View all Microsoft Office hints and tips