How to find out how many columns am I using in a sheet/report

Loann McGee

Good morning,

I looked through and didn't see this question, so if it is posted elsewhere, my apologies.

Is there a way to know how many columns you have on a sheet without having to manually count them? I know I have a few sheets with anywhere from 25-50+ columns, but I've not found a way to get a count automatically. 

Not a major need, but just a nice convenience to have. 

Blessings,

Loann

JamesR

Loann,

 

Similar t your other Question, this sort of Properties data is not readily available.  A useage Stats section in the properties dialogue box could cater for this.  Again perhaps Travis can note and add it to the growing list of small but usefull enhancements.

 

As a work around if its important and not ideal, Export to excel. Place a 1 in the first column, Control and Autofill to the last Cell in the row and the one will increment in steps of 1.  You will have your answer.

Loann McGee

Thanks, James - that was going to be my next step! ;-)

Travis

Loann, if you have data in every column in a row, click on the row number (which will highlight the entire row) then look at the bottom right of your sheet. Formula results will appear here depending on the type of data you have selected (count, sum, min, max, avg). When you select a row, you will see a count of the number of selected entries (and probably a couple other results). If you have data in every column in the row, the count will tell you how many columns you have. 

 

 

I will also add the usage stats suggestion to our growing list of small but useful enhancements 

Charles DESCOTES

I like Travis solution.

To this you may note that the horizontal count does NOT include the symbols of the first left columns (attachments, discussion, alerts, lock), which is good as far as I'm concerned.

Loann McGee

Thanks for the input - very helpful.