Shortcut to delete an entire column using excel-

Actuary Forums › Forums › Learnings › Daily Dose › Shortcut to delete an entire column using excel-

  • This topic is empty.
Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • January 18, 2019 at 2:38 pm #23171
    shreyanshh
    Participant

      Step 1- take the cursor to the header of the column which you want to delete.

      Step 2- select the entire column by pressing together the keys- Ctrl+shift + down arrow key

      Step 3 – go to home tab by pressing together the keys – alt+H

      Step 4 – go to delete tab by pressing together the keys – alt+D

      Step 5- press the key– alt + D again to select delete cell option.

      The entire selected column will be deleted.

      Sent from my S6s using Actuarial Info mobile app

      January 18, 2019 at 5:18 pm #24436
      kushaltagupta
      Participant

        Or Select the column by Ctrl+Space bar and then press Ctrl+ –

        Sent from my ONEPLUS A6000 using Actuarial Info mobile app

        January 18, 2019 at 5:22 pm #24437
        shreyanshh
        Participant

          KushaltaGupta wrote:

          Or Select the column by Ctrl+Space bar and then press Ctrl+ –

          Sent from my ONEPLUS A6000 using Actuarial Info mobile app

          This is far more short cut method. I didn’t knew about it. Thank you.

          Sent from my S6s using Actuarial Info mobile app

          January 18, 2019 at 5:25 pm #24438
          kushaltagupta
          Participant

            Happy to help :) :)

            Sent from my ONEPLUS A6000 using Actuarial Info mobile app

          • Author
            Posts
          Viewing 4 posts - 1 through 4 (of 4 total)
          • You must be logged in to reply to this topic.

          Actuary Forums › Forums › Learnings › Daily Dose › Shortcut to delete an entire column using excel-