Translations:Basic Excel/50/en

We recommend performing the following steps:

  1. Go to the cell that is the intersection of the last row with any data and the last column with any data.
    • CTRL+END (or END then HOME)
    • Note the identity of this cell.
  2. Return to the beginning of the dataset
    • CTRL+HOME
    • If this cell (A1) is not the leftmost cell of the header row, navigate to that cell.
  3. Do CTRL+RIGHT ARROW followed by CTRL+DOWN ARROW.
    • Note the identify of this cell. Is it the same as that previously recorded? If so, there are no empty rows or columns in your dataset, and you can safely apply an autofilter.
Diperoleh dari "http://wiki.isikhnas.com/index.php?title=Translations:Basic_Excel/50/en&oldid=8606"