EXCEL SHORTCUT KEYS Flashcards by Marinella Francisco

{ "@context": "https://schema.org", "@type": "Organization", "name": "Brainscape", "url": "https://www.brainscape.com/", "logo": "https://www.brainscape.com/pks/images/cms/public-views/shared/Brainscape-logo-c4e172b280b4616f7fda.svg", "sameAs": [ "https://www.facebook.com/Brainscape", "https://x.com/brainscape", "https://www.linkedin.com/company/brainscape", "https://www.instagram.com/brainscape/", "https://www.tiktok.com/@brainscapeu", "https://www.pinterest.com/brainscape/", "https://www.youtube.com/@BrainscapeNY" ], "contactPoint": { "@type": "ContactPoint", "telephone": "(929) 334-4005", "contactType": "customer service", "availableLanguage": ["English"] }, "founder": { "@type": "Person", "name": "Andrew Cohen" }, "description": "Brainscape’s spaced repetition system is proven to DOUBLE learning results! Find, make, and study flashcards online or in our mobile app. Serious learners only.", "address": { "@type": "PostalAddress", "streetAddress": "159 W 25th St, Ste 517", "addressLocality": "New York", "addressRegion": "NY", "postalCode": "10001", "addressCountry": "USA" } }

Q

F2

A

Edit the selected cell

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

F5

A

Go to a specific cell

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

F7

A

Spell check selected text and document

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Ctrl+Shift+ ; (SEMI-COLON)

A

Enter the current time

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

F11

A

Create chart

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Ctrl+: (colon)

A

Enter the current date

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Shift + F3

A

Open the excel formula window

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Alt+Shift+F1

A

Insert new worksheet

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Shift + F5

A

Bring up search box

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Ctrl + B

A

Bold highlighted selection

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Ctrl+A

A

Select all contents of worksheet

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Ctrl+I

A

Italicize highlighted selection

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Ctrl+C

A

Copy selected text

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Ctrl+D

A

Fill

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Ctrl+F

A

Open find and replace options

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Ctrl+G

Study These Flashcards

A

Open go-to options

Q

Ctrl+Y

Study These Flashcards

A

Underline selected text

Q

Ctrl+U

Study These Flashcards

A

Underline highlighted selection

Q

Ctrl+H

Study These Flashcards

A

Open find and replace options

Q

Ctrl+5

Study These Flashcards

A

Strikethrough highlighted selection

Q

Ctrl+O

Study These Flashcards

A

Open option

Q

Ctrl+N

Study These Flashcards

A

Open new document

Q

Ctrl + P

Study These Flashcards

A

Open print dialog box

Q

Ctrl+F9

Study These Flashcards

A

Minimize current window

Ctrl+F10

Maximize currently selected window

Ctrl+F6

Switch between open windows

Ctrl + Page Up & Page Down

Move between excel worksheet in the same document

Alt + =

Create formula to sum all of above cells

Ctrl+Tab

Move between two or more open excel files

Ctrl + '

Insert value of above cell into current cell

Ctrl+Shift+!

Format number in comma format

Ctrl+Shift+$

Format number in currency format

Ctrl+Shift+%

Format number in percentage format

Ctrl+Shift+#

Format number in date format

Ctrl+Shift+@

Format number in time format

Ctrl+Shift+^

Format number in scientific format

Ctrl + →

Move to next section of text

Ctrl+ Space

Select entire column

Shift+ Space

Select entire row Ctrl + W