anything in Excel...

It's Excel-o-lozy...

Shortcut - How to work in multiple sheets altogether...

Suppose u need to work in more than 1 sheet...
e.g. inserting a row in some sheets at same place or
formatting a specific area that is same in some sheets ...

Rather than doing same work in all sheets or recording a macro to repeat work do as follows:

All you need to do is Hold down "Ctrl" key and click on sheets u wanna do work simutaneously. Now whatever u do in active sheet, will be done automatically in all selected sheets.

Caution:
As u r done with the work, remember to deselct sheets else u may end up tempering data in other sheets by overting in active sheet. To determine whether multiple sheets r selected or not, carefully monitor Title Bar of Excel, u ll notice name of your file suffixed with "[Group]" i.e. sheets r grouped.
To Deselect sheets simply click non selected sheets, but if all sheets r selected then simply click any selected sheet.

0 comments: