If a column has huge text in it , then will it shrink the size of 16 columns to 7/8/... ?? It has happened while i was trying show 16 columns the total columns i can see is 7 as one of the column values have huge text in it.
Correct my understanding..Are you looking for how to the 16 columns in the worksheet?
You can do this way Analysis-> Table Layout->Advanced->select 16 columns as max value..