Cell sizing

  • Thread starter Thread starter lkw441
  • Start date Start date
L

lkw441

I have an .xls with 985 cells. Most of these are fine to view but ther
are probably 200-300 that apparently the info has a large number o
characters and a cell may appear 2-3" tall. I know that I can go i
and resize each cell manually, but is there some way to do thi
automatically? Thanks.

Larr
 
this is gonna sound like a trivial answer, but if i understand yo
correctly you can just highlight the numbers at the left side of th
page (row numbers- click the 1st, hold shift, click the last) an
either
a. adjust any one to the size youre after (all will automaticall
comply) *note* this will probbably make some information not visible
or
b. dbl click the separation line between any two (this will shorten al
to the minimum size needed to show all information ontained in th
cell)
btw this works for columns to
 
Back
Top