Consolidating large data sets of weekly records into yearly totals involves highlighting then scrolling down 2-4pages of rows to highlight and then delete. Hit n miss suddenly switches to insert a row count and stops highlight. After initiating row highlighting, tried scrolling in different places but seems to be a random effect, not directly related to the numbers of rows highlighted.
ExcelScreenShot.jpg
Sure EXcel is trying to help, what am I missing?