ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I use dynamic table in excel 2007? (https://www.excelbanter.com/excel-discussion-misc-queries/160476-how-can-i-use-dynamic-table-excel-2007-a.html)

Ricardo Bertoncello

How can I use dynamic table in excel 2007?
 
I was used to use dynamic table in the excel 2003, but I can't find the way
in the excel 2007. Anyone could help me?

Kind regards

Bernard Liengme

How can I use dynamic table in excel 2007?
 
From Help in Excel 2007:

Creating a table
1.. On a worksheet, select the range of empty cells or data that you want
to make into a table.
2.. On the Insert tab, in the Tables group, click Table.


3.. If the selected range contains data that you want to display as table
headers, select the My table has headers check box.
Table headers display default names that you can change if you don't
select the My table has headers check box.

Note After you create a table, the Table Tools become available, and a
Design tab is displayed. You can use the tools on the Design tab to
customize or edit the table.

Does this help?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Ricardo Bertoncello" <Ricardo wrote
in message ...
I was used to use dynamic table in the excel 2003, but I can't find the
way
in the excel 2007. Anyone could help me?

Kind regards







All times are GMT +1. The time now is 02:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com