You can use the Report Viewer to edit, reformat, or change anything in the report.
To edit the data inside the cells (either headings or data values), position the cursor over the cell box, click the mouse button, and enter the new data.
To insert a new row (which pushes the current row down), click the number of the row where you want to insert the row and click Edit » Insert.
To move data from selected cell(s) to a new location, complete the following steps:
Highlight the desired cell(s).
Click Edit » Cut.
Click the cursor in the new cell location.
Click Edit » Paste.
To copy data from selected cell(s) to another location, complete the following steps:
Highlight the desired cell(s).
Click Edit » Copy.
Click the cursor in the new cell location.
Click Edit » Paste. To paste the new data into the new cell(s) without copying the formatting, click Edit » Paste Values.
To copy data from a selected cell to fill a lot of cells in the same column, complete the following steps:
Highlight the desired cell to be copied and the target cells below it to be filled.
Click Edit » Copy Down, or press Ctrl+D.
To copy data from a selected cell to fill a lot of cells in the same row, complete the following steps:
Highlight the desired cell to be copied and the target cells to its right to be filled.
Click Edit » Copy Right, or press Ctrl+R.
To delete a single or multiple cells, highlight the cell(s) and click Edit » Delete or press Ctrl+K.
To delete an entire row, highlight the row by clicking on the row number and click Edit » Delete or press Ctrl+K.
To clear all the values in a cell or row, highlight the cell(s) or row and click Edit » Clear or press the Delete key. A dialog box prompts you to select All, Formats, or Values. To clear the format changes you made, select Formats. To delete the values in the cells but keep the formatting, select Values. To delete both values and formatting, select All.
To find cell data, use the Find dialog box. Access the Find dialog box by choosing the Find option on the Edit menu or pressing Ctrl+F.
To search down, choose Search By Rows.
To search to the right, choose Search by Columns.
To look in the cell data for the search string, choose Look in Values.
To look in the formulas the report contains for the string, choose Look in Formulas.
To replace the text that was found, click the Replace button on the Find dialog, or by clicking Edit » Replace or pressing Ctrl+H. You can replace one occurrence at a time, or choose Replace All.
Orientation to the Report Viewer Window