Google Sheet Shortcuts PDF PDF

Preview

Summary

google sheet shortcut pdf...

Description

ere most used Google Sheets hortcuts that’s useful when you’re orking in a Google Spreadsheet. In a mple term, I can state Google Sheet s an online version of Microsoft xcel. Google Sheets is one of the rograms of the G-suite device. oogle sheets will allow users to create and edit files online, Download Google Sheets Shortcuts PDF.

The changes made in the Google Sheet are saved automatically. Below are the various Google Sheets shortcuts which will help you to work with Google sheet effectively.

Take your Office Productivity to Next Level

1

GENERAL SHORTCUTS Open options

Ctrl

O

Save

Ctrl

S

Undo last action

Ctrl

Z

Redo last action

Ctrl

Y

Copy selected cells

Ctrl

C

Repeat last action

F4

Cut selected cells

Ctrl

X

Paste content from clipboard

Ctrl

V

Paste special dialog box

Ctrl

Shift

Find & Replace

Ctrl

H

Find option

Ctrl

F

Print

Ctrl

P

Take your Office Productivity to Next Level

V

2

GENERAL SHORTCUTS Show common keyboard shortcuts

Ctrl

Insert new sheet

Shift

F11

Apply border outline

Alt

Shift

7

Add border top

Alt

Shift

1

Add border right

Alt

Shift

2

Add border bottom

Alt

Shift

3

Add border left

Alt

Shift

4

Remove borders

Alt

Shift

6

/

BORDERS SHORTCUTS

Read more [115+] Google Sheets Shortcuts For Windows And MAC

Take your Office Productivity to Next Level

3

FORMATTING SHORTCUTS Apply bold formatting

Ctrl

B

Apply italic formatting

Ctrl

I

Apply underline formatting

Ctrl

U

Apply strikethrough formatting

Alt

Shift

5

Align center

Ctrl

Shift

E

Align left

Ctrl

Shift

I

Align right

Ctrl

Shift

R

Clear formatting

Ctrl

\

Read more Top 10 Microsoft Excel Alternatives – FREE Excel Alternatives

Take your Office Productivity to Next Level

4

Apply number format

Ctrl

Shift

1

Apply time format

Ctrl

Shift

2

Apply Date format

Ctrl

Shift

3

Apply currency format

Ctrl

Shift

4

Apply percentage format

Ctrl

Shift

5

Apply exponent format

Ctrl

Shift

6

Read more

100 Excel Interview Questions and Answer for Job Cracker Take your Office Productivity to Next Level

5

SELECTION SHORTCUTS Select entire row

Shift

Select entire column

Ctrl

Select entire google sheet

Ctrl

Select entire google sheet

Ctrl

Add adjacent cells to selection

Shift

Add non-adjacent cells to selection

Ctrl

Click

Scroll to the active cell

Ctrl

Backspace

Take your Office Productivity to Next Level

Spacebar Spacebar A Shift

Spacebar

Click

7

EXTEND SELECTION [ES] SHORTCUTS ES by one cell right

Shift



ES by one cell right

Shift



ES by one cell up

Shift



ES by one cell down

Shift



Extend the selection to the last cell right

Ctrl

Shift



Extend the selection to the last cell left

Ctrl

Shift



Extend the selection to the last cell up

Ctrl

Shift



Extend the selection to the last cell down

Ctrl

Shift



ES up one screen

Shift

Page Up

ES down one screen

Shift

Page Dn

ES right one screen

Alt

Shift

Page Dn

ES left one screen

Alt

Shift

Page Up

Take your Office Productivity to Next Level

8

Move one cell right



Move one cell left



Move one cell up



Move one cell down



Move one screen right

Alt

Page Dn

Move one screen left

Alt

Page Up

Move one screen up

Page Up

Move one screen down

Page Dn

Move to right edge of data region

Ctrl



Move to left edge of data region

Ctrl



Move to top edge of data region

Ctrl



Move to bottom edge of data region

Ctrl



Take your Office Productivity to Next Level

9

NAVIGATION SHORTCUTS Move to beginning of row

Home

Move to end of sheet

Ctrl

End

Move to beginning of the sheet

Ctrl

Home

Move to end of row

End

Take your Office Productivity to Next Level

10

With all the above Google Sheet Shortcuts you can present your data with colorful charts and graphs. There are Google Sheets Shortcuts for Pivot Tables, conditional formatting and many more which will save time and simplify the task. There are a variety of templates available like a budget template, expense template, schedules and many more. Hope you have liked our blog on Google Sheets Shortcuts PDF. Suggestions are always welcomed for the blog you looking forward to hearing from us.

You may also like,

Most used SketchUp Shortcuts for Windows | Download PDF Top 30 Firebug Shortcuts for Windows & Mac

Take your Office Productivity to Next Level

11...