To delete rows or columns:

  1. select the rows or columns you wish to delete.
  2. In the Edit menu, click Delete.  The other rows or columns will shift up or to the left to fill the space left by the deleted rows or columns.
To delete the CONTENTS of rows or columns, not the rows or columns THEMSELVES, press FN + DELETE.