Ubuntu
openoffice.org package

How do I reveal a column that has been hidden

Asked by Judy Alyn Ahrens

I can't find the answer in the pop downs
When I want to add a column I get a message that I can"t because it has been merged.

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Solved by:
Tony Pursell
Solved:
Last query:
Last reply:
Revision history for this message
Best Tony Pursell (ajpursell) said : 		#1

Hi Judy

To reveal a column that has been hidden, highlight the columns either side of it and do Format > Column > Show. For instance, if column C is hidden, highlight columns B and D and do Format > Column > Show.

I would need more details on the problem adding a column including a description of your spreadsheet and where and how you are trying to add the column.

Tony

PS If this answers your question, please mark it as Solved.

Revision history for this message
marcus aurelius (adbiz) said : 		#2

merged and hidden are two different things. merged cells are visible.

to unmerge them, click on the merged cell then click on the icon that is just to the right of the full justify icon. if it indeed is merged, the merge icon should show as yellow.

to unmerge a column, click on the left column that is merged, then click the merge icon.

you can easily find out which columns are merged by going into a row and start from the left side, move across the columns. when you hit a cell that spans two columns, that is the merged column.

Revision history for this message
Judy Alyn Ahrens (jainnf) said : 		#3

Thanks Tony Pursell, that solved my question.