pasting formulas and keep source formatting
Is there any way to copy and paste formulas and keep the source formatting
in Excel 2007? Is it available in later version of Office? Thanks for your help? It seems if I want to keep the source formatting and I need to just click paste and then I lose the formulas.
Solutions to the Problem pasting formulas and keep source formatting
I don't have 2007 on this system to check with, but in 2010 there is this option under the Paste dropdown that copies formulas and all of the source cell's formatting (number, colors and conditional formatting)
If that's not available you could do it with Paste Special in 2 operations: first paste the formulas, then the formats.
In this method we will try to Boot in Safe mode with Networking and see if the error still persists.
- Search "MSCONFIG" and Open.
- Click on Boot Tab
- Tick Safe Boot in Boot Option
- Select Network.
- Click Apply and OK.
- Reboot your System.
Another Safe way to Fix the Problem: pasting formulas and keep source formatting:
How to Fix pasting formulas and keep source formatting with SmartPCFixer?
1. Download SmartPCFixer. Install it on your system.
2. After the scan is done, you can see the errors and problems need to be repaired. Click Fix All.
3. When the Fixing part is done, your computer has been speeded up and the errors have been fixed
Related: Sum two columns from one workbook to one column in another workbook the value of the property fire page is null or undefined not a function object switching windows 7 laptops from 1 domain to another without losing user accounts What is the status on MS support for Office 2007 products It appears that MS Access 2007 can not longer create new databases in mdb format The Following Files Did Not Self Register Or Unregister Weather Channel App will not install in my new Asus Win 7 trying to fix a check disk error cannot open volume for direct access the procedure entry point ASN1PERDecZeroTableCharStringNoAlloc could not be located in the dynamic link library MSASN1 dll Unable to Insert symbol in worksheet Cannot select symbol to highlight and insert Task manager runs in admin mode but cannot execute commands in non admin mode virturalization client service not running on Office Starter 2010 Volume Mute keys not responding on Comfort Curve 2000 keyboard Websites will not Automatically update with Internet Explorer 9 What is blue screen of death meassage that reads Bad spool header or IRQL not less or equal when checking windows performance index it gives an error message cannot check video playbacks Streets and Trips construction information not updated or missing a major work zone on I65,What Can I Do If My Computer Will Only Start Up To Just Before Windows Log In Screen And Goes To Safe Mode, Last Known Good Start Up Screen Over And Over?,I Get The Following Message: Windows Installer Service Could Not Be Accessed. Anyone Know What I Can Do?,Bluetooth Mouse For ACER Aspire S7 Keep Disconnected After Upgraded To Windows 8.1 -,Windows Media Player For Windows 7 Won't Start / Launch.,I Keep Getting Error Code 490 When I Try To Install The Service Pack 2 For Windows Vista. Does Anyone Have Any Ideas On How To Correct This Problem? Is It Very Common?
Read More: How to Resolve - How to retain the formatting of row and column labels in pivot tables?,Tech Support: Word: showing page number of multiple sections,Fast Solution to Error: windows live messenger sign in not working,[Solution] Footer page numbers are not appearing when saved as a PDF,How Can I Fix - Cant boot into windows 8 after resizing primary drive.?,Calculating Business Days & Error,How do we delete history for google search provider on ie8?,How to reliably name querytables on adding them to the QueryTables collection.,W7U-64 not allowing System Restore Points - Event 8193 VSS, Error 0x80042306,how do i open files with numbers like 3B6E783A7A45CC60BF035C9BA8C7AB9D