Unhide column

Bob713 · Posted: Mon Feb 25, 2008 11:27 am Post subject: Unhide column

Is there a keyboard shortcut to unhide a column?

Corfy · Posted: Mon Feb 25, 2008 12:25 pm Post subject:

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.

Bob713 · Posted: Mon Feb 25, 2008 2:20 pm Post subject:

Corfy · Posted: Mon Feb 25, 2008 5:58 pm Post subject:

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.

Bob713 · Posted: Mon Feb 25, 2008 7:55 pm Post subject:

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!

Corfy · Posted: Mon Feb 25, 2008 8:01 pm Post subject:

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.

Bob713 · Posted: Mon Feb 25, 2008 8:07 pm Post subject:

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

Hopefully someone will post the correct/easy way.

Villeroy · Posted: Mon Feb 25, 2008 11:23 pm Post subject:

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]

Bob713 · Posted: Tue Feb 26, 2008 4:35 am Post subject:

As you can see in the earlier posts (unless I am misundertanding you) that's exactly what did not work.

Villeroy · Posted: Tue Feb 26, 2008 4:48 am Post subject:

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

Bob713 · Posted: Tue Feb 26, 2008 5:00 am Post subject:

Villeroy · Posted: Tue Feb 26, 2008 5:05 am Post subject:

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.

Bob713 · Posted: Tue Feb 26, 2008 5:27 am Post subject:

zeddock · General User Joined: 08 Jun 2007 Posts: 7

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