Ask Your Question
0

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 4.2.2.1 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
1

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
0

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

Comments

@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

Question Tools

1 follower

Stats

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

Seen: 213 times

Last updated: Apr 04 '14