Excel not Inserting new or copied lines
20 years of Excel and I’ve never had this problem before. Excel is not Inserting (new or copied) lines on two separate files I have open. It is a simple pricing sheet with 10-12 columns (some descriptive, some formulas taking info from 2 or 3 columns in the same line and I want to add several lines of new products above my Totalizing line.
I’ve always highlighted 8 lines,, copied and inserted above the top highlighted line. Today it does nothing. Same if I highlight 8 lines and right click and choose insert lines.. Again nothing. I assume it must be a SETTING of some sort but cant find anything to lead me to it.
What is going on? Help
20 years of Excel and I’ve never had this problem before. Excel is not Inserting (new or copied) lines on two separate files I have open. It is a simple pricing sheet with 10-12 columns (some descriptive, some formulas taking info from 2 or 3 columns in the same line and I want to add several lines of new products above my Totalizing line.I’ve always highlighted 8 lines,, copied and inserted above the top highlighted line. Today it does nothing. Same if I highlight 8 lines and right click and choose insert lines.. Again nothing. I assume it must be a SETTING of some sort but cant find anything to lead me to it. What is going on? Help Read More