Has anyone had this problem:

I have a spreadsheet with multiple tabs.  On the first tab I can selec
a group of cells within a column, lets say B12 -- B45 and right click o
them, get the option 'Delete...' and it asks if I want to shift left
up, entire row, or entire column.  Now, on the second tab I select th
same group of cells except now when I right click it will only let m
delete rows.  

Any ideas as to what I am missing here