Use Excel 2013 this instance!

BY J. CARLTON COLLINS, CPA

Q: When I open two Excel files in two instances of Excel and display them on two monitors, I find that I cannot then copy formulas back and forth between the files—only the formula’s calculated value is pasted to the other instance of Excel. What’s happening here, and what can I do about it?

A: This particular question was asked and answered in the May 2011 topic “An Excellent Arrangement,” (page 70) but I am revisiting this topic to inform you that Excel 2013 now opens each Excel file in its own instance of Excel (just like Word has always done), making it easier to display separate Excel files on separate monitors and to copy data back and forth between files with formulas intact.

SPONSORED REPORT

8 accounting and auditing issues you can’t afford to ignore

Download this sponsored report for an overview of some of the most important developments accountants and auditors are facing today.

DOWNLOAD

Filing season quick guide — Tax year 2014

Tax season started Jan. 20. Download our “quick guide,” a printable card that contains dollar thresholds, tax tables, standard amounts, credits, and deductions to keep at your fingertips during tax season.

TAX NEWS

Expired tax provisions extended for 2014

President Barack Obama signed legislation that retroactively extended more than 50 expired tax provisions for 2014, allowing taxpayers to take advantage of a host of tax incentives during this filing season.