Using keyboard shortcuts
To select cells from any cell to the last cell in the sheet's used range:
The keyboard shortcuts Ctrl+Shift+End and Ctrl+Shift+Home enable the quick selection of cells either down to the last cell of the sheet's Used Range or to the first cell (A1), respectively.
Example:
To clear the cell content from cell A7 to the last cell in the sheet's Used Range (cell G13 in this example):
1. Select cell A7.
2. Press Ctrl+Shift+End.
3. Press Delete.
Screenshot // Selecting Cells from Any Cell to the Last Cell in the Sheet's Used Range
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
Hi, In my project,i use some "Form" controls in my sheet.I placed all the controls inside the Group box.i placed a button above the group box.When i click this button the group box should mimimize(with all controls in it) and the cells should shift up. Can u help me to sort out this problem..plz....
Is there any formula to lock a particular cell if the value in the cell>0?