Ask Your Question
0

how to copy a column to another sheet [closed]

asked 2012-09-23 23:37:50 +0200

SFPete gravatar image SFPete
1

When I try to copy (CTRL-C) a column from one sheet to another I get the first formula only. Most of the options for paste special are grayed out. Receiving cells formatted 'numbers' 'general'. What I'm trying to do is have a running total in the new sheet. If there's a macro out there, I'd happily use it.

Thanks, SFPete

delete reopen flag offensive retag edit

Comments

Are you selecting the whole column or just the top cell before ctrl-c-ing? Most of the paste special options are grayed out unless you un-click the paste all box.

w_whalley ( 2012-09-24 00:00:14 +0200 )edit

The question has been closed for the following reason "question is not relevant or outdated" by qubit
close date 2013-02-23 08:48:22.544998

Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Question tools

Follow

subscribe to rss feed

Stats

Asked: 2012-09-23 23:37:50 +0200

Seen: 148 times

Last updated: Sep 23 '12