Managing Look of Tables

Table Filter macro allows you to fit your large tables to your screen area, hide the unnecessary table columns and apply static or dynamic row numbering

Fitting table to the screen area

Please note that Table Filter macro allows you to automatically fit long tables to your screen area.

Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro.

	First Name	Last Name	Transaction amount	Target Transaction City	Target Transaction Country	Customer Status	Suspicious Transaction Activity	Total Transaction Number

	First Name	Last Name	Transaction amount	Target Transaction City	Target Transaction Country	Customer Status	Suspicious Transaction Activity	Total Transaction Number
1	Reuben	Barnett	$129.42	Guápiles	Tunisia	Blocked	Yes	8
2	McKenzie	Cleveland	$216.75	Savannah	United States	Blocked	Yes	1
3	Portia	Lang	$422.53	Meerut	Côte D'Ivoire (Ivory Coast)	Rejected	No	5
4	Eagan	Mcgee	$253.03	Orangeville	Afghanistan	Approved	No	2
5	Rahim	Velazquez	$454.06	Lac-Serent	Georgia	Approved	Yes	6
6	Roth	Hull	$142.57	Luziânia	Sao Tome and Principe	Blocked	No	4
7	Jack	Griffin	$146.60	Georgia	Bahamas	Blocked	No	4
8	Faith	Newton	$324.96	Okigwe	Sri Lanka	Rejected	Yes	1
9	Basia	Ray	$260.39	Valcourt	Equatorial Guinea	Rejected	Yes	4
10	Leandra	Duncan	$380.33	My	Swaziland	Rejected	No	6
11	Cameran	Velasquez	$144.75	Schiltigheim	Bangladesh	Rejected	Yes	8
12	Amery	Poole	$418.48	Zolder	Azerbaijan	Rejected	Yes	1
13	Owen	Welch	$279.12	Springdale	Benin	Rejected	Yes	4
14	Germaine	Hines	$347.08	Bellingen	Algeria	Approved	No	6
15	Thane	Cortez	$338.56	Penrith	Tunisia	Approved	Yes	1
16	Sean	Delacruz	$421.67	Vietri di Potenza	Libya	Rejected	No	4
17	Willow	Skinner	$216.70	Ham-sur-Sambre	Venezuela	Approved	No	1
18	Camilla	Good	$311.10	Saint-Hilarion	Malawi	Rejected	No	7
19	Ingrid	Horne	$365.20	Crato	Dominica	Approved	Yes	4
20	Claire	Raymond	$126.99	Wieze	Western Sahara	Blocked	Yes	9
21	Akeem	Holder	$131.59	Sutton	Samoa	Blocked	Yes	7
22	Yuli	Hubbard	$107.57	Hudson Bay	Bolivia	Rejected	No	4
23	Gregory	Sampson	$339.91	Stroud	Mozambique	Blocked	No	1
24	Freya	Osborn	$198.86	Rexton	Luxembourg	Approved	Yes	5
25	Kylan	Dillard	$264.70	Market Drayton	Yemen	Rejected	No	3
26	Curran	Dickson	$360.20	San Francisco	Saint Martin	Blocked	No	7
27	Sylvester	Campos	$338.44	Riparbella	Armenia	Blocked	Yes	5
28	Hadley	Gates	$363.39	Chelmsford	New Zealand	Rejected	Yes	7
29	Willa	Stevens	$137.89	Glabais	Japan	Approved	No	2
30	Keelie	Byers	$236.10	Cavaion Veronese	Palestine, State of	Approved	No	3
31	Jordan	Weber	$249.33	Shepparton	Anguilla	Blocked	Yes	9
32	Karly	Walls	$200.81	Charlottetown	Guatemala	Approved	Yes	7
33	Octavius	Cervantes	$235.63	Merksem	Dominica	Approved	Yes	4
34	Tyrone	Alvarez	$303.65	Thame	Iraq	Blocked	Yes	5
35	Jolene	Howe	$321.67	Maple Creek	Togo	Blocked	No	3
36	Cody	Ross	$219.44	Gent	Austria	Blocked	Yes	6
37	Chase	Bryant	$493.65	Moustier-sur-Sambre	Czech Republic	Approved	No	9
38	Lynn	Cummings	$484.17	Metairie	Liechtenstein	Approved	No	3
39	Lars	Shaw	$170.60	Pittsburgh	British Indian Ocean Territory	Rejected	No	4
40	Cassidy	Porter	$142.39	Saint-Maur-des-Fossés	Zambia	Approved	Yes	3
41	Whilemina	Goodwin	$255.81	Amaro	Guinea	Rejected	No	3
42	Jordan	Mullen	$151.41	Alajuela	Eritrea	Approved	No	9
43	Curran	Bond	$207.97	Wattrelos	Belize	Approved	Yes	4
44	Shad	Shelton	$177.90	Salt Lake City	Estonia	Rejected	No	4
45	Eve	Hines	$113.99	Montpellier	Netherlands	Rejected	No	7
46	Amir	Odom	$203.43	Manavgat	Albania	Blocked	Yes	5
47	Evan	Coffey	$489.53	Prince Albert	Brunei	Rejected	No	5
48	Quynn	King	$393.43	São Luís	Chile	Blocked	No	9
49	Ivy	Alvarado	$198.75	Guwahati	Cape Verde	Approved	No	2
50	Seth	Vasquez	$333.66	Greater Hobart	Malaysia	Blocked	No	3
51	Guy	Cotton	$168.20	Saint-Pierre	Denmark	Blocked	No	4
52	Xyla	Spears	$368.74	Jamoigne	Guernsey	Rejected	No	2
53	Haviva	Hancock	$136.33	Chelsea	Zimbabwe	Approved	No	5
54	Juliet	Barlow	$326.73	Solingen	Iran	Approved	Yes	7
55	Kay	Cole	$158.75	Clare	Netherlands	Approved	Yes	2
56	Zenaida	Kirkland	$315.19	Yellowhead County	Mongolia	Blocked	No	4
57	Ryan	Ware	$367.76	Tuticorin	Armenia	Rejected	Yes	8
58	Maite	Lowe	$256.17	Muno	Poland	Blocked	No	1
59	Sandra	Schultz	$273.51	Nampa	Colombia	Approved	Yes	9
60	Karina	Horton	$443.37	Esslingen	Taiwan	Rejected	Yes	2
61	Lysandra	Black	$322.36	Strombeek-Bever	Swaziland	Blocked	Yes	8
62	Alden	Buckner	$249.18	San Marcello Pistoiese	Hungary	Blocked	No	1
63	Levi	Nolan	$478.53	Chambord	Ukraine	Rejected	No	7
64	Buckminster	Ewing	$239.77	Haren	Argentina	Blocked	No	1
65	Aidan	Henson	$340.93	Valpelline	Jersey	Approved	No	3
66	Howard	Crosby	$201.61	Chambave	Cameroon	Blocked	No	2
67	Ginger	Castro	$473.40	Isle-aux-Coudres	Latvia	Approved	No	4
68	Hyatt	Mullins	$450.40	Oldenzaal	Slovenia	Rejected	No	4
69	Rachel	Head	$166.15	Bautzen	Nauru	Blocked	No	7
70	Shoshana	Underwood	$336.12	Parkland County	Liechtenstein	Blocked	No	2
71	Colt	Kent	$482.74	Jalgaon	Grenada	Approved	Yes	3
72	Amethyst	Dunn	$313.64	Dipignano	Western Sahara	Approved	Yes	9
73	Plato	Duke	$229.55	Exeter	India	Blocked	Yes	1
74	Jared	Dale	$391.90	Béziers	Mauritius	Approved	Yes	3
75	Luke	Vang	$375.44	Vorselaar	Jersey	Blocked	Yes	1
76	Phillip	Reed	$431.70	Chittoor	Christmas Island	Approved	Yes	6
77	Brandon	Lowery	$213.54	Cork	Chad	Rejected	Yes	1
78	Rafael	Elliott	$281.05	Little Rock	Jamaica	Approved	Yes	4
79	Lyle	Black	$437.51	Mold	Palau	Rejected	Yes	6
80	Wendy	Rosa	$219.66	Fortaleza	Egypt	Approved	No	7
81	Priscilla	Dodson	$414.83	Polpenazze del Garda	Christmas Island	Approved	Yes	1
82	Quamar	Crawford	$465.99	Treglio	Suriname	Blocked	Yes	2
83	Shad	Flores	$442.84	Vezirköprü	Guyana	Blocked	Yes	6
84	Lana	Wheeler	$202.64	St. Neots	Palau	Rejected	No	1
85	Vanna	Farmer	$351.21	Millport	Maldives	Approved	Yes	9
86	Cadman	Ray	$352.24	Cheyenne	South Sudan	Blocked	No	7
87	Kimberley	Savage	$429.55	Miami	Vanuatu	Approved	No	9
88	Armand	Sears	$477.13	Mussy-la-Ville	Saint Vincent and The Grenadines	Approved	No	8
89	Sawyer	Vance	$492.63	Davoli	Benin	Rejected	No	4
90	Tanek	Lyons	$172.85	Rocky View	Afghanistan	Approved	No	9
91	Nayda	Hickman	$295.47	Newcastle-upon-Tyne	Kiribati	Blocked	No	3
92	Aileen	Waters	$202.47	Idar-Oberstei	Slovakia	Blocked	Yes	3
93	Forrest	Larsen	$269.64	Gulfport	Korea, North	Blocked	Yes	3
94	Willa	Kemp	$239.89	Somma Lombardo	Wallis and Futuna	Approved	Yes	2
95	Eugenia	Byrd	$466.08	Caruaru	Northern Mariana Islands	Rejected	Yes	8
96	Kato	Beck	$396.49	Khanpur	Solomon Islands	Approved	Yes	2

Hiding table columns

Please note that Table Filter macro allows you to hide columns if you have a too wide table. Select one or multiple columns to hide in the table below.

Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro.

First Name	Last Name	Contact Phones	Last Transaction Date	Bank Account Number	Transaction amount	Tax Amount	Target Transaction City	Target Transaction Country	Customer Status	Suspicious Transaction Activity	Total Transaction Number
Reuben	Barnett	0500 009888	12/14/14	DO07819385109432271545550865	$129.42	$10.28	Guápiles	Tunisia	Blocked	Yes	8
McKenzie	Cleveland	07624 785373	09/15/14	CH6046131558340157475	$216.75	$46.19	Savannah	United States	Blocked	Yes	1
Portia	Lang	(011247) 04420	09/27/14	EE967962637165872502	$422.53	$16.29	Meerut	Côte D'Ivoire (Ivory Coast)	Rejected	No	5
Eagan	Mcgee	07212 430492	09/19/14	MK83589588636375406	$253.03	$26.26	Orangeville	Afghanistan	Approved	No	2
Rahim	Velazquez	0325 526 8440	12/31/14	FO0682149824230550	$454.06	$27.73	Lac-Serent	Georgia	Approved	Yes	6
Roth	Hull	0500 311844	10/11/14	LU056987267796106873	$142.57	$14.14	Luziânia	Sao Tome and Principe	Blocked	No	4
Jack	Griffin	07624 307488	09/04/14	BA714509342088998370	$146.60	$34.55	Georgia	Bahamas	Blocked	No	4
Faith	Newton	0800 1111	09/24/14	LU521764205226552485	$324.96	$24.60	Okigwe	Sri Lanka	Rejected	Yes	1
Basia	Ray	0346 983 8340	08/13/14	TR280491289079508593611789	$260.39	$45.19	Valcourt	Equatorial Guinea	Rejected	Yes	4
Leandra	Duncan	0359 889 6822	01/11/15	CR0942393063075420342	$380.33	$34.57	My	Swaziland	Rejected	No	6

Space shortcuts

Page tree

Fitting table to the screen area

Hiding table columns

Using Automatic Row Numbering