The Shop > Software Tools

Open Office.

(1/3) > >>

DavidA:
Maybe some one can help with this one.

I use Open Office. And at the moment am constructing a spreadsheet that will be 367 columns wide.

Now. The problem is I need to be able to see column A at all times.

But I can only display columns A to K at a comfortable resolution.

To enter or see more columns I have to shift the columns to the left. I.e out of site. The problem with that is that I then lose sight of Column A.

The question becomes, how do I 'hide' columns B to K so that the display shows A,L,M....etc.

Or how do I define the columns that are to be displayed ?

Hope someone knows how to do this.

Dave.

awemawson:
If it is like Excel which it emulates, highlight column B, go to the view menu, click 'freeze panes'

(info supplied by text from my daughter who is an Excel expert, and 100 miles away !!!!! )

DavidA:
Andrew,

Nothing similar in the Open Office 'view' window.

Dave

Spurry:
Dave
Another hint from the MS offering
Highlight the required columns to be hidden. Right mouse click inside the highlighted bit, select HIDE from the drop down menu, and they disappear.
HTH
Pete

awemawson:
A quick google reveals this:

https://wiki.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Getting_Started/Freezing_rows_and_columns

and:

https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=22703

Navigation

[0] Message Index

[#] Next page