Copying and pasting spreadsheet data

You can copy and paste data in the spreadsheet. You can also copy and paste spreadsheet data between Powerproject and other applications. For example, you could create a list of bar titles and start dates in Microsoft Excel®, then paste them into Name and Start cells in the spreadsheet, or copy data from the spreadsheet and paste it into Excel for further manipulation.

Copying spreadsheet data

To copy spreadsheet data:

  1. Select the data you want to copy in the spreadsheet. You can copy:
    • Whole columns of data (including the column heading), by clicking on a column heading (and dragging your selection to the left or right to select more than one column at the same time).
    • Blocks of cells, by clicking and dragging the mouse pointer across and down the cells to select them.
    • Data in individual cells, by clicking in a cell and dragging the mouse pointer across the data to select it.
    • All the spreadsheet data on one or more bars, by clicking in the Line column to select the bar(s) you want to copy; if you copy bars in this way, the tasks on the bar are copied as well as the spreadsheet information.
  2. On the Home tab, in the Clipboard group, click Copy. You can now paste the selected data into other spreadsheet cells or into another application such as Excel.

You can specify the separators to insert in between cells and tasks when you copy data from the spreadsheet to the clipboard, using the Spreadsheet copy to clipboard separators group on the Spreadsheet tab of the Options dialog.

Pasting data into the spreadsheet

To paste data into the spreadsheet:

  1. Copy the data - either from the Powerproject spreadsheet or from another application such as Excel - that you want to paste into the spreadsheet to the Windows® clipboard.
  2. Select the cells into which you want to paste the data within the spreadsheet. To select a block of cells, drag the pointer over the cells that you want to select.
  3. On the Home tab, in the Clipboard group, click the Paste dropdown and select Paste. The data is pasted into the selected cells.

When pasting data into cells, Powerproject does its best to paste as much information as possible, even if the number of cells that you select to paste the information into does not match the number of cells that you have copied. Sometimes it is not possible to paste data into the cells that you select. For example, you cannot paste bar names into the cells in a date column, as the two types of cell are incompatible.

If you copy a whole column, both the column heading and the column contents are pasted when you paste the column into another application; when you paste the column into the Powerproject spreadsheet, only the column contents are pasted.

Specifying whether cell formatting is pasted into the spreadsheet

When you paste data into the Powerproject spreadsheet that has been copied from another application such as Microsoft Project or Excel, any formatting that has been applied to the cells can be retained. For example, if the text in a particular column has been coloured red, the text in a particular row has been formatted in bold italics and the text in a particular cell has been formatted with a particular font, this formatting information can be retained when the data is copied and pasted.

To specify the way in which cell formatting is pasted into the spreadsheet:

  1. Click File, then click Options. The Options dialog appears.
  2. Click the Spreadsheet tab.
  3. Specify the way in which cell formatting is pasted into the spreadsheet in the Pasting from other programs field:
    • 'Keep text only'. When pasting data that has been copied from another application, or from the Powerproject spreadsheet, only the data is pasted. Any formatting of the source cells is ignored. The data takes on the formatting of the destination spreadsheet cells.
    • 'Merge formatting'. When pasting data that has been copied from another application, only the data is pasted. Any formatting of the source cells is ignored. The data takes on the formatting of the destination spreadsheet cells.

      When pasting data that has been copied from the Powerproject spreadsheet, both the data and the formatting are pasted. Any formatting of the source cells is merged with the formatting of the destination spreadsheet cells: if a source cell has specific formatting applied, this will overwrite the formatting of the destination cell.
    • 'Keep source formatting'. When pasting data that has been copied from another application, or from the Powerproject spreadsheet, both the data and the formatting are pasted. Any formatting of the source cells is merged with the formatting of the destination spreadsheet cells: if a source cell has specific formatting applied, this will overwrite the formatting of the destination cell.
  4. Click OK.

If you are going to copy and paste data from other applications into Powerproject and you want to retain the formatting, select 'Keep source formatting'; otherwise, select one of the other two options, as 'Keep source formatting' introduces specific cell formatting into the spreadsheet which can degrade the performance of large projects over time.

You may be able to paste data with formatting that has been copied from the Powerproject spreadsheet into other applications as well as into Microsoft Project and Microsoft Excel. If a simple Paste does not copy the formatting into an application, try using the Paste Special command instead.

Copying and pasting unformatted data

You can enter data into a text editor such as Notepad or Wordpad, then paste it into the spreadsheet.

When you enter information into a text editor to be pasted into the spreadsheet, you must separate the different columns of data using TABs. For example, you would format a list of task titles and task start dates as follows:

Task One

25/01/2021

Task Two

24/02/2021

Task Three

17/03/2021

To copy and paste information from a text editor:

  1. Enter your information into the text editor, using TABs to separate the different columns of data.
  2. In your text editor, cut or copy the data to the Clipboard.
  3. In Powerproject, select the cells into which you want to paste the data.
  4. On the Home tab, in the Clipboard group, click the Paste dropdown and select Paste.

Related Topics:

Formatting spreadsheet cells