Large longtable to fit in LaTeX
<p>I'm trying to fit a multiple page longtable into my LaTeX document. Even after searching around for answers for longtable fitting in LaTeX I can't find a solution that works for my table. </p>

<p>This is what my table is going to contain. It should be a four column table.
I have no idea how to use the longtable function correctly, since in all of my attempts the table is way too wide.</p>

<p>Edit:</p>

<p>I've updated the table after using the input from Ellen McCastle. </p>

<p>This now works with the multiple page bit, but it is overruling the placements of the text in the columns. So that it doesn't look as neat as I would like. </p>

<p>Is there any way to edit this?</p>

<p>I've uploaded a image of how the table looks in excel for comparison. </p>

<p>Table:</p>

<pre><code>\begin{longtable}{@{\extracolsep{\fill}}R{2cm}L{7.5cm}R{3cm}C{0.85cm}}
\hline
\multicolumn{1}{l}{{\color[HTML]{FE0000} Pengeinstitutternes størrelsesgruppering 2016}} &amp;                                      &amp;  &amp;    \\ \hline
\multicolumn{1}{l}{Antal pengeinstitutter gruppe 1- 4}                                   &amp;                                      &amp;  &amp; 76 \\
\multicolumn{1}{l}{Gruppe 1 - Arb. kapital over 75 mia. kr.}                             &amp;                                      &amp;  &amp;    \\ \hline
3000                                                                                     &amp; Danske Bank A/S                      &amp;  &amp;    \\
2222                                                                                     &amp; Nordea Bank Danmark A/S              &amp;  &amp;    \\
7858                                                                                     &amp; Jyske Bank A/S                       &amp;  &amp;    \\
8079                                                                                     &amp; Sydbank A/S                          &amp;  &amp;    \\
8117                                                                                     &amp; Nykredit Bank A/S                    &amp;  &amp;    \\ \hline
5                                                                                        &amp; \multicolumn{1}{r}{5}                &amp;  &amp;    \\
\multicolumn{1}{l}{Gruppe 2 - Arb. kapital over 12 mia. kr.}                             &amp;                                      &amp;  &amp;    \\ \hline
9380                                                                                     &amp; Spar Nord Bank A/S                   &amp;  &amp;    \\
5301                                                                                     &amp; Arbejdernes Landsbank, Aktieselskab  &amp;  &amp;    \\
1149                                                                                     &amp; Saxo Bank A/S                        &amp;  &amp;    \\
7730                                                                                     &amp; Vestjysk Bank A/S                    &amp;  &amp;    \\
7670                                                                                     &amp; Ringkjøbing Landbobank, Aktieselskab &amp;  &amp;    \\
8099                                                                                     &amp; Nordjyske Bank A/S                   &amp;  &amp;    \\
9335                                                                                     &amp; Kronjylland, Sparekassen             &amp;  &amp;    \\
9686                                                                                     &amp; Den Jyske Sparekasse                 &amp;  &amp;    \\
400                                                                                      &amp; Lån og Spar Bank A/S                 &amp;  &amp;    \\
9217                                                                                     &amp; Jutlander Bank A/S                   &amp;  &amp;    \\
522                                                                                      &amp; Sparekassen Sjælland A/S             &amp;  &amp;    \\
9070                                                                                     &amp; Sparekassen Vendsyssel               &amp;  &amp;    \\ \hline
12                                                                                       &amp; \multicolumn{1}{r}{11}               &amp;  &amp;    \\
\multicolumn{1}{l}{Gruppe 3 - Arb. kapital over 500 mio. kr.}                            &amp;                                      &amp;  &amp;    \\ \hline
7681                                                                                     &amp; Alm. Brand Bank A/S                  &amp;  &amp;    \\
5999                                                                                     &amp; Danske Andelskassers Bank A/S        &amp;  &amp;    \\
10001                                                                                    &amp; FIH Erhvervsbank A/S                 &amp;  &amp;    \\
755                                                                                      &amp; Middelfart Sparekasse                &amp;  &amp;    \\
6771                                                                                     &amp; Lægernes Pensionsbank A/S            &amp;  &amp;    \\
7320                                                                                     &amp; Djurslands Bank A/S                  &amp;  &amp;    \\
9090                                                                                     &amp; Sparekassen Thy                      &amp;  &amp;    \\
9740                                                                                     &amp; Frøs Herreds Sparekasse              &amp;  &amp;    \\
844                                                                                      &amp; Fynske Bank A/S                      &amp;  &amp;    \\
828                                                                                      &amp; Sparekassen Fyn A/S                  &amp;  &amp;    \\
7780                                                                                     &amp; Skjern Bank, Aktieselskabet          &amp;  &amp;    \\
6471                                                                                     &amp; Grønlandsbanken, Aktieselskab        &amp;  &amp;    \\
9695                                                                                     &amp; Saxo Privatbank A/S                  &amp;  &amp;    \\
7230                                                                                     &amp; Østjydsk Bank A/S                    &amp;  &amp;    \\
7890                                                                                     &amp; Salling Bank A/S                     &amp;  &amp;    \\
6520                                                                                     &amp; Lollands Bank, Aktieselskab          &amp;  &amp;    \\
13460                                                                                    &amp; Merkur Andelskasse                   &amp;  &amp;    \\
7930                                                                                     &amp; Kreditbanken A/S                     &amp;  &amp;    \\
6860                                                                                     &amp; Nordfyns Bank Aktieselskabet         &amp;  &amp;    \\
6880                                                                                     &amp; Totalbanken A/S                      &amp;  &amp;    \\
1671                                                                                     &amp; Basisbank A/S                        &amp;  &amp;    \\
9044                                                                                     &amp; Dronninglund Sparekasse              &amp;  &amp;    \\
6140                                                                                     &amp; Møns Bank, A/S                       &amp;  &amp;    \\
9682                                                                                     &amp; Nr. Nebel og Omegn, Sparekassen for  &amp;  &amp;    \\
7570                                                                                     &amp; PenSam Bank A/S                      &amp;  &amp;    \\
9797                                                                                     &amp; Broager Sparekasse                   &amp;  &amp;    \\
9388                                                                                     &amp; Sparekassen Djursland                &amp;  &amp;    \\
9827                                                                                     &amp; Sparekassen Bredebro                 &amp;  &amp;    \\
537                                                                                      &amp; Dragsholm Sparekasse                 &amp;  &amp;    \\
6620                                                                                     &amp; Coop Bank A/S                        &amp;  &amp;    \\
9283                                                                                     &amp; Langå Sparekasse                     &amp;  &amp;    \\
7500                                                                                     &amp; Hvidbjerg Bank Aktieselskab          &amp;  &amp;    \\
13080                                                                                    &amp; Frørup Andelskasse                   &amp;  &amp;    \\
9354                                                                                     &amp; Rønde Sparekasse                     &amp;  &amp;    \\
9312                                                                                     &amp; Sparekassen Balling                  &amp;  &amp;    \\
9133                                                                                     &amp; Frøslev-Mollerup Sparekasse          &amp;  &amp;    \\
9137                                                                                     &amp; Ekspres Bank A/S                     &amp;  &amp;    \\
9860                                                                                     &amp; Folkesparekassen                     &amp;  &amp;    \\
847                                                                                      &amp; Rise Sparekasse                      &amp;  &amp;    \\ \hline
39                                                                                       &amp; \multicolumn{1}{r}{39}               &amp;  &amp;    \\
\multicolumn{1}{l}{Gruppe 4 - Arb. kapital under 500 mio. kr.}                           &amp;                                      &amp;  &amp;    \\ \hline
13290                                                                                    &amp; Andelskassen Fælleskassen            &amp;  &amp;    \\
9684                                                                                     &amp; Fanø Sparekasse                      &amp;  &amp;    \\
6102                                                                                     &amp; Landbrugets Finansieringsbank (LFB)  &amp;  &amp;    \\
9124                                                                                     &amp; Sønderhå-Hørsted Sparekasse          &amp;  &amp;    \\
9135                                                                                     &amp; Klim Sparekasse                      &amp;  &amp;    \\
13100                                                                                    &amp; Københavns Andelskasse               &amp;  &amp;    \\
9634                                                                                     &amp; Borbjerg Sparekasse                  &amp;  &amp;    \\
13070                                                                                    &amp; Faster Andelskasse                   &amp;  &amp;    \\
800                                                                                      &amp; Flemløse Sparekasse                  &amp;  &amp;    \\
9369                                                                                     &amp; Søby-Skader-Halling Sparekasse       &amp;  &amp;    \\
1693                                                                                     &amp; PFA Bank                             &amp;  &amp;    \\
579                                                                                      &amp; Sparekassen Den lille Bikube         &amp;  &amp;    \\
5125                                                                                     &amp; Leasing Fyn Bank A/S                 &amp;  &amp;    \\
13350                                                                                    &amp; Østervraa, J.A.K. Andelskassen       &amp;  &amp;    \\
28001                                                                                    &amp; MAJ Bank A/S                         &amp;  &amp;    \\
9629                                                                                     &amp; Stadil Sparekasse                    &amp;  &amp;    \\
13220                                                                                    &amp; Andelskassen OIKOS                   &amp;  &amp;    \\
544                                                                                      &amp; Refsnæs Sparekasse                   &amp;  &amp;    \\
9639                                                                                     &amp; Fjaltring-Trans Sparekasse           &amp;  &amp;    \\
13330                                                                                    &amp; Slagelse Andelskasse                 &amp;  &amp;    \\ \hline
20                                                                                       &amp; \multicolumn{1}{r}{17}               &amp;  &amp;    \\
\multicolumn{1}{l}{}                                                                     &amp;                                      &amp;  &amp;   
\end{longtable}
</code></pre>

<p>My margins in my document are:</p>

<pre><code>\setmarginsrb           { 1.25in}  % left margin
                        { 0.6in}  % top margin
                        { 1.25in}  % right margin
                        { 1in}  % bottom margin
                        {  20pt}  % head height
                        {0.25in}  % head sep
                        {   9pt}  % foot height
                        { 0.3in}  % foot sep
</code></pre>

<p>Please ask for any more information, and I will try my best to supply. I am very green in LaTeX.</p>

<p>Image of table in excel:</p>

<p><img src="https://i.stack.imgur.com/oahm6.jpg" alt="Excel_table"></p>