Ask Your Question

Why does column AMJ show up after issuing "show columns"? [closed]

asked 2019-08-12 17:01:47 +0200

PèreOrval gravatar image
  1. Create an empty calc-sheet
  2. Press Ctrl-A (select all)
  3. Press Shift and left-mouse-click on column A in order to remove Column A from the selected cells
  4. Right-mouse-click on top -> "Hide columns" => Only column A is shown (as was our purpose)

Question: How can one easily make the other columns visible again? (Ctrl-Z, if you press it right away, of course, but that won't work after you have closed the file)

If you try to "show columns" only the column AMJ is shown...

Anyhow, is there a proper way to show multiple columns again? It looks that you have then to show them back one by one, and in case you have hidden all the columns unto the right side, you can only get them back AMJ -> AMI -> AMH -> ...

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2019-08-13 16:21:31.765344

1 Answer

Sort by » oldest newest most voted

answered 2019-08-12 17:32:37 +0200

erAck gravatar image

Ctrl+A then Show Columns (surprise ;-) Or to show only columns A to C input A:C in the Name Box and hit Enter, then Show Columns.

edit flag offensive delete link more


Thank you very much for your answer.

PèreOrval gravatar imagePèreOrval ( 2019-08-12 19:07:22 +0200 )edit

Glad to help. Then please mark the answer as correct by clicking the check mark icon. Thanks.

erAck gravatar imageerAck ( 2019-08-13 16:10:36 +0200 )edit

Question Tools

1 follower


Asked: 2019-08-12 17:01:47 +0200

Seen: 86 times

Last updated: Aug 12 '19