暗記メーカー

暗記メーカー

​
ログイン
excel shortcuts 2
50問 • 1年前
  • Suhrid Saha
    • 通報

    問題一覧

  • 1

    selects the current region of the cells with data

    ctrl + *

  • 2

    select the current column

    ctrl + space

  • 3

    extends the selection down to one screen

    shift+ pg down

  • 4

    extends the selection up to one screen

    shft + pg up

  • 5

    extends the selection to the beginning of the row

    shft + home

  • 6

    selects the current row

    sft + space

  • 7

    extends the selection of one cell in the same direction as the key pressed

    sft + direction key

  • 8

    inserts an autosum of the adjacent cells

    alt + =

  • 9

    displays options of data validation list

    alt + down

  • 10

    inserts a line break within a cell

    alt + enter

  • 11

    inserts the current date

    ctrl + comma

  • 12

    inserts the current time

    ctrl + :

  • 13

    copies the value of the cell above

    ctrl + double quote

  • 14

    copies formula from above cell

    ctrl + single quote

  • 15

    fills the selected range with the current input

    ctrl enter

  • 16

    deletes all text to end of the line

    ctrl + delete

  • 17

    insert a hyperlink

    ctrl + alt + K

  • 18

    completes cell entry and selects the top cell

    sft + enter

  • 19

    completes cell entry and selects the cell to the left

    sft + tab

  • 20

    opens the excel window control menu

    alt + space

  • 21

    displays the style dialog box

    alt + single quote

  • 22

    moves left between non adjacent cells in a range

    alt + ctrl + left

  • 23

    moves right between non adjacent cells in selected range

    alt + ctrl + right

  • 24

    displays the delete cells dialog box

    ctrl + -

  • 25

    displays the insert cells dialog box

    ctrl ++

  • 26

    displays the paste special dialog box

    ctrl + alt + V

  • 27

    Move to the end of the current row or column according to the direction key pressed.

    ctrl direction key

  • 28

    swithces btw open workbooks

    ctrl tab

  • 29

    gets you back to your active cell

    ctrl backspace

  • 30

    move to the last used cell in the current range

    ctrl end

  • 31

    move to cell A1

    ctrl home

  • 32

    move up in a given range

    ctrl pgup

  • 33

    move down in a given range

    ctrl pgdown

  • 34

    Moves the worksheet one page to the left

    alt pageup

  • 35

    Moves the worksheet one page to the right

    alt pgdown

  • 36

    copies the cell's content above

    ctrl sft ""

  • 37

    removes cell borders

    ctrl sft &

  • 38

    applies border to the cell

    ctrl sft :

  • 39

    applies time format

    ctrl sft /

  • 40

    applies scientific notion format

    ctrl sft %

  • 41

    applies percent format without decimals

    ctrl sft $

  • 42

    applies currency in two decimals format

    ctrl sft #

  • 43

    applies the number in two decimals format

    ctrl sft !

  • 44

    show hidden columns within selected range

    ctrl sft )

  • 45

    show hidden rows within the selected range

    ctrl sft (

  • 46

    select current cell range or entire sheet

    ctrl sft space

  • 47

    extends the selection to the last non empty cell in the same direction as the key pressed

    ctrl sft direction key

  • 48

    adds previous sheet to sheet selection

    ctrl sht page up

  • 49

    adds the next sheet to the selection of sheets

    ctrl sft pgdown

  • 50

    extends the selection to the last used cell on the sheet

    ctrl sft end

    • height and distance

    height and distance

    Suhrid Saha · 32問 · 2年前

    height and distance

    height and distance

    32問 • 2年前
    Suhrid Saha

    idioms 4

    idioms 4

    Suhrid Saha · 49問 · 2年前

    idioms 4

    idioms 4

    49問 • 2年前
    Suhrid Saha

    Terms for studies

    Terms for studies

    Suhrid Saha · 42問 · 2年前

    Terms for studies

    Terms for studies

    42問 • 2年前
    Suhrid Saha

    suhrid biology important names scientists

    suhrid biology important names scientists

    Suhrid Saha · 50問 · 2年前

    suhrid biology important names scientists

    suhrid biology important names scientists

    50問 • 2年前
    Suhrid Saha

    biological term names (suhrid)

    biological term names (suhrid)

    Suhrid Saha · 48問 · 2年前

    biological term names (suhrid)

    biological term names (suhrid)

    48問 • 2年前
    Suhrid Saha

    differences in cells

    differences in cells

    Suhrid Saha · 6問 · 2年前

    differences in cells

    differences in cells

    6問 • 2年前
    Suhrid Saha

    obituaries August 2023

    obituaries August 2023

    Suhrid Saha · 16問 · 2年前

    obituaries August 2023

    obituaries August 2023

    16問 • 2年前
    Suhrid Saha

    event names

    event names

    Suhrid Saha · 19問 · 2年前

    event names

    event names

    19問 • 2年前
    Suhrid Saha

    GI tags

    GI tags

    Suhrid Saha · 47問 · 2年前

    GI tags

    GI tags

    47問 • 2年前
    Suhrid Saha

    Imp themes 2023(suhrid)

    Imp themes 2023(suhrid)

    Suhrid Saha · 89問 · 2年前

    Imp themes 2023(suhrid)

    Imp themes 2023(suhrid)

    89問 • 2年前
    Suhrid Saha

    birth defects

    birth defects

    Suhrid Saha · 7問 · 2年前

    birth defects

    birth defects

    7問 • 2年前
    Suhrid Saha

    no. of chromosomes

    no. of chromosomes

    Suhrid Saha · 15問 · 2年前

    no. of chromosomes

    no. of chromosomes

    15問 • 2年前
    Suhrid Saha

    body parts similarity

    body parts similarity

    Suhrid Saha · 7問 · 2年前

    body parts similarity

    body parts similarity

    7問 • 2年前
    Suhrid Saha

    category and main plants

    category and main plants

    Suhrid Saha · 11問 · 2年前

    category and main plants

    category and main plants

    11問 • 2年前
    Suhrid Saha

    edible parts of fruits

    edible parts of fruits

    Suhrid Saha · 18問 · 2年前

    edible parts of fruits

    edible parts of fruits

    18問 • 2年前
    Suhrid Saha

    one word pyq 1

    one word pyq 1

    Suhrid Saha · 50問 · 2年前

    one word pyq 1

    one word pyq 1

    50問 • 2年前
    Suhrid Saha

    one word pyq 2

    one word pyq 2

    Suhrid Saha · 50問 · 2年前

    one word pyq 2

    one word pyq 2

    50問 • 2年前
    Suhrid Saha

    問題一覧

  • 1

    selects the current region of the cells with data

    ctrl + *

  • 2

    select the current column

    ctrl + space

  • 3

    extends the selection down to one screen

    shift+ pg down

  • 4

    extends the selection up to one screen

    shft + pg up

  • 5

    extends the selection to the beginning of the row

    shft + home

  • 6

    selects the current row

    sft + space

  • 7

    extends the selection of one cell in the same direction as the key pressed

    sft + direction key

  • 8

    inserts an autosum of the adjacent cells

    alt + =

  • 9

    displays options of data validation list

    alt + down

  • 10

    inserts a line break within a cell

    alt + enter

  • 11

    inserts the current date

    ctrl + comma

  • 12

    inserts the current time

    ctrl + :

  • 13

    copies the value of the cell above

    ctrl + double quote

  • 14

    copies formula from above cell

    ctrl + single quote

  • 15

    fills the selected range with the current input

    ctrl enter

  • 16

    deletes all text to end of the line

    ctrl + delete

  • 17

    insert a hyperlink

    ctrl + alt + K

  • 18

    completes cell entry and selects the top cell

    sft + enter

  • 19

    completes cell entry and selects the cell to the left

    sft + tab

  • 20

    opens the excel window control menu

    alt + space

  • 21

    displays the style dialog box

    alt + single quote

  • 22

    moves left between non adjacent cells in a range

    alt + ctrl + left

  • 23

    moves right between non adjacent cells in selected range

    alt + ctrl + right

  • 24

    displays the delete cells dialog box

    ctrl + -

  • 25

    displays the insert cells dialog box

    ctrl ++

  • 26

    displays the paste special dialog box

    ctrl + alt + V

  • 27

    Move to the end of the current row or column according to the direction key pressed.

    ctrl direction key

  • 28

    swithces btw open workbooks

    ctrl tab

  • 29

    gets you back to your active cell

    ctrl backspace

  • 30

    move to the last used cell in the current range

    ctrl end

  • 31

    move to cell A1

    ctrl home

  • 32

    move up in a given range

    ctrl pgup

  • 33

    move down in a given range

    ctrl pgdown

  • 34

    Moves the worksheet one page to the left

    alt pageup

  • 35

    Moves the worksheet one page to the right

    alt pgdown

  • 36

    copies the cell's content above

    ctrl sft ""

  • 37

    removes cell borders

    ctrl sft &

  • 38

    applies border to the cell

    ctrl sft :

  • 39

    applies time format

    ctrl sft /

  • 40

    applies scientific notion format

    ctrl sft %

  • 41

    applies percent format without decimals

    ctrl sft $

  • 42

    applies currency in two decimals format

    ctrl sft #

  • 43

    applies the number in two decimals format

    ctrl sft !

  • 44

    show hidden columns within selected range

    ctrl sft )

  • 45

    show hidden rows within the selected range

    ctrl sft (

  • 46

    select current cell range or entire sheet

    ctrl sft space

  • 47

    extends the selection to the last non empty cell in the same direction as the key pressed

    ctrl sft direction key

  • 48

    adds previous sheet to sheet selection

    ctrl sht page up

  • 49

    adds the next sheet to the selection of sheets

    ctrl sft pgdown

  • 50

    extends the selection to the last used cell on the sheet

    ctrl sft end