ログイン

excel shortcuts
50問 • 1年前
  • Suhrid Saha
  • 通報

    問題一覧

  • 1

    Shows Excel Help

    f1

  • 2

    Enters edit mode for the active cell

    f2

  • 3

    Displays the Paste Name dialog box if there is a defined name

    f3

  • 4

    Repeats the last action. Also, writing a formula allows you to switch between relative, absolute, and mixed references.

    f4

  • 5

    Displays the Go To dialog box

    f5

  • 6

    Allows you to move between panels in a divided book

    f6

  • 7

    Displays the Spelling dialog box

    f7

  • 8

    Activates Expand Selection mode, which allows you to enlarge the selected range using the arrow keys

    f8

  • 9

    Calculates the result of formulas for all sheets of open workbooks

    f9

  • 10

    Activates the menu bar

    f10

  • 11

    Creates a chart sheet with the selected cell range

    f11

  • 12

    Displays the Save As dialog box

    f12

  • 13

    Activates the menu bar

    alt

  • 14

    Scrolls down one screen within the sheet

    pg down

  • 15

    Applies bold formatting to selected text

    ctrl b

  • 16

    Copies the contents and format of the topmost cell of a selected range in the below cells

    ctrl d

  • 17

    Invokes Flash Fill to recognize patterns in adjacent columns and fill the current column

    ctrl e

  • 18

    Opens the Go To dialogue box so that you can work on a specific reference (cell)

    ctrl g

  • 19

    Removes line breaks in a cell

    ctrl j

  • 20

    hyperlinks in a cell

    ctrl k

  • 21

    Opens the Create Table dialog box

    ctrl l

  • 22

    Opens an existing workbook

    ctrl o

  • 23

    Opens a new workbook

    ctrl n

  • 24

    Displays the Print dialog box

    ctrl p

  • 25

    Fills the row cell(s) to the right with the contents of the selected cell/Aligns a cell with the contents of the left cell

    ctrl r

  • 26

    Displays the Create Table dialog box

    ctrl t

  • 27

    Redoes the last undone action

    ctrl y

  • 28

    Opens the Format Cells dialog box

    ctrl 1

  • 29

    Applies bold formatting to selected text

    ctrl 2

  • 30

    Applies italic formatting to selected text

    ctrl 3

  • 31

    Underlines the selected text

    ctrl 4

  • 32

    Applies the strikethrough effect to the text

    ctrl 5

  • 33

    Hides or shows the objects on the sheet

    ctrl 6

  • 34

    Shows the outline symbols on the sheet

    ctrl 8

  • 35

    Hides the selected row

    ctrl 9

  • 36

    Hides the selected column

    ctrl 0

  • 37

    Displays/hides the ribbon

    ctrl f1

  • 38

    Displays the print preview area on the Print tab

    ctrl f2

  • 39

    Opens Name Manager dialog box

    ctrl f3

  • 40

    Closes the active workbook

    ctrl f4

  • 41

    Restores the window size of the selected workbook window

    ctrl f5

  • 42

    Switches to the next workbook window if more than one workbook windows is open

    ctrl f6

  • 43

    Allows you to move the workbook window when the window is not maximized

    ctrl f7

  • 44

    Allows you to resize the workbook window when the window is not maximized

    ctrl f8

  • 45

    Minimizes the current workbook window to an icon

    ctrl f9

  • 46

    Maximizes the window of a minimized workbook

    ctrl f10

  • 47

    Maximizes the window of a minimized workbook

    ctrl f11

  • 48

    displays open dialog box

    ctrl f12

  • 49

    Insert a note. Open and edit a cell note

    shift f2

  • 50

    Displays the Insert Function dialog box. Editing a formula displays the Function Arguments dialogue box.

    shift f3

  • 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

    Shows Excel Help

    f1

  • 2

    Enters edit mode for the active cell

    f2

  • 3

    Displays the Paste Name dialog box if there is a defined name

    f3

  • 4

    Repeats the last action. Also, writing a formula allows you to switch between relative, absolute, and mixed references.

    f4

  • 5

    Displays the Go To dialog box

    f5

  • 6

    Allows you to move between panels in a divided book

    f6

  • 7

    Displays the Spelling dialog box

    f7

  • 8

    Activates Expand Selection mode, which allows you to enlarge the selected range using the arrow keys

    f8

  • 9

    Calculates the result of formulas for all sheets of open workbooks

    f9

  • 10

    Activates the menu bar

    f10

  • 11

    Creates a chart sheet with the selected cell range

    f11

  • 12

    Displays the Save As dialog box

    f12

  • 13

    Activates the menu bar

    alt

  • 14

    Scrolls down one screen within the sheet

    pg down

  • 15

    Applies bold formatting to selected text

    ctrl b

  • 16

    Copies the contents and format of the topmost cell of a selected range in the below cells

    ctrl d

  • 17

    Invokes Flash Fill to recognize patterns in adjacent columns and fill the current column

    ctrl e

  • 18

    Opens the Go To dialogue box so that you can work on a specific reference (cell)

    ctrl g

  • 19

    Removes line breaks in a cell

    ctrl j

  • 20

    hyperlinks in a cell

    ctrl k

  • 21

    Opens the Create Table dialog box

    ctrl l

  • 22

    Opens an existing workbook

    ctrl o

  • 23

    Opens a new workbook

    ctrl n

  • 24

    Displays the Print dialog box

    ctrl p

  • 25

    Fills the row cell(s) to the right with the contents of the selected cell/Aligns a cell with the contents of the left cell

    ctrl r

  • 26

    Displays the Create Table dialog box

    ctrl t

  • 27

    Redoes the last undone action

    ctrl y

  • 28

    Opens the Format Cells dialog box

    ctrl 1

  • 29

    Applies bold formatting to selected text

    ctrl 2

  • 30

    Applies italic formatting to selected text

    ctrl 3

  • 31

    Underlines the selected text

    ctrl 4

  • 32

    Applies the strikethrough effect to the text

    ctrl 5

  • 33

    Hides or shows the objects on the sheet

    ctrl 6

  • 34

    Shows the outline symbols on the sheet

    ctrl 8

  • 35

    Hides the selected row

    ctrl 9

  • 36

    Hides the selected column

    ctrl 0

  • 37

    Displays/hides the ribbon

    ctrl f1

  • 38

    Displays the print preview area on the Print tab

    ctrl f2

  • 39

    Opens Name Manager dialog box

    ctrl f3

  • 40

    Closes the active workbook

    ctrl f4

  • 41

    Restores the window size of the selected workbook window

    ctrl f5

  • 42

    Switches to the next workbook window if more than one workbook windows is open

    ctrl f6

  • 43

    Allows you to move the workbook window when the window is not maximized

    ctrl f7

  • 44

    Allows you to resize the workbook window when the window is not maximized

    ctrl f8

  • 45

    Minimizes the current workbook window to an icon

    ctrl f9

  • 46

    Maximizes the window of a minimized workbook

    ctrl f10

  • 47

    Maximizes the window of a minimized workbook

    ctrl f11

  • 48

    displays open dialog box

    ctrl f12

  • 49

    Insert a note. Open and edit a cell note

    shift f2

  • 50

    Displays the Insert Function dialog box. Editing a formula displays the Function Arguments dialogue box.

    shift f3