topic Cell Size/Re-sizing in Open Office Spreadsheet in Tech Help - Software/Hardware etc

Cell Size/Re-sizing in Open Office Spreadsheet

shutter — Tue, 18 Apr 2017 20:24:49 GMT

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"..

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

alanf — Tue, 18 Apr 2017 20:43:45 GMT

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 ...

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

shutter — Tue, 18 Apr 2017 21:42:10 GMT

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