Translations:Basic Excel/25/en

We could use a number of methods to select our entire dataset at once. However, the quickest and easiest method is one that we have not yet used: CTRL+A.

  • This method selects all cells in a contiguous data block.
    • This is perfectly appropriate for the Data asli worksheet.
  • Switch back to the Copy perkejaan worksheet, and see what happens if you use CTRL+A here:
    Using CTRL+A on a non-contiguous dataset
    • Can you suggest a methods of selecting all occupied cells on this worksheet?