Cookies on the Business Insider India website

Business Insider India has updated its Privacy and Cookie policy. We use cookies to ensure that we give you the better experience on our website. If you continue without changing your settings, we\'ll assume that you are happy to receive all cookies on the Business Insider India website. However, you can change your cookie setting at any time by clicking on our Cookie Policy at any time. You can also see our Privacy Policy.

This Excel Trick Lets You Work Across Sheets Without Switching Between Tabs

Daniel Goodman,Walter HickeyJul 31, 2013, 00:16 IST

Your browser doesn't support HTML5 video.

Microsoft Excel offers many ways for you to manipulate and organize data, including using multiple "sheets" or tabs within the same spreadsheet file.

Occasionally, you may find it useful to be able to quickly add sums across tabs. Luckily, Excel has a function for this too.

Watch below to learn about 3D SUM, a quick way to work with data across sheets:

kalturavideoplaceholder

Produced by Daniel Goodman