Home » Questions » Computers [ Ask a new question ]

Is it Possible to not copy all 65,537 cells when copying a column in Open Office

Is it Possible to not copy all 65,537 cells when copying a column in Open Office

I'm using Open Office 3.01 on OS X. When I select an entire column of data by clicking its header, and the copy that to the clipboard, Open Office appears to copy all 65,537 cells to the clipboard. If I paste the data into a text editor, I'll get a file with 65,537 lines. This behavior is inconsistent with other spread sheet programs I've used.

Asked by: Guest | Views: 47
Total answers/comments: 1
Guest [Entry]

"Try this:

Select the first cell in the column.
Type Ctrl+Shift+Down-Arrow

That will select only the cells with values in the column; at least in Excel."