Ask Your Question

I am opening excell 97 file in libre. unable to unhide columns hidden in the excell file [closed]

asked 2014-04-01 16:09:20 +0100

Grandad 75 gravatar image

updated 2015-09-09 12:05:22 +0100

Alex Kemp gravatar image

O S Win XP Media centre edition Version 2002 SP3 LIBRE OFFICE LIBRE OFFICE $.2 Multilanguage(000420(Build :1)) How can i show hidden columns in my original MS Excell spreadsheet

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-20 18:28:28.700372

2 Answers

Sort by » oldest newest most voted

answered 2014-04-01 16:45:15 +0100

Pedro gravatar image

Just select the column that is to the left and the one to the right by clicking on the name of the column (e.g. R) and drag (without releasing) to the name of the following visible column (e.g. X)

Now that that the block is selected you can release the left mouse button.

Click with the right mouse button on the selected columns' name and from the menu choose Show.

edit flag offensive delete link more

answered 2014-04-04 18:16:24 +0100

Grandad 75 gravatar image

Thanks for answer Pedro. However this did not work on my setup also did not work on original MS Excel set up as I now remembered . What did work on both programs was selecting the whole spreadsheet by clicking in cell at top left hand corner and then clicking on Format, column, unhide.

edit flag offensive delete link more


@Grandad 75, I'm glad you found a solution ;) Thank you for reporting back. This might be useful for someone with a similar problem.

Pedro gravatar imagePedro ( 2014-04-04 23:21:50 +0100 )edit

Thanks Grandad75

Steve H gravatar imageSteve H ( 2018-06-14 17:55:18 +0100 )edit

I do not have the option to unhide in Libre. I have the option to "show". However neither one works for me. I tried both ways suggested by Grandad75. Now what do you suggest?

Cathryn gravatar imageCathryn ( 2020-01-02 04:40:33 +0100 )edit

Question Tools

1 follower


Asked: 2014-04-01 16:09:20 +0100

Seen: 247 times

Last updated: Apr 04 '14