cancel
Showing results for 
Search instead for 
Did you mean: 

Cell Size/Re-sizing in Open Office Spreadsheet

FIXED
Community Veteran
Posts: 17,767
Thanks: 1,603
Fixes: 19
Registered: 06-11-2007

Cell Size/Re-sizing in Open Office Spreadsheet

Last time I used Open Office to create a spread sheet, the cells were a "reasonable" size, by default,  and was able to start using it straight away...  this time,... the size of the cells has diminished to almost useless, by default. they are Soooo tiny. and crammed into the sheet, that I cannot even read what I have put into one.

I know you can adjust the width of the columns by the dragging method... and you can also do that horizontally,... but I need about 100 horizontal moves to make the spreadsheet. and they will not be all the same size..

 

Is there a way of selecting/highlighting an area of the spreadsheet  ( say A1 to G100 )  and doing some king of "auto resize" to one you have already re-sized?

Can`t find anything in the help, nor in the drop down menu`s to say "resize cells"..

 

2 REPLIES
alanf
Aspiring Pro
Posts: 1,931
Thanks: 78
Fixes: 1
Registered: 17-10-2007

Re: Cell Size/Re-sizing in Open Office Spreadsheet

Fix

I use LibreOffice which is I believe similar.

If the cells are large enough to hold the data but just too small to see then select View / Zoom to a greater %.

To resize columns select columns then Format / Column / Width ...

To resize rows select rows then Format / Row / Height ... 

Community Veteran
Posts: 17,767
Thanks: 1,603
Fixes: 19
Registered: 06-11-2007

Re: Cell Size/Re-sizing in Open Office Spreadsheet

@alanf Thanks......  View > Zoom > 100% did the trick... all a decent size now...