Define number of cells in a worksheet

  • Thread starter Thread starter mck
  • Start date Start date
M

mck

Hello,

How I define the number of cells available in a worksheet.

For example, I'm working in someone else's workbook where
the sheet only has a1:j10

How can I create this myself?

Thank you!
 
You can't delete the rows in Excel.
But you can hide them if you want like this

This example will hide all rows below row 100

1) Select row 101(Click on 101 to select the whole row)
2) Ctrl-Shift-down Arrow to select all rows below row 101
3) Right click on the selection
4) Choose Delete first to be sure that all the cells are empty
5) Right click on the selection again and choose Hide

You can do the same for your Columns
 
Back
Top