Turning on the option to cut, copy and sort inserted objects with their parent cells
Jump to navigation
Jump to search
Overview
Microsoft Excel provides an option which allows users to turn on and off the option the option to copy objects with their parent cells. It should always be turned on (which is the default). When it is turned off, the publishing functionality of BudgetLink may lose charts.
Turning on the option to cut, copy and sort inserted objects with their parent cells in Microsoft Excel 2013
To turn on the option in Microsoft Excel 2013, follow these steps.
- Start Excel;
- Go to the File menu and choose Options
- Select the Advanced entry in the list on the left hand side;
- Locate the Cut, copy and sort inserted objects with their parent cells item on the right hand side and tick it.
Turning on the option to cut, copy and sort inserted objects with their parent cells in Microsoft Excel 2010
To turn on the option in Microsoft Excel 2010, follow these steps.
- Start Excel;
- Go to the File menu and choose Options
- Select the Advanced entry in the list on the left hand side;
- Locate the Cut, copy and sort inserted objects with their parent cells item on the right hand side and tick it.
Turning on the option to cut, copy and sort inserted objects with their parent cells in Microsoft Excel 2007
To turn on the option in Microsoft Excel 2007, follow these steps.
- Start Excel;
- Click on the Office button and choose Excel Options
- Select the Advanced entry in the list on the left hand side;
- Locate the Cut, copy and sort inserted objects with their parent cells item on the right hand side and tick it.