If you have several excel sheets to work on and all the sheets share exactly the same data with exactly the same format. Than instead of copying and pasting the same data on different sheets we have a much better way for you do to do this in Excel.
Have the workbook open, press and hold down the Ctrl key on your keyboard and select the worksheets on which you want the same data by left clicking on respect worksheet tabs.
After selection is complete start entering your data and format it as you like and everything will be reproduced on other sheets as well. Multitasking redefined! 🙂
Once a wise man said, if you have control even your clicks makes you excel! – Proved!
Thanks for sharing very helpful trick.
Great tips and tricks to make life of XL user easier. Thanks.
Great job.
Awesome article. I read your article it is very beneficial.
I really like your article about excel.
You share good information about excel.