Excel : Hangs while inserting rows/columns

Many a times I faced this issue where Excel hangs while inserting rows/columns (and during many other types of edits)
Solutions you can try:

1. Check if the sheet has external links.
2. Press Ctrl+End and delete rows/columns which are beyond the cells actually having data. If there is even a space or a cell which was accidently edited but far from the actual last cell of the sheet then Excel has to move more data.
3. This is most invisible issue: Check conditional formatting applied for cells (Alt+O+D). On the Conditional Formatting Rules Manager (Excel 2010), in Show formatting rules for select "This Worksheet". You should now be able to view all rules applicable for the worksheet. If there are too many rules supposed to do the same formatting then this is your issue. Solution is to delete all similar looking rules and keep single rule applicable to multiple cells/ranges and keep doing the same whenever such cellls are copied to this sheet. Read this for details on how to manage conditional formatting for better performance.