Never Miss a Beat: Get a snapshot of the issues affecting the IT industry straight to your inbox.
Use Excel's ability to reference other sheets so you canperform any calculation with outside cell references in one sheet.
1 Min Read
MS Excel lets you reference data from different worksheets. To do this, use the worksheet title followed by an exclamation point. This way you can perform any calculation that you would with data or cell references, but within one worksheet.
For instance, in the image below, I took data from Cell B2 of my worksheet titled Software and placed it in cell C2 of the worksheet titled Hardware. I did this by typing =Software!B2 into cell C2 of the Hardware worksheet.
About the Author(s)
You May Also Like
More Insights
Webinars
Editor's Choice
May 2, 2024
While there are plentiful options in cyber resiliency and business continuity tools and platforms, there isn’t one that can knock out everything from sudden cloud outages to prolonged ransomware attacks in a single punch. What can you do to keep the company on its feet no matter what is thrown at it? Find out in this new virtual event.
Reserve Your Seat Now