Table Filter macro allows you to fit your large tables to your screen area, freeze rows and columns, add pagination, hide the unnecessary table columns, apply row numbering and default sorting.

Fitting table to the screen area and freezing rows and columns

Please note that the 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 NameLast NameTransaction amountTarget Transaction CityTarget Transaction CountryTarget Transaction CountryTarget Transaction CountryTarget Transaction CountryTarget Transaction CountryTarget Transaction CountryTarget Transaction CountryTarget Transaction CountryTarget Transaction CountryTarget Transaction CountryTarget Transaction CountryTarget Transaction CountryTarget Transaction Country
Customer StatusSuspicious Transaction ActivityTotal Transaction Number
EaganMcgee$253.03OrangevilleAfghanistan












ApprovedNo2
TanekLyons$172.85Rocky ViewAfghanistan












ApprovedNo9
AmirOdom$203.43ManavgatAlbania












BlockedYes5
GermaineHines$347.08BellingenAlgeria












ApprovedNo6
JordanWeber$249.33SheppartonAnguilla












BlockedYes9
BuckminsterEwing$239.77HarenArgentina












BlockedNo1
SylvesterCampos$338.44RiparbellaArmenia












BlockedYes5
RyanWare$367.76TuticorinArmenia












RejectedYes8
CodyRoss$219.44GentAustria












BlockedYes6
AmeryPoole$418.48ZolderAzerbaijan












RejectedYes1
JackGriffin$146.60GeorgiaBahamas












BlockedNo4
CameranVelasquez$144.75SchiltigheimBangladesh












RejectedYes8
CurranBond$207.97WattrelosBelize












ApprovedYes4
OwenWelch$279.12SpringdaleBenin












RejectedYes4
SawyerVance$492.63DavoliBenin












RejectedNo4
YuliHubbard$107.57Hudson BayBolivia












RejectedNo4
LarsShaw$170.60PittsburghBritish Indian Ocean Territory












RejectedNo4
EvanCoffey$489.53Prince AlbertBrunei












RejectedNo5
HowardCrosby$201.61ChambaveCameroon












BlockedNo2
IvyAlvarado$198.75GuwahatiCape Verde












ApprovedNo2
BrandonLowery$213.54CorkChad












RejectedYes1
QuynnKing$393.43São LuísChile












BlockedNo9
PhillipReed$431.70ChittoorChristmas Island












ApprovedYes6
PriscillaDodson$414.83Polpenazze del GardaChristmas Island












ApprovedYes1
SandraSchultz$273.51NampaColombia












ApprovedYes9
PortiaLang$422.53MeerutCôte D'Ivoire (Ivory Coast)












RejectedNo5
ChaseBryant$493.65Moustier-sur-SambreCzech Republic












ApprovedNo9
GuyCotton$168.20Saint-PierreDenmark












BlockedNo4
IngridHorne$365.20CratoDominica












ApprovedYes4
OctaviusCervantes$235.63MerksemDominica












ApprovedYes4
WendyRosa$219.66FortalezaEgypt












ApprovedNo7
BasiaRay$260.39ValcourtEquatorial Guinea












RejectedYes4
JordanMullen$151.41AlajuelaEritrea












ApprovedNo9
ShadShelton$177.90Salt Lake CityEstonia












RejectedNo4
RahimVelazquez$454.06Lac-SerentGeorgia












ApprovedYes6
ColtKent$482.74JalgaonGrenada












ApprovedYes3
KarlyWalls$200.81CharlottetownGuatemala












ApprovedYes7
XylaSpears$368.74JamoigneGuernsey












RejectedNo2
WhileminaGoodwin$255.81AmaroGuinea












RejectedNo3
ShadFlores$442.84VezirköprüGuyana












BlockedYes6
AldenBuckner$249.18San Marcello PistoieseHungary












BlockedNo1
PlatoDuke$229.55ExeterIndia












BlockedYes1
JulietBarlow$326.73SolingenIran












ApprovedYes7
TyroneAlvarez$303.65ThameIraq












BlockedYes5
RafaelElliott$281.05Little RockJamaica












ApprovedYes4
WillaStevens$137.89GlabaisJapan












ApprovedNo2
AidanHenson$340.93ValpellineJersey












ApprovedNo3
LukeVang$375.44VorselaarJersey












BlockedYes1
NaydaHickman$295.47Newcastle-upon-TyneKiribati












BlockedNo3
ForrestLarsen$269.64GulfportKorea, North












BlockedYes3
GingerCastro$473.40Isle-aux-CoudresLatvia












ApprovedNo4
SeanDelacruz$421.67Vietri di PotenzaLibya












RejectedNo4
LynnCummings$484.17MetairieLiechtenstein












ApprovedNo3
ShoshanaUnderwood$336.12Parkland CountyLiechtenstein












BlockedNo2
FreyaOsborn$198.86RextonLuxembourg












ApprovedYes5
CamillaGood$311.10Saint-HilarionMalawi












RejectedNo7
SethVasquez$333.66Greater HobartMalaysia












BlockedNo3
VannaFarmer$351.21MillportMaldives












ApprovedYes9
JaredDale$391.90BéziersMauritius












ApprovedYes3
ZenaidaKirkland$315.19Yellowhead CountyMongolia












BlockedNo4
GregorySampson$339.91StroudMozambique












BlockedNo1
RachelHead$166.15BautzenNauru












BlockedNo7
EveHines$113.99MontpellierNetherlands












RejectedNo7
KayCole$158.75ClareNetherlands












ApprovedYes2
HadleyGates$363.39ChelmsfordNew Zealand












RejectedYes7
EugeniaByrd$466.08CaruaruNorthern Mariana Islands












RejectedYes8
LyleBlack$437.51MoldPalau












RejectedYes6
LanaWheeler$202.64St. NeotsPalau












RejectedNo1
KeelieByers$236.10Cavaion VeronesePalestine, State of












ApprovedNo3
MaiteLowe$256.17MunoPoland












BlockedNo1
CurranDickson$360.20San FranciscoSaint Martin












BlockedNo7
ArmandSears$477.13Mussy-la-VilleSaint Vincent and The Grenadines












ApprovedNo8
AkeemHolder$131.59SuttonSamoa












BlockedYes7
RothHull$142.57LuziâniaSao Tome and Principe












BlockedNo4
AileenWaters$202.47Idar-ObersteiSlovakia












BlockedYes3
HyattMullins$450.40OldenzaalSlovenia












RejectedNo4
KatoBeck$396.49KhanpurSolomon Islands












ApprovedYes2
CadmanRay$352.24CheyenneSouth Sudan












BlockedNo7
FaithNewton$324.96OkigweSri Lanka












RejectedYes1
QuamarCrawford$465.99TreglioSuriname












BlockedYes2
LeandraDuncan$380.33MySwaziland












RejectedNo6
LysandraBlack$322.36Strombeek-BeverSwaziland












BlockedYes8
KarinaHorton$443.37EsslingenTaiwan












RejectedYes2
JoleneHowe$321.67Maple CreekTogo












BlockedNo3
ReubenBarnett$129.42GuápilesTunisia












BlockedYes8
ThaneCortez$338.56PenrithTunisia












ApprovedYes1
LeviNolan$478.53ChambordUkraine












RejectedNo7
McKenzieCleveland$216.75SavannahUnited States












BlockedYes1
KimberleySavage$429.55MiamiVanuatu












ApprovedNo9
WillowSkinner$216.70Ham-sur-SambreVenezuela












ApprovedNo1
WillaKemp$239.89Somma LombardoWallis and Futuna












ApprovedYes2
ClaireRaymond$126.99WiezeWestern Sahara












BlockedYes9
AmethystDunn$313.64DipignanoWestern Sahara












ApprovedYes9
KylanDillard$264.70Market DraytonYemen












RejectedNo3
CassidyPorter$142.39Saint-Maur-des-FossésZambia












ApprovedYes3
HavivaHancock$136.33ChelseaZimbabwe












ApprovedNo5



Adding the pagination

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

First NameLast NameTransaction amountTarget Transaction CityTarget Transaction CountryCustomer StatusSuspicious Transaction ActivityTotal Transaction Number
ReubenBarnett$129.42GuápilesTunisiaBlockedYes8
McKenzieCleveland$216.75SavannahUnited StatesBlockedYes1
PortiaLang$422.53MeerutCôte D'Ivoire (Ivory Coast)RejectedNo5
EaganMcgee$253.03OrangevilleAfghanistanApprovedNo2
RahimVelazquez$454.06Lac-SerentGeorgiaApprovedYes6
RothHull$142.57LuziâniaSao Tome and PrincipeBlockedNo4
JackGriffin$146.60GeorgiaBahamasBlockedNo4
FaithNewton$324.96OkigweSri LankaRejectedYes1
BasiaRay$260.39ValcourtEquatorial GuineaRejectedYes4
LeandraDuncan$380.33MySwazilandRejectedNo6
CameranVelasquez$144.75SchiltigheimBangladeshRejectedYes8
AmeryPoole$418.48ZolderAzerbaijanRejectedYes1
OwenWelch$279.12SpringdaleBeninRejectedYes4
GermaineHines$347.08BellingenAlgeriaApprovedNo6
ThaneCortez$338.56PenrithTunisiaApprovedYes1
SeanDelacruz$421.67Vietri di PotenzaLibyaRejectedNo4
WillowSkinner$216.70Ham-sur-SambreVenezuelaApprovedNo1
CamillaGood$311.10Saint-HilarionMalawiRejectedNo7
IngridHorne$365.20CratoDominicaApprovedYes4
ClaireRaymond$126.99WiezeWestern SaharaBlockedYes9
AkeemHolder$131.59SuttonSamoaBlockedYes7
YuliHubbard$107.57Hudson BayBoliviaRejectedNo4
GregorySampson$339.91StroudMozambiqueBlockedNo1
FreyaOsborn$198.86RextonLuxembourgApprovedYes5
KylanDillard$264.70Market DraytonYemenRejectedNo3
CurranDickson$360.20San FranciscoSaint MartinBlockedNo7
SylvesterCampos$338.44RiparbellaArmeniaBlockedYes5
HadleyGates$363.39ChelmsfordNew ZealandRejectedYes7
WillaStevens$137.89GlabaisJapanApprovedNo2
KeelieByers$236.10Cavaion VeronesePalestine, State ofApprovedNo3
JordanWeber$249.33SheppartonAnguillaBlockedYes9
KarlyWalls$200.81CharlottetownGuatemalaApprovedYes7
OctaviusCervantes$235.63MerksemDominicaApprovedYes4
TyroneAlvarez$303.65ThameIraqBlockedYes5
JoleneHowe$321.67Maple CreekTogoBlockedNo3
CodyRoss$219.44GentAustriaBlockedYes6
ChaseBryant$493.65Moustier-sur-SambreCzech RepublicApprovedNo9
LynnCummings$484.17MetairieLiechtensteinApprovedNo3
LarsShaw$170.60PittsburghBritish Indian Ocean TerritoryRejectedNo4
CassidyPorter$142.39Saint-Maur-des-FossésZambiaApprovedYes3
WhileminaGoodwin$255.81AmaroGuineaRejectedNo3
JordanMullen$151.41AlajuelaEritreaApprovedNo9
CurranBond$207.97WattrelosBelizeApprovedYes4
ShadShelton$177.90Salt Lake CityEstoniaRejectedNo4
EveHines$113.99MontpellierNetherlandsRejectedNo7
AmirOdom$203.43ManavgatAlbaniaBlockedYes5
EvanCoffey$489.53Prince AlbertBruneiRejectedNo5
QuynnKing$393.43São LuísChileBlockedNo9
IvyAlvarado$198.75GuwahatiCape VerdeApprovedNo2
SethVasquez$333.66Greater HobartMalaysiaBlockedNo3
GuyCotton$168.20Saint-PierreDenmarkBlockedNo4
XylaSpears$368.74JamoigneGuernseyRejectedNo2
HavivaHancock$136.33ChelseaZimbabweApprovedNo5
JulietBarlow$326.73SolingenIranApprovedYes7
KayCole$158.75ClareNetherlandsApprovedYes2
ZenaidaKirkland$315.19Yellowhead CountyMongoliaBlockedNo4
RyanWare$367.76TuticorinArmeniaRejectedYes8
MaiteLowe$256.17MunoPolandBlockedNo1
SandraSchultz$273.51NampaColombiaApprovedYes9
KarinaHorton$443.37EsslingenTaiwanRejectedYes2
LysandraBlack$322.36Strombeek-BeverSwazilandBlockedYes8
AldenBuckner$249.18San Marcello PistoieseHungaryBlockedNo1
LeviNolan$478.53ChambordUkraineRejectedNo7
BuckminsterEwing$239.77HarenArgentinaBlockedNo1
AidanHenson$340.93ValpellineJerseyApprovedNo3
HowardCrosby$201.61ChambaveCameroonBlockedNo2
GingerCastro$473.40Isle-aux-CoudresLatviaApprovedNo4
HyattMullins$450.40OldenzaalSloveniaRejectedNo4
RachelHead$166.15BautzenNauruBlockedNo7
ShoshanaUnderwood$336.12Parkland CountyLiechtensteinBlockedNo2
ColtKent$482.74JalgaonGrenadaApprovedYes3
AmethystDunn$313.64DipignanoWestern SaharaApprovedYes9
PlatoDuke$229.55ExeterIndiaBlockedYes1
JaredDale$391.90BéziersMauritiusApprovedYes3
LukeVang$375.44VorselaarJerseyBlockedYes1
PhillipReed$431.70ChittoorChristmas IslandApprovedYes6
BrandonLowery$213.54CorkChadRejectedYes1
RafaelElliott$281.05Little RockJamaicaApprovedYes4
LyleBlack$437.51MoldPalauRejectedYes6
WendyRosa$219.66FortalezaEgyptApprovedNo7
PriscillaDodson$414.83Polpenazze del GardaChristmas IslandApprovedYes1
QuamarCrawford$465.99TreglioSurinameBlockedYes2
ShadFlores$442.84VezirköprüGuyanaBlockedYes6
LanaWheeler$202.64St. NeotsPalauRejectedNo1
VannaFarmer$351.21MillportMaldivesApprovedYes9
CadmanRay$352.24CheyenneSouth SudanBlockedNo7
KimberleySavage$429.55MiamiVanuatuApprovedNo9
ArmandSears$477.13Mussy-la-VilleSaint Vincent and The GrenadinesApprovedNo8
SawyerVance$492.63DavoliBeninRejectedNo4
TanekLyons$172.85Rocky ViewAfghanistanApprovedNo9
NaydaHickman$295.47Newcastle-upon-TyneKiribatiBlockedNo3
AileenWaters$202.47Idar-ObersteiSlovakiaBlockedYes3
ForrestLarsen$269.64GulfportKorea, NorthBlockedYes3
WillaKemp$239.89Somma LombardoWallis and FutunaApprovedYes2
EugeniaByrd$466.08CaruaruNorthern Mariana IslandsRejectedYes8
KatoBeck$396.49KhanpurSolomon IslandsApprovedYes2

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.

The table is being loaded. Please wait for a bit ...

First NameLast NameContact PhonesLast Transaction DateBank Account NumberTransaction amountTax AmountTarget Transaction CityTarget Transaction CountryCustomer StatusSuspicious Transaction ActivityTotal Transaction Number
ReubenBarnett0500 00988812/20/20DO07819385109432271545550865$129.42$10.28GuápilesTunisiaBlockedYes8
McKenzieCleveland07624 78537309/21/20CH6046131558340157475$216.75$46.19SavannahUnited StatesBlockedYes1
PortiaLang(011247) 0442009/27/20EE967962637165872502$422.53$16.29MeerutCôte D'Ivoire (Ivory Coast)RejectedNo5
EaganMcgee07212 43049209/19/20MK83589588636375406$253.03$26.26OrangevilleAfghanistanApprovedNo2
RahimVelazquez0325 526 844012/31/20FO0682149824230550$454.06$27.73Lac-SerentGeorgiaApprovedYes6
RothHull0500 31184410/11/20LU056987267796106873$142.57$14.14LuziâniaSao Tome and PrincipeBlockedNo4
JackGriffin07624 30748809/04/20BA714509342088998370$146.60$34.55GeorgiaBahamasBlockedNo4
FaithNewton0800 111109/24/20LU521764205226552485$324.96$24.60OkigweSri LankaRejectedYes1
BasiaRay0346 983 834008/13/20TR280491289079508593611789$260.39$45.19ValcourtEquatorial GuineaRejectedYes4
LeandraDuncan0359 889 682201/11/21CR0942393063075420342$380.33$34.57MySwazilandRejectedNo6

Using Automatic Row Numbering and Default Sorting

Please note that the Table Filter macro allows you to enable automatic row numbering and regulate the direction of numbering (ascending or descending). Additionally, you can default sorting by one or multiple columns.

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

Tyrone

Alvarez

$303.65

Thame

Iraq

Blocked

Yes

5

Reuben

Barnett

$129.42

Guápiles

Tunisia

Blocked

Yes

8

Chase

Bryant

$493.65

Moustier-sur-Sambre

Czech Republic

Approved

No

9

Keelie

Byers

$236.10

Cavaion Veronese

Palestine, State of

Approved

No

3

Sylvester

Campos

$338.44

Riparbella

Armenia

Blocked

Yes

5

Octavius

Cervantes

$235.63

Merksem

Dominica

Approved

Yes

4

McKenzie

Cleveland

$216.75

Savannah

United States

Blocked

Yes

1

Thane

Cortez

$338.56

Penrith

Tunisia

Approved

Yes

1

Lynn

Cummings

$484.17

Metairie

Liechtenstein

Approved

No

3

Sean

Delacruz

$421.67

Vietri di Potenza

Libya

Rejected

No

4

Curran

Dickson

$360.20

San Francisco

Saint Martin

Blocked

No

7

Kylan

Dillard

$264.70

Market Drayton

Yemen

Rejected

No

3

Leandra

Duncan

$380.33

My

Swaziland

Rejected

No

6

Hadley

Gates

$363.39

Chelmsford

New Zealand

Rejected

Yes

7

Camilla

Good

$311.10

Saint-Hilarion

Malawi

Rejected

No

7

Jack

Griffin

$146.60

Georgia

Bahamas

Blocked

No

4

Germaine

Hines

$347.08

Bellingen

Algeria

Approved

No

6

Akeem

Holder

$131.59

Sutton

Samoa

Blocked

Yes

7

Ingrid

Horne

$365.20

Crato

Dominica

Approved

Yes

4

Jolene

Howe

$321.67

Maple Creek

Togo

Blocked

No

3

Yuli

Hubbard

$107.57

Hudson Bay

Bolivia

Rejected

No

4

Roth

Hull

$142.57

Luziânia

Sao Tome and Principe

Blocked

No

4

Portia

Lang

$422.53

Meerut

Côte D'Ivoire (Ivory Coast)

Rejected

No

5

Eagan

Mcgee

$253.03

Orangeville

Afghanistan

Approved

No

2

Faith

Newton

$324.96

Okigwe

Sri Lanka

Rejected

Yes

1

Freya

Osborn

$198.86

Rexton

Luxembourg

Approved

Yes

5

Amery

Poole

$418.48

Zolder

Azerbaijan

Rejected

Yes

1

Cassidy

Porter

$142.39

Saint-Maur-des-Fossés

Zambia

Approved

Yes

3

Basia

Ray

$260.39

Valcourt

Equatorial Guinea

Rejected

Yes

4

Claire

Raymond

$126.99

Wieze

Western Sahara

Blocked

Yes

9

Cody

Ross

$219.44

Gent

Austria

Blocked

Yes

6

Gregory

Sampson

$339.91

Stroud

Mozambique

Blocked

No

1

Lars

Shaw

$170.60

Pittsburgh

British Indian Ocean Territory

Rejected

No

4

Willow

Skinner

$216.70

Ham-sur-Sambre

Venezuela

Approved

No

1

Willa

Stevens

$137.89

Glabais

Japan

Approved

No

2

Cameran

Velasquez

$144.75

Schiltigheim

Bangladesh

Rejected

Yes

8

Rahim

Velazquez

$454.06

Lac-Serent

Georgia

Approved

Yes

6

Karly

Walls

$200.81

Charlottetown

Guatemala

Approved

Yes

7

Jordan

Weber

$249.33

Shepparton

Anguilla

Blocked

Yes

9

Owen

Welch

$279.12

Springdale

Benin

Rejected

Yes

4

  • No labels