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

Kamelia AngelovaJan 30, 2014, 19:25 IST

Your browser doesn't support HTML5 video.

kalturavideoplaceholder

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.

Produced by Daniel Goodman and Walter Hickey. Originally published in July 2013.