From time to time you might encounter the prompt that appears when Excel thinks you can't add additional columns or rows.
This occurs when Excel considers used range of the worksheet to encompass all columns or rows. In this article I'll describe some techniques you can use to overcome this problem.
Figure 1: It's frustrating when Excel won't allow you to insert columns or rows.
About David Ringstrom, CPA
David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. His mantra is “Either you work Excel, or it works you.” David offers spreadsheet and database consulting services nationwide.