Cara menggunakan excel online shortcuts

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

Shortcut Excel apa aja?

Yuk, kita cari tahu..

CTRL + A: Memilih teks..

CTRL + B: Menebalkan teks..

CTRL + C: Copy (Menyalin teks).

CTRL + D: Membuka jendela Font Formatting..

CTRL + E: Format tulisan Center. ... .

CTRL + F: Menemukan kata di dalam file Word..

CTRL + G: Pindah ke halaman tertentu..

CTRL + H: Mengganti kata/kalimat dengan kata/kalimat lain..

Ctrl F di Excel untuk apa?

Untuk menemukan sesuatu, tekan Ctrl+F, atau masuk ke Pengeditan > Beranda> Temukan & Pilih > Temukan.

Ctrl Shift S di Excel untuk apa?

Shortcut Keyboard yang Sering Digunakan di Excel Ctrl + S, Berfungsi untuk menyimpan secara langsung.

Bagaimana cara membuat Excel online?

Memulai buku kerja baru di Excel untuk web.

Masuk ke OneDrive..

Klik folder tempat Anda ingin menambahkan buku kerja baru..

Klik buat, lalu klik buku kerja Excel. Excel untuk web terbuka dalam mode edit. Tips Tidak perlu menyimpan perubahan Anda..