I Think I Found a Bug in Excel

Copper Contributor

So I was highlighting a table to see how many rows it had, and when I highlighted the top column, it told me 130, but when I highlighted the same amount on the bottom column, it gave me 128. First off, which should I believe? Secondly, why is this? The top column is only text and the bottom column is only numbers. Does that make a difference?

2 Replies

@pb108092 

I'm not sure what are top and bottom columns in your case. If we speak about structured table, clicking on column you select rows between header and totals. Clicking once more data rows plus header and totals are selected, i.e. it will be two more.

@pb108092 I doubt it, but what do you mean by "the top column" and "the bottom column"?