Editing Data Directly
To replace data by a specific value:
- Select data.
In the context menu, select Fill with value.
The Fill with value dialog box opens.
- Enter the new value.
Click OK.
The data changes accordingly. An arrow next to the data indicates that the data on the working page has been changed from the data on the reference page.
See also