title: Large longtable to fit in LaTeX
body: <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>