OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Unhide column

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
Bob713
General User
General User


Joined: 03 Feb 2008
Posts: 10
Location: Maryland, U.S.A.

PostPosted: Mon Feb 25, 2008 11:27 am    Post subject: Unhide column Reply with quote

Is there a keyboard shortcut to unhide a column?
Back to top
View user's profile Send private message
Corfy
Moderator
Moderator


Joined: 14 Jun 2005
Posts: 1117
Location: Near Indianapolis, IN, USA

PostPosted: Mon Feb 25, 2008 12:25 pm    Post subject: Reply with quote

There doesn't appear to be, but you can always go to Tools->Toolbars->Customize, go to the "Keyboard" tab, and set your own shortcut. You'll find the Hide and Show commands under the Format category.
_________________
Laugh at life or life will laugh at you.
Back to top
View user's profile Send private message Visit poster's website
Bob713
General User
General User


Joined: 03 Feb 2008
Posts: 10
Location: Maryland, U.S.A.

PostPosted: Mon Feb 25, 2008 2:20 pm    Post subject: Reply with quote

Corfy wrote:
There doesn't appear to be, but you can always go to Tools->Toolbars->Customize, go to the "Keyboard" tab, and set your own shortcut. You'll find the Hide and Show commands under the Format category.


Thanks for your reply.
I've had as much luck trying to use a keyboard shortcut to unhide a column as I've had using Format>Column>Show. In both cases nothing happens. I use F5 to "navigate" to the column. In other words, in the Name Box it shows that I am in A1 ("A" being the hidden column) but I can't get the column to show. Neither the sheet or the document is protected. Am I doing something wrong?
Any further help would be appreciated.
Back to top
View user's profile Send private message
Corfy
Moderator
Moderator


Joined: 14 Jun 2005
Posts: 1117
Location: Near Indianapolis, IN, USA

PostPosted: Mon Feb 25, 2008 5:58 pm    Post subject: Reply with quote

To unhide a column, I usually highlight the two columns around it, right-click on the column header and select "Show", but that is just me.

For example, if column B is hidden, I select columns A and C, right-click, and select "Show". There may be a better way of doing it, but that is what works for me.

However, if both B and C are hidden, and you want to show B but not C, I don't know how to do that without showing both and then hiding C.
_________________
Laugh at life or life will laugh at you.
Back to top
View user's profile Send private message Visit poster's website
Bob713
General User
General User


Joined: 03 Feb 2008
Posts: 10
Location: Maryland, U.S.A.

PostPosted: Mon Feb 25, 2008 7:55 pm    Post subject: Reply with quote

You gave me an idea and it worked! My hidden column was Column A so I could not highlight the two columns around it, but what I was able to do is insert a column after it (column B). Then I selected the range I needed in column A and cut and pasted it into column B. The next step was to adjust a formula that depended on the values in colimn A to reflect the values in column B.
There must be an easier way to do this but at least it got the job done.
Thanks!
Back to top
View user's profile Send private message
Corfy
Moderator
Moderator


Joined: 14 Jun 2005
Posts: 1117
Location: Near Indianapolis, IN, USA

PostPosted: Mon Feb 25, 2008 8:01 pm    Post subject: Reply with quote

You're welcome. And there probably is an easier way. I'm hardly an expert on spreadsheets. Most of what I know I learned from trial-and-error and from reading the forums.
_________________
Laugh at life or life will laugh at you.
Back to top
View user's profile Send private message Visit poster's website
Bob713
General User
General User


Joined: 03 Feb 2008
Posts: 10
Location: Maryland, U.S.A.

PostPosted: Mon Feb 25, 2008 8:07 pm    Post subject: Reply with quote

We are both students of the trial-and-error school. Smile

Hopefully someone will post the correct/easy way.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Mon Feb 25, 2008 11:23 pm    Post subject: Reply with quote

You can select hidden cells. If you want to unhide column A, type "a1" into the name box and call Menu:Format>Columns>Show.
Shortcut: Menu:Tools>Customise...[X]Calc, <some shortcut>, Category: Format, Function: "Show Columns", [Modify], [OK]
Back to top
View user's profile Send private message
Bob713
General User
General User


Joined: 03 Feb 2008
Posts: 10
Location: Maryland, U.S.A.

PostPosted: Tue Feb 26, 2008 4:35 am    Post subject: Reply with quote

As you can see in the earlier posts (unless I am misundertanding you) that's exactly what did not work.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Tue Feb 26, 2008 4:48 am    Post subject: Reply with quote

Works for me. Is your column visible at zero width? Menu:Format>Columns>Width...
Back to top
View user's profile Send private message
Bob713
General User
General User


Joined: 03 Feb 2008
Posts: 10
Location: Maryland, U.S.A.

PostPosted: Tue Feb 26, 2008 5:00 am    Post subject: Reply with quote

Villeroy wrote:
Works for me. Is your column visible at zero width? Menu:Format>Columns>Width...


No.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Tue Feb 26, 2008 5:05 am    Post subject: Reply with quote

Sigh! Is this strange behaviour specific to this particular sheet? If so:
Create a new sheet, go back to the broken one, Ctrl+A, Ctrl+C, select new sheet, Ctrl+V, remove old one, rename new one.
Back to top
View user's profile Send private message
Bob713
General User
General User


Joined: 03 Feb 2008
Posts: 10
Location: Maryland, U.S.A.

PostPosted: Tue Feb 26, 2008 5:27 am    Post subject: Reply with quote

Villeroy wrote:
Sigh! Is this strange behaviour specific to this particular sheet? If so:
Create a new sheet, go back to the broken one, Ctrl+A, Ctrl+C, select new sheet, Ctrl+V, remove old one, rename new one.


It's the only sheet I've tried it with.

Although I'm sure it would work, I've already done a workaround.

Thanks for your suggestion.
Back to top
View user's profile Send private message
zeddock
General User
General User


Joined: 08 Jun 2007
Posts: 7

PostPosted: Tue Sep 30, 2008 9:51 am    Post subject: UNHIDE / SHOW ONE COLUMN Reply with quote

To show a column or row which is sandwiched between other hidden columns/rows:

In the upper left corner is the Name Box, just to the left of the formula box.
This will show your current cell or collection of cells, but you can type into this box a cell you want to go to!

So:
If I have columns B,C,D,E,F,G,H all hidden but decide I need column E shown, I can type E1 into the name box and hit enter. (Even though I cannot see it, I am "in" that cell.)
Now go to Format/Column/Show.

Goodluck!

Zeddock
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group