Share via

CTRL+A in cell does not selects all word it does formula when cell is free and nothing is typed but when something is typed nothing does

Anonymous
2023-03-24T08:26:09+00:00

Hello, CTRL+A in cell does not selects all words. It does formula when cell is free and nothing is typed but when something is typed nothing does. I want to do on CTRL+A to select all words in the cell excel 2016 professional.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

5 answers

Sort by: Most helpful
  1. Anonymous
    2023-03-27T07:55:06+00:00

    I want to select all text in one cell with ctrl + a

    in cell I mean that in one graph I fill text "bla bla bla bla bla" and I want to select only in one graph all text with ctrl+a but it does not work

    Was this answer helpful?

    6 people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2023-03-24T08:42:51+00:00

    Customize button is also missing.

    Was this answer helpful?

    6 people found this answer helpful.
    0 comments No comments
  3. Nikolino 2,120 Reputation points
    2023-03-25T11:57:54+00:00

    Select all Commants and serch...

    Did you pre-press Caps Lock or press Shift with the CTRL+A shortcut?

    • Ctrl+A is used to select all cells in a worksheet or a range of cells.
    • You can use other shortcuts to select different parts of a worksheet, such as:
      • Ctrl+Shift+End to select from the active cell to the last used cell on the sheet (lower right corner).
      • Ctrl+Space to select the entire column.
      • Shift+Space to select the entire row.
    • You can also use VBA code to select all cells or a specific range of cells using ActiveSheet.UsedRange or Range(“A1:C3”) respectively.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  4. Nikolino 2,120 Reputation points
    2023-03-24T08:31:39+00:00

    One possible reason why Ctrl+A is not selecting all words in a cell is that it is assigned to a different command. To check this, you can follow these steps:

    1. Go to File > Options > Customize Ribbon
    2. Click on the Customize… button next to Keyboard shortcuts
    3. Place the selection in the Press new shortcut key control and press Ctrl+A
    4. See what it is currently assigned to. It should be to EditSelectAll.

    If it is not assigned to EditSelectAll, you can change it by selecting EditSelectAll from the Commands list and clicking Assign.

    I hope this helps you.

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2023-03-24T08:30:06+00:00

    I am using office 2016 professional and problem is in the excell

    Was this answer helpful?

    0 comments No comments