Highline Excel Class 15: Excel 2007 Tables 7 Examples

[prudhvirajreddyable]

amazing video

[ExcelIsFun]

@prudhvirajreddyable , Thanks!

[tomasek262]

Hi there, I have a table where I insert data manully. I need to create next table for exporting purposes which will automatically copy (load) data from original table. So when I insert a new line into the original table, it will create a new line in "exportable" table automatically. Is something like this possible? Thanks

[ExcelIsFun]

I am overwhelmed at work. No Time... Try:

mrexcel[dot]com/forum

There are 100s of people there who can help.

[tomasek262]

@ExcelIsFun Thank you

[ExcelIsFun]

You are welcome!

[6642633]

A TONS of Thanks and Stars

this have been very Helpfulllllllllll

[ExcelIsFun]

A TON of You Are Welcome!

Thanks for the 5 star rating!

[aman1245singh]

While formulating a cell and adding this formula, =sum(salestable01[sales])

what is the shortcut( if any) for getting a dialogue box showing the name of the tables which I can insert, like the f3 shortcut for inserting range names.

[ExcelIsFun]

I do not know of one. But as soon as you type the first few characters, you should see a drop-down with a list of functions, Defined Names and Table names.

[simabah]

Hi Mike,

What happens when you "convert to range"? what limitations will you face if you don't "convert to range"?

[ExcelIsFun]

"convert to range" makes it a range not a table. All benefits of table (except formatting) are gone. For example, no more dynamic ranges.

[MrShadabhussain]

Dear friend!

You did a noble job. God bless you and your loved ones

thanks indeed :)

[ExcelIsFun]

I am glad that you liked it.

[INGc3z4r]

Great tips thanks Mike!

[ExcelIsFun]

Dear INGc3z4r,

I am glad that you like them!

--excelisfun