I have a file that originates from an Office 2010 or 2007 platform, when copying/moving the sheet to a new workbook the theme colours change to different shades of yellow and grey (from pale red, blue, green and purple). This is the case even when colour pallets of both workbooks are the same, resetting the colours in Options -> Save -> Colours -> reset will not make any change.Įg. Upon doing this, all colours would change to a different theme, including the colours of charts. To have all contents pertaining to a sheet (including floating objects) one would have to move/copy the sheet to the new/destination workbook. Selecting all from the worksheet, and pasting all in new workbook would paste floating objects, however colour change issue will persist. You can also reference values in another sheet by using the sheet name and cell name separated by an exclamation point. This option will only work when there are no floating objects (charts, diagrams, shapes) in that worksheet. Answer (1 of 4): You can select a column, then choose Copy or Cut from the right-click menu, then paste the column into another sheet. Let's say that we are using the "Paste Special - All using source theme" option, only your data and formatting from the original worksheet would be retained, floating objects would not be copied over.
I have done some troubleshooting with colour change when moving/copying sheets to new workbooks that hasn't been documented very well online, for which a solution is yet to be found, and my findings are as follows:
0 kommentar(er)
