I have a rather large spreadsheet in LibreOffice Calc, with many columns hidden. How do I unhide just a SINGLE column? I know how to unhide all consecutive columns, but I would like to unhide just one.
Columns C through L are hidden. I would like to unhide just column L, and leave columns C through K hidden. How do I do this? Thanks.
I don’t think you can unhide a single column. You have to unhide the consecutive columns and rehide those that you want to stay hidden while keeping column L visible.
Not if you use Hide.
You can instead select one column, click Data > Group and Outline > Group and a line with a - will appear above the column numbers. Click the - to hide the column, you will then see a + above the two neighbouring columns where the the hidden column is. Click the + to reveal the column.
You can select more than one column in a group, and you can make more than one group. If you look at the left of the space above the columns numbers you will see 1 for the first group, 2 for the second group, etc.
1 Like
For the GUI I would also suggest a Solution like @EarnestAl already has given, … but from my POV (with all the Day open interactive jupyter-notebook which is already connected to LO) its just a matter of:
doc = XSCRIPTCONTEXT.getDocument()
doc.Sheets.Sheet1.Columns.L.IsVisible = True
1 Like
- Go to a cell in the hidden column that you need to unhide. To do that, enter
L1into theName Box, and press Enter:
- With the cell selected, use
Format→Columns→Show.
2 Likes
Also can be activated with Ctrl+Shift+T.
Also can widen the column with Alt+Right arrow, but this will not preserve the original column width.
Enter a cell address into the name box left of the formula bar, say X1. The unhide command will unhide column X.
1 Like