If you use Excel online, these keyboard shortcuts for the most common tasks will have you working faster and easier than ever.
If you’re a fan of keyboard shortcuts, using them to get things done in Excel for the web means you can work faster. From entering data and formatting cells to moving around a spreadsheet and selecting columns, rows, and objects, we’ve compiled a list of 61 of the best Excel online keyboard shortcuts for you to use.
Keyboard Shortcuts for Entering Data
With these keyboard shortcuts, you can complete your data entry and move to the next location in your sheet.
ActionShortcutAdd data and move to the cell belowEnterAdd data and move to the cell aboveShift + EnterEnter data and move to the next cell in the rowTabEnter data and move to the previous cell in the rowShift + TabCancel entering dataEsc
Keyboard Shortcuts for Editing Data
When you need to edit the data you’ve entered, you can select, insert, and copy data easily using these shortcuts.
ActionShortcutCutCtrl + XCopyCtrl + CPasteCtrl + VUndoCtrl + ZRedoCtrl + YEdit the cellF2Clear the cellDeleteClear and then edit the cellBackspaceSelect to the right by characterShift + Right arrow keySelect to the left by characterShift + Left arrow keySelect to the beginning of the cellShift + HomeSelect to the end of the cellShift + EndInsert the current dateCtrl + Semicolon (;)Insert the current timeCtrl + Shift + Semicolon (;)Insert a linkCtrl + KInsert a tableCtrl + LInsert a functionShift + F3Insert a chartAlt + F1Copy the formula from aboveCtrl + Apostrophe (‘)Copy the value from aboveCtrl + Shift + Apostrophe (‘)
Keyboard Shortcuts for Formatting Cells
Using the following shortcuts, you can format the data inside your cells from bold or italic to a currency or percentage.
ActionShortcutBoldCtrl + BItalicCtrl + IUnderlineCtrl + UPaste formattingShift + Ctrl + VApply number formattingCtrl + Shift + 1Apply time formattingCtrl + Shift + 2Apply date formattingCtrl + Shift + 3Apply currency formattingCtrl + Shift + 4Apply percent formattingCtrl + Shift + 5
Keyboard Shortcuts for Cells, Columns, and Rows
With these shortcuts, you can select, insert, delete, hide, and unhide cells, columns, and rows.
ActionShortcutSelect a cell rangeShift + Arrow keysSelect a columnCtrl + SpaceSelect a rowShift + SpaceInsert a cell, column, or rowCtrl + Plus sign (+)Delete a cell, column, or rowCtrl + Minus sign (-)Hide a columnCtrl + 0Unhide a columnCtrl + Shift + 0Hide a rowCtrl + 9Unhide a rowCtrl + Shift + 9
Keyboard Shortcuts for Navigating a Sheet
Move around within a sheet or go to the next or previous one with a few simple key presses using the following commands.
ActionShortcutGo to a certain cellCtrl + GMove up one cellShift + Enter or Up arrowMove down one cellEnter or Down arrowMove right one cellTab or Right arrowMove to the beginning of the rowHomeMove up one screenPage UpMove down one screenPage DownMove between the ribbon and the sheetCtrl + F6Move to a different ribbon tabTab and Enter to go to the ribbon for that tabInsert a new sheetShift + F11Move to the next sheetAlt + Ctrl + Page DownMove to the previous sheetAlt + Ctrl + Page Up
Miscellaneous Keyboard Shortcuts in Excel Online
These additional shortcuts for Excel online can help you open or close a workbook, as well as search through and find what you need.
ActionShortcutOpen a workbookCtrl + OClose a workbookCtrl + WSave AsAlt + F2FindCtrl + FPrintCtrl + P
Shortcuts for Common Tasks in Excel Online
This list of keyboard shortcuts for Excel online should help you perform the most common tasks. To see even more shortcuts while you work, go to Help > Keyboard Shortcuts in your workbook.
For more, take a look at these keyboard shortcuts that work across all browsers, or give these new Windows 11 shortcuts a try.
Ribbon dalam excel adalah bagian antarmuka excel yang berfungsi membantu pengguna untuk melakukan navigasi dan menemukan perintah saat menggunakan excel. … Selengkapnya
Worksheet : Arti dan Cara Penggunaannya
Pengertian Worksheet adalah lembar kerja dari workbook, yang terdiri dari kolom dan baris yang digunakan untuk menghitung dan mengolah data … Selengkapnya
Menggunakan dan Menyimpan Workbook Excel
Workbook : merupakan istilah lain dari excel yang merupakan buku kerja. Saat pertama kali membuka excel, maka secara default workbook … Selengkapnya