ログイン

excel shortcuts

excel shortcuts
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

  • 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

    military excercises

    military excercises

    Suhrid Saha · 26問 · 2年前

    military excercises

    military excercises

    26問 • 2年前
    Suhrid Saha

    state schemes 2023

    state schemes 2023

    Suhrid Saha · 5問 · 2年前

    state schemes 2023

    state schemes 2023

    5問 • 2年前
    Suhrid Saha

    First in india

    First in india

    Suhrid Saha · 73問 · 2年前

    First in india

    First in india

    73問 • 2年前
    Suhrid Saha

    First in india / world 2023 names

    First in india / world 2023 names

    Suhrid Saha · 12問 · 2年前

    First in india / world 2023 names

    First in india / world 2023 names

    12問 • 2年前
    Suhrid Saha

    asian games 2023

    asian games 2023

    Suhrid Saha · 11問 · 2年前

    asian games 2023

    asian games 2023

    11問 • 2年前
    Suhrid Saha

    appointments revised

    appointments revised

    Suhrid Saha · 27問 · 2年前

    appointments revised

    appointments revised

    27問 • 2年前
    Suhrid Saha

    chemistry names elements

    chemistry names elements

    Suhrid Saha · 50問 · 2年前

    chemistry names elements

    chemistry names elements

    50問 • 2年前
    Suhrid Saha

    conversions

    conversions

    Suhrid Saha · 10問 · 2年前

    conversions

    conversions

    10問 • 2年前
    Suhrid Saha

    bio important scientists names (suhrid)

    bio important scientists names (suhrid)

    Suhrid Saha · 50問 · 2年前

    bio important scientists names (suhrid)

    bio important scientists names (suhrid)

    50問 • 2年前
    Suhrid Saha

    square tables

    square tables

    Suhrid Saha · 49問 · 2年前

    square tables

    square tables

    49問 • 2年前
    Suhrid Saha

    cube tables

    cube tables

    Suhrid Saha · 25問 · 2年前

    cube tables

    cube tables

    25問 • 2年前
    Suhrid Saha

    tables

    tables

    Suhrid Saha · 83問 · 2年前

    tables

    tables

    83問 • 2年前
    Suhrid Saha

    indian names

    indian names

    Suhrid Saha · 100問 · 2年前

    indian names

    indian names

    100問 • 2年前
    Suhrid Saha

    International Names

    International Names

    Suhrid Saha · 100問 · 2年前

    International Names

    International Names

    100問 • 2年前
    Suhrid Saha

    terms

    terms

    Suhrid Saha · 100問 · 2年前

    terms

    terms

    100問 • 2年前
    Suhrid Saha

    domestic cities

    domestic cities

    Suhrid Saha · 25問 · 2年前

    domestic cities

    domestic cities

    25問 • 2年前
    Suhrid Saha

    countries

    countries

    Suhrid Saha · 58問 · 2年前

    countries

    countries

    58問 • 2年前
    Suhrid Saha

    central and state schemes

    central and state schemes

    Suhrid Saha · 19問 · 2年前

    central and state schemes

    central and state schemes

    19問 • 2年前
    Suhrid Saha

    days

    days

    Suhrid Saha · 50問 · 2年前

    days

    days

    50問 • 2年前
    Suhrid Saha

    themes

    themes

    Suhrid Saha · 63問 · 2年前

    themes

    themes

    63問 • 2年前
    Suhrid Saha

    Changed names 2023

    Changed names 2023

    Suhrid Saha · 40問 · 2年前

    Changed names 2023

    Changed names 2023

    40問 • 2年前
    Suhrid Saha

    short forms

    short forms

    Suhrid Saha · 30問 · 2年前

    short forms

    short forms

    30問 • 2年前
    Suhrid Saha

    governors

    governors

    Suhrid Saha · 36問 · 2年前

    governors

    governors

    36問 • 2年前
    Suhrid Saha

    CMs

    CMs

    Suhrid Saha · 28問 · 2年前

    CMs

    CMs

    28問 • 2年前
    Suhrid Saha

    short forms 2

    short forms 2

    Suhrid Saha · 48問 · 2年前

    short forms 2

    short forms 2

    48問 • 2年前
    Suhrid Saha

    days (2)

    days (2)

    Suhrid Saha · 26問 · 2年前

    days (2)

    days (2)

    26問 • 2年前
    Suhrid Saha

    indian names 2

    indian names 2

    Suhrid Saha · 100問 · 2年前

    indian names 2

    indian names 2

    100問 • 2年前
    Suhrid Saha

    indian names 3

    indian names 3

    Suhrid Saha · 64問 · 2年前

    indian names 3

    indian names 3

    64問 • 2年前
    Suhrid Saha

    International names 2

    International names 2

    Suhrid Saha · 7問 · 2年前

    International names 2

    International names 2

    7問 • 2年前
    Suhrid Saha

    terms 2

    terms 2

    Suhrid Saha · 88問 · 2年前

    terms 2

    terms 2

    88問 • 2年前
    Suhrid Saha

    important names

    important names

    Suhrid Saha · 35問 · 2年前

    important names

    important names

    35問 • 2年前
    Suhrid Saha

    terms

    terms

    Suhrid Saha · 8問 · 2年前

    terms

    terms

    8問 • 2年前
    Suhrid Saha

    excel shortcuts 2

    excel shortcuts 2

    Suhrid Saha · 50問 · 2年前

    excel shortcuts 2

    excel shortcuts 2

    50問 • 2年前
    Suhrid Saha

    phrasal verbs

    phrasal verbs

    Suhrid Saha · 36問 · 2年前

    phrasal verbs

    phrasal verbs

    36問 • 2年前
    Suhrid Saha

    Politics names

    Politics names

    Suhrid Saha · 52問 · 1年前

    Politics names

    Politics names

    52問 • 1年前
    Suhrid Saha

    political terms

    political terms

    Suhrid Saha · 61問 · 1年前

    political terms

    political terms

    61問 • 1年前
    Suhrid Saha

    political dates

    political dates

    Suhrid Saha · 47問 · 1年前

    political dates

    political dates

    47問 • 1年前
    Suhrid Saha

    names

    names

    Suhrid Saha · 68問 · 1年前

    names

    names

    68問 • 1年前
    Suhrid Saha

    Important amendments

    Important amendments

    Suhrid Saha · 47問 · 1年前

    Important amendments

    Important amendments

    47問 • 1年前
    Suhrid Saha

    geography names

    geography names

    Suhrid Saha · 28問 · 1年前

    geography names

    geography names

    28問 • 1年前
    Suhrid Saha

    geographical terms 2

    geographical terms 2

    Suhrid Saha · 34問 · 1年前

    geographical terms 2

    geographical terms 2

    34問 • 1年前
    Suhrid Saha

    names

    names

    Suhrid Saha · 57問 · 1年前

    names

    names

    57問 • 1年前
    Suhrid Saha

    Sentence errors 1

    Sentence errors 1

    Suhrid Saha · 12問 · 1年前

    Sentence errors 1

    Sentence errors 1

    12問 • 1年前
    Suhrid Saha

    composition of alloys

    composition of alloys

    Suhrid Saha · 12問 · 1年前

    composition of alloys

    composition of alloys

    12問 • 1年前
    Suhrid Saha

    misc

    misc

    Suhrid Saha · 19問 · 1年前

    misc

    misc

    19問 • 1年前
    Suhrid Saha

    diseases from chemicals

    diseases from chemicals

    Suhrid Saha · 8問 · 1年前

    diseases from chemicals

    diseases from chemicals

    8問 • 1年前
    Suhrid Saha

    Industrial name & chemical name

    Industrial name & chemical name

    Suhrid Saha · 41問 · 1年前

    Industrial name & chemical name

    Industrial name & chemical name

    41問 • 1年前
    Suhrid Saha

    names

    names

    Suhrid Saha · 62問 · 1年前

    names

    names

    62問 • 1年前
    Suhrid Saha

    common food adulterants

    common food adulterants

    Suhrid Saha · 9問 · 1年前

    common food adulterants

    common food adulterants

    9問 • 1年前
    Suhrid Saha

    facts and misc

    facts and misc

    Suhrid Saha · 99問 · 1年前

    facts and misc

    facts and misc

    99問 • 1年前
    Suhrid Saha

    Facts and MIsc 2

    Facts and MIsc 2

    Suhrid Saha · 13問 · 1年前

    Facts and MIsc 2

    Facts and MIsc 2

    13問 • 1年前
    Suhrid Saha

    names

    names

    Suhrid Saha · 67問 · 1年前

    names

    names

    67問 • 1年前
    Suhrid Saha

    factrs and misc

    factrs and misc

    Suhrid Saha · 100問 · 1年前

    factrs and misc

    factrs and misc

    100問 • 1年前
    Suhrid Saha

    themes

    themes

    Suhrid Saha · 5問 · 1年前

    themes

    themes

    5問 • 1年前
    Suhrid Saha

    names

    names

    Suhrid Saha · 40問 · 1年前

    names

    names

    40問 • 1年前
    Suhrid Saha

    imp facts and misc

    imp facts and misc

    Suhrid Saha · 27問 · 1年前

    imp facts and misc

    imp facts and misc

    27問 • 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