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 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



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