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

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

flag of United Kingdom of Great Britain and Northern Ireland

10514 ●14 ●42 ●42 http://etmg.altervista...

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

add a comment

1

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

Pedro

5589 ●16 ●44 ●88

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

add a comment

0

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

Grandad 75
1 ●1 ●1 ●1

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

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 ( 2014-04-04 23:21:50 +0100 )edit

Thanks Grandad75

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

add a comment

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

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

Comments

Question Tools

Stats

Related questions

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

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

Comments

Question Tools

Stats

Related questions

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

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