如何一次将一列（仅一列）复制到同一个excel工作簿的另一个工作表中

According to requirement I need to copy few columns like A1 S1 K1 from one excel sheet to another in the same excel workbook.

根据要求,我需要在同一个excel工作簿中将一些excel表格中的A1 S1 K1列复制到另一个excel表格中。

1 个解决方案

#1

1. Select a cell in the column you wish to copy.

在要复制的列中选择一个单元格。

2. Press Ctrl+space (as in the space bar!). This selects the entire column.

按Ctrl +空格(如空格键中所示!)。这将选择整个列。

3. Press Ctrl+C. This is the keyboard shortcut for Copy.

按Ctrl + C.这是Copy的键盘快捷键。

4. Move to the other sheet. Select a cell IN ROW ONE where you want the copied data to appear.

移到另一张纸。选择要在其中显示复制数据的单元格IN ROW ONE。

5. Press Ctrl+V. This is the keyboard shortcut for Paste.

按Ctrl + V.这是粘贴的键盘快捷键。

I feel quite certain that this is not what you need. However, it answers the question you asked.

我确信这不是你需要的。但是,它回答了你问的问题。