Cell Size/Re-sizing in Open Office Spreadsheet
FIXED- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Other forums
- :
- Tech Help - Software/Hardware etc
- :
- Cell Size/Re-sizing in Open Office Spreadsheet
18-04-2017 9:24 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
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"..
Fixed! Go to the fix.
18-04-2017 9:43 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
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
18-04-2017 10:42 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
@alanf Thanks...... View > Zoom > 100% did the trick... all a decent size now...
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Other forums
- :
- Tech Help - Software/Hardware etc
- :
- Cell Size/Re-sizing in Open Office Spreadsheet