Delete multiple Rows in Multiple Sheets

[Rumpkin]

I can no longer delete multiple rows in multiple sheets.

All the addresses are the same in all the sheets.

I used to be able to highlight multiple sheets (CNTRL + SHIFT + PAGE UP or DOWN)

Then highlight multiple rows (F8 ARROW down or up, then SHFT + SPACE BAR) and delete those rows in every sheet and repeat a necessary to clean up the multiple sheets.

 

[Dan_W]

Those keyboard shortcuts still work. I just checked them again, and it worked for me. The only thing I can think of is to check to make sure the SCROLL LOCK is off. That can prevent you from using the keyboard to select cells.

Other than that, the keyboard itself? My control button stopped working week, and I've had to replace it. It happens.

 

[Rumpkin]

Thanks. I'll try a different board

 

[Dan_W]

Ok. I take it that means that Scroll Lock wasn't an issue for you then?

 

[Rumpkin]

Correct.
Sorry for the delayed response. I took off for a couple of days.
It is not in that particular workbook.
I duplicated it in two other "new" workbooks with different data and formulas.
Has to be in the program. - - - EXCEL 2019

 

[Dan_W]

Sorry for the delayed response. I took off for a couple of days

Not at all - it was the weekend. Also, life has a habit of getting in the way. No apology necessary.
I'm sorry I can't be of any help to you. The only thing I can think of is perhaps a real life 'debugging' of your process. Where does it stop working? eg:

I used to be able to highlight multiple sheets (CNTRL + SHIFT + PAGE UP or DOWN)

Are you able to select each of the sheets through ctrl+shft+pgup/pgdown? Can you see that they've been selected? Does it work if select the sheet tabs with the mouse (and either shift or ctrl)?

Then highlight multiple rows (F8 ARROW down or up, then SHFT + SPACE BAR) and delete those rows in every sheet and repeat a necessary to clean up the multiple sheets.

Forgetting the above step for a moment, does F8 work? Are you able to sticky select multiple cells with the arrow keys after pressing F8? Also, separate from that, does Shift+space or Ctrl+space allow you to select the row/column?

If each of those elements work, then I'm wondering whether there is some kind of protection in place.

 

[Rumpkin]

All that works.
The process will delete the first batch of rows across the selected worksheets but not a second time.
It will delete the rows in the last selected sheets, multiple times.
My thought is the the data calculation may be too big.