Infrastructure // PC & Servers
News
7/9/2011
10:11 PM
50%
50%

Reference Other Worksheets in Excel To Work from Just One

Use Excel's ability to reference other sheets so you canperform any calculation with outside cell references in one sheet.

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.

Comment  | 
Print  | 
More Insights
Server Market Splitsville
Server Market Splitsville
Just because the server market's in the doldrums doesn't mean innovation has ceased. Far from it -- server technology is enjoying the biggest renaissance since the dawn of x86 systems. But the primary driver is now service providers, not enterprises.
Register for InformationWeek Newsletters
White Papers
Current Issue
InformationWeek Tech Digest, Dec. 9, 2014
Apps will make or break the tablet as a work device, but don't shortchange critical factors related to hardware, security, peripherals, and integration.
Video
Slideshows
Twitter Feed
InformationWeek Radio
Archived InformationWeek Radio
Join us for a roundup of the top stories on InformationWeek.com for the week of December 7, 2014. Be here for the show and for the incredible Friday Afternoon Conversation that runs beside the program!
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.