You
can copy and paste forecasting data from Excel® into several of the
Reconciliation Summary grids or from the grids into Excel®.
-
Open one of the following pages from the page:
-
Balance Sheet and Income Statement
-
Offering Rates
-
Supplemental Data
-
Key Rates
-
Select a
situation and follow the corresponding steps.
| Situation |
Steps |
| Copying and Pasting from Excel® into a Reconciliation
Summary Grid |
- Verify that the data in Excel® does not contain decimals or
commas and adjust the data if needed.
- Copy the data in Excel® to the clipboard.
- Select the beginning cell to paste the data into in the Reconciliation
Summary grid.
- Select Ctrl+V on the keyboard to paste the data into the
Reconciliation Summary grid.
|
| Copying and Pasting from a Reconciliation Summary Grid into Excel® |
- Select the beginning cell that you want to copy in the Reconciliation
Summary grid and drag the cursor across the grid to select all
remaining cells to copy.
- Right-click in the grid and select to either Copy or
Copy with Headers.
You can also select
Ctrl+C on the keyboard to copy cells without
headers.
- Paste the copied data into the appropriate cells in Excel®.
|
-
Select Save.