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