Intro – Working across multiple worksheets at once!
Excel’s workbook can be divided in several worksheets and by design its quite efficient as worksheets can act and work as independent unit and still easily interact in other worksheets or workbooks if required.
Although each worksheet is worked upon separately i.e. one at a time, but need can arise to work on and edit in multiple worksheets simultaneously. Today we are exploring three tricks that can make you Excel multi-worksheet-pro!