Google sheets shortcut keys

0 0 Saturday, May 14, 2022 Edit this post

दोस्तों निचे आपको 100 से भी अधिक Shortcut keys मिलने वाले है जिससे आपकी जानकारी और काम का रफ़्तार और भी बढ़ जायेंगा, Google sheets के काफी उपय...


दोस्तों निचे आपको 100 से भी अधिक Shortcut keys मिलने वाले है जिससे आपकी जानकारी और काम का रफ़्तार और भी बढ़ जायेंगा, Google sheets के काफी उपयोगी Shortcut keys है  

Common actions

Short keys

Select column

Ctrl + Space

Select row

Shift + Space

Select all

Ctrl + a

Ctrl + Shift + Space

Undo

Ctrl + z

Redo

Ctrl + y

Ctrl + Shift + z

F4

Find

Ctrl + f

Find and replace

Ctrl + h

Fill range

Ctrl + Enter

Fill down

Ctrl + d

Fill right

Ctrl + r

Save (every change is saved automatically in Drive)

Ctrl + s

Open

Ctrl + o

Print

Ctrl + p

Copy

Ctrl + c

Cut

Ctrl + x

Paste

Ctrl + v

Paste values only

Ctrl + Shift + v

Show common keyboard shortcuts

Ctrl + /

Insert new sheet

Shift + F11

Compact controls

Ctrl + Shift + f

Input tools on/off (available in spreadsheets in non-Latin languages)

Ctrl + Shift + k

Select input tools

Ctrl + Alt + Shift + k

Search the menus

Alt + /

Format cells


Bold

Ctrl + b

Underline

Ctrl + u

Italic

Ctrl + i

Strikethrough

Alt + Shift + 5

Center align

Ctrl + Shift + e

Left align

Ctrl + Shift + l

Right align

Ctrl + Shift + r

Apply top border

Alt + Shift + 1

Apply right border

Alt + Shift + 2

Apply bottom border

Alt + Shift + 3

Apply left border

Alt + Shift + 4

Remove borders

Alt + Shift + 6

Apply outer border

Alt + Shift + 7

Ctrl + Shift + 7

Insert link

Ctrl + k

Insert time

Ctrl + Shift + ;

Insert date

Ctrl + ;

Insert date and time

Ctrl + Alt + Shift + ;

Format as decimal

Ctrl + Shift + 1

Format as time

Ctrl + Shift + 2

Format as date

Ctrl + Shift + 3

Format as currency

Ctrl + Shift + 4

Format as percentage

Ctrl + Shift + 5

Format as exponent

Ctrl + Shift + 6

Clear formatting

Ctrl + \

Navigate spreadsheet


Move to beginning of row

Home

Move to beginning of sheet

Ctrl + Home

Move to end of row

End

Move to end of sheet

Ctrl + End

Scroll to active cell

Ctrl + Backspace

Move to next sheet

Alt + Down Arrow

Move to previous sheet

Alt + Up Arrow

Display list of sheets

Alt + Shift + k

Open hyperlink

Alt + Enter

Open Explore

Alt + Shift + x

Go to side panel

Ctrl + Alt + .

Ctrl + Alt + ,

Move focus out of spreadsheet

Ctrl + Alt + Shift + m

Move to quicksum (when a range of cells is selected)

Alt + Shift + q

Move focus to popup (for links, bookmarks, and images)

holding Ctrl + Alt, press e then p

Open drop-down menu on filtered cell

Ctrl + Alt + r

Open revision history

Ctrl + Alt + Shift + h

Close drawing editor

Shift + Esc

Edit notes and comments


Insert/edit note

Shift + F2

Insert/edit comment

Ctrl + Alt + m

Open comment discussion thread

Ctrl + Alt + Shift + a

Enter current comment

holding Ctrl + Alt, press e then c

Move to next comment

holding Ctrl + Alt, press n then c

Move to previous comment

holding Ctrl + Alt, press p then c

Open a menu


File menu

in Google Chrome: Alt + f

other browsers: Alt + Shift + f

Edit menu

in Google Chrome: Alt + e

other browsers: Alt + Shift + e

View menu

in Google Chrome: Alt + v

other browsers: Alt + Shift + v

Insert menu

in Google Chrome: Alt + i

other browsers: Alt + Shift + i

Format menu

in Google Chrome: Alt + o

other browsers: Alt + Shift + o

Data menu

in Google Chrome: Alt + d

other browsers: Alt + Shift + d

Tools menu

in Google Chrome: Alt + t

other browsers: Alt + Shift + t

Open insert menu

Ctrl + Alt + Shift + =

Ctrl + Alt + =

(with cells selected)

Open delete menu

Ctrl + Alt + – (with cells selected)

Form menu

(present when the spreadsheet is connected to a form)

in Google Chrome: Alt + m

other browsers: Alt + Shift + m

Add-ons menu

in Google Chrome: Alt + n

other browsers: Alt + Shift + n

Help menu

in Google Chrome: Alt + h

other browsers: Alt + Shift + h

Accessibility menu

(present when screen reader support is enabled)

in Google Chrome: Alt + a

other browsers: Alt + Shift + a

Sheet menu

(copy, delete, and other sheet actions)

Alt + Shift + s

Context menu

Ctrl + Shift + \

Add or change rows and columns


Insert rows above

Ctrl + Alt + Shift + =

Ctrl + Alt + =

(with rows selected)

in Google Chrome: Alt + i, then r

other browsers: Alt + Shift + i, then r

Insert rows below

in Google Chrome: Alt + i, then w

other browsers: Alt + Shift + i, then w

Insert columns to the left

Ctrl + Alt + Shift + =

Ctrl + Alt + =

(with columns selected)

in Google Chrome: Alt + i, then c

other browsers: Alt + Shift + i, then c

Insert columns to the right

in Google Chrome: Alt + i, then o

other browsers: Alt + Shift + i, then o

Delete rows

Ctrl + Alt + – (with rows selected)

in Google Chrome: Alt + e, then d

other browsers: Alt + Shift + e, then d

Delete columns

Ctrl + Alt + – (with columns selected)

in Google Chrome: Alt + e, then e

other browsers: Alt + Shift + e, then e

Hide row

Ctrl + Alt + 9

Unhide row

Ctrl + Shift + 9

Hide column

Ctrl + Alt + 0

Unhide column

Ctrl + Shift + 0

Group rows or columns

Alt + Shift + Right Arrow

Ungroup rows or columns

Alt + Shift + Left Arrow

Expand grouped rows or columns

Alt + Shift + Down Arrow

Collapse grouped rows or columns

Alt + Shift + Up Arrow

Use formulas


Show all formulas

Ctrl + ~

Insert array formula

Ctrl + Shift + Enter

Collapse an expanded array formula

Ctrl + e

Show/hide formula help

(when entering a formula)

Shift + F1

Full/compact formula help

(when entering a formula)

F1

Absolute/relative references

(when entering a formula)

F4

Toggle formula result previews

(when entering a formula)

F9

Resize formula bar

(move up or down)

Ctrl + Up / Ctrl + Down


Tags

SHARE:

Twitter Facebook Google Pinterest

COMMENTS

GOOGLE
Name

about covid,1,about google form,1,about google sheets,6,about google sheets in hindi,1,about kinemaster,1,about sheet,1,about sheets,2,about tally company,2,accessibility in google sheets,1,accounting,6,accounting with GST,3,affiliate,1,amazon,1,amazon affiliate,1,appsheet,1,billing,1,boost pc speed,1,capitalize each word,1,change case,1,chart,3,chart in google sheets,1,checkbox,1,class of GST,2,column insert in sheets,1,comment,1,company feature,1,compare,1,compare excel between google sheets,1,conditional formatting,2,conditional formatting in google sheets,1,configuration,1,corona,1,corona virus,1,count function,1,countif function,1,countifs function,1,covid,2,covid 19,2,create a form,1,create chart online,1,create online form,1,data,1,data menu,1,data menu in google sheets,1,data storage,1,data storages,1,data store,1,data validation,1,details of google sheets,1,disk,1,download sheets,1,drawing,1,e way bill,1,e way bill generate,1,e way bill in tally,1,E-way bill,1,E-way bill from tally,1,E-way bill from tally prime,1,earn,2,earn money,1,earn online,1,earning,1,easy to video edit in kinemaster,1,easy video editing app,1,edit menu,1,edit menu in google sheets,1,edit pdf,1,edit pdf easy,1,edit pdf file,1,edit pdf online,1,Excel,2,excel foumula,1,excel function,1,f11,1,F12,1,feedback,1,file menu,1,file menu in google sheets,1,filter,1,form,3,format menu,1,format menu in google sheets,1,formula,1,formula bar,1,free online form,1,freeze in google sheets,1,full screen,1,function,3,gmail report,1,google form,3,google form kya hai,1,google forms in hindi,1,google shees vs ms excel,1,google sheet,5,google sheets,14,google sheets chart,1,google sheets function,1,google sheets kaise kam karta hai,1,google sheets kya hai,1,google sheets me chart kaise banayen,1,google sheets shortcut keys,1,google sheets vs Microsoft excel,1,gridlines,1,gs,1,GST,5,GST accounting,4,GST calculation,3,GST ledger,1,GST sale,1,GST Tax,2,GST taxes,2,GST validation,1,gstin,1,GSTIN AND HSN,2,hindi me jane google sheets ke bare me,1,how generate e-way bill,1,how to make account,1,how to make chart,1,how to make google form,2,how to make pivot chart,1,how to send report by gmail in tally prime,1,how to upgrade tally erp 9,1,how to use kinemaster,1,how to use ocr,1,hsn,1,hsn code,2,HSN validation,1,images,1,import excel in sheets,1,import function,1,import range,1,import range function,1,importrange,1,information of covind 19,1,insert link,1,insert row in google sheets,1,invoice printing,1,kinemaster,1,kinemaster app,1,ledger,1,link function,1,link shortener,1,lockdown,1,lower case,1,macros,1,make online form,1,Microsoft Excel,3,mobile video editing app,1,most useful key in sheets,1,ms excel,2,new features in windows 11,1,new sheets,1,new variant of covid,1,note,1,ocr,1,ocr kya hai,1,online earn,1,online earning,1,online form,1,online form free,1,online money,1,online ocr,1,online pdf edit,1,payroll management,1,pen drive,1,pivot,1,pivot chart,1,pivot table,2,prime 2.0,1,print HSN code in invoice,1,print invoice,1,print invoice with HSN,1,print invoice with SAC code,1,protect sheet,1,protect sheets,1,q n a,1,q&a,1,question about tally prime,1,rally prime,1,release 6.6.3,1,release notes,1,release notes of tally,1,sac code,1,sale with gst,2,save view report,1,save view report in tally prime,1,scan text,1,script editor,1,sd card,1,sejda,1,sejda.com,1,send report by gmail,1,send report by outlook,1,send report by yahoo mail,1,sent gmail,1,sentence case,1,share form,1,share google form,1,share google sheets,1,sheets,3,sheets function,1,sheets vs excel,1,shortcut,4,shortcut key,3,shortcut key for sheets,1,shortcut keys,2,shortcut keys in hindi,1,shortcut of google sheets,1,shortener,1,show formula,1,slicer,1,spelling,1,storage,1,storage device,1,system requirement for windows 11,1,Tally,9,tally company,1,tally e waybill,1,Tally erp,1,tally erp 9,4,tally erp 9 release,1,tally erp9,1,tally error,1,tally feature,1,tally kya hai,1,Tally prime,11,tally prime 2.0,2,tally prime Q&A,1,tally prime question,1,tally prime release notes,1,tally prime report send by gmail,1,Tally shortcut,1,tally solution,1,tally solution private ltd. about tally solution private ltd.,1,tallyprime,1,tax,2,tax accounting,1,tax calculation,2,tax collaboration,1,taxes,1,text rotation,1,text to column,1,text wrapping,1,top shortcut keys for google sheets,1,TSS,1,type of storage,1,upper case,1,use conditional formatting,1,used formula,1,vaccination,1,video edit in mobile,1,video editing,1,view menu,1,view menu in google sheets,1,view report,1,vlookup,1,vlookup formula,1,vlookup function,1,what is chart,1,what is google form,2,what is google sheets,1,what is ocr,1,what is tally,1,what's new in windows 11,1,windows,2,windows 10,1,windows 10 shortcut,2,windows 10 shortcut key,1,windows 11,1,zoom,1,
ltr
item
Rchandan: Google sheets shortcut keys
Google sheets shortcut keys
https://cdn.pixabay.com/photo/2015/02/03/02/14/keyboard-621830_1280.jpg
Rchandan
https://www.rchandan.com/2022/05/google-sheets-ke-shortkeys.html
https://www.rchandan.com/
https://www.rchandan.com/
https://www.rchandan.com/2022/05/google-sheets-ke-shortkeys.html
true
7568624659884761692
UTF-8
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share to a social network STEP 2: Click the link on your social network Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy Table of Content