Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 309
Default Why use tables??

I see that tables can easily format a big range of cells using
fancy multi-colored rows and column headers. Is there any
other benefit or reason for using such a table?? It seems to
me that I could manually format all my cells' colors and
borders....so, does that mean that a table is just a fast and
easy way to format a big range?? I'm just looking for
reasons why anybody would use tables (other than fast
formatting).

Thank you


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,510
Default Why use tables??

Hi Robert,

I assume that you mean in xl2007. The biggest advantatage I have seen is
that each table can have it's own separate Autofilter.

I will be monitoring this thread to see what others have to say.

--
Regards,

OssieMac


"Robert Crandal" wrote:

I see that tables can easily format a big range of cells using
fancy multi-colored rows and column headers. Is there any
other benefit or reason for using such a table?? It seems to
me that I could manually format all my cells' colors and
borders....so, does that mean that a table is just a fast and
easy way to format a big range?? I'm just looking for
reasons why anybody would use tables (other than fast
formatting).

Thank you


.

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default Why use tables??

http://www.jkp-ads.com/articles/Excel2007tables.asp

Regards,
Peter T

"Robert Crandal" wrote in message
...
I see that tables can easily format a big range of cells using
fancy multi-colored rows and column headers. Is there any
other benefit or reason for using such a table?? It seems to
me that I could manually format all my cells' colors and
borders....so, does that mean that a table is just a fast and
easy way to format a big range?? I'm just looking for
reasons why anybody would use tables (other than fast
formatting).

Thank you




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 376
Default Why use tables??

Robert
Take a look at the reply to your later posting

--
-------
Regards
Roger Govier

"Robert Crandal" wrote in message
...
I see that tables can easily format a big range of cells using
fancy multi-colored rows and column headers. Is there any
other benefit or reason for using such a table?? It seems to
me that I could manually format all my cells' colors and
borders....so, does that mean that a table is just a fast and
easy way to format a big range?? I'm just looking for
reasons why anybody would use tables (other than fast
formatting).

Thank you



__________ Information from ESET Smart Security, version of virus
signature database 4893 (20100224) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4893 (20100224) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4901 (20100227) __________

The message was checked by ESET Smart Security.

http://www.eset.com



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
concatenate tables into html tables urlocaljeweler Excel Discussion (Misc queries) 1 December 11th 09 08:15 PM
concatenate tables into html tables urlocaljeweler New Users to Excel 1 December 11th 09 06:30 AM
Pivot tables using multiple tables Gringarlow Excel Programming 5 March 24th 09 09:37 PM
Any way to programmatically make pivot tables behave more like data tables? Ferris[_2_] Excel Programming 1 August 24th 07 06:20 PM
Extracting/Exporting HTML Tables or PDF Tables into Excel [email protected] Excel Programming 3 July 25th 06 09:57 AM


All times are GMT +1. The time now is 03:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"