Search code examples
libreofficelibreoffice-calc

LibreOffice Calc, how to count the number of columns in a table?

My request is very simple.

I just opened a csv file with LibreOffice Calc, and I notice that the columns go from A to BL. I need to know how many columns there are, in this A-BL range.

How could I do that?

Solution

  • Just execute the following three steps:

    1. Navigate to Column BL (manually or using the navigator: Hit F5 to open the navigator, enter "BL" at the column text field and hit ENTER;
    2. Select all the cells from BL1 to A1: press and hold SHIFT, hit Pos1 (may be Home on your keyboard);
    3. Check the status bar. It shows the selection's size - 64 columns:

    enter image description here