Shortcut Antar Sheet Excel: Tips and Tricks to Save You Time

Excel IconSource:

Microsoft Excel is a powerful tool for data analysis and management. However, it can be overwhelming to navigate through large spreadsheets and perform complex calculations. One way to make your Excel experience more efficient is by using keyboard shortcuts. In this article, we’ll explore some of the most useful shortcut antar sheet Excel to help you work faster and smarter.

Navigation Shortcuts

Excel Navigation ShortcutsSource:

When working with large spreadsheets, it can be time-consuming to scroll up and down or left and right. Here are some navigation shortcuts that can save you time:

  • Ctrl + G: Go to a specific cell
  • Ctrl + arrow keys: Move to the last cell of data in a row or column
  • Ctrl + Home: Go to the beginning of the worksheet
  • Ctrl + End: Go to the last cell of the worksheet

Formatting Shortcuts

Excel Formatting ShortcutsSource:

Formatting your spreadsheet can be time-consuming, but these shortcuts can help you get it done quickly:

  • Ctrl + 1: Open the Format Cells dialog box
  • Ctrl + Shift + $: Apply currency format
  • Ctrl + B: Bold selected text
  • Ctrl + U: Underline selected text
  • Ctrl + I: Italicize selected text

Calculation Shortcuts

Excel Calculation ShortcutsSource:

Excel is a great tool for performing complex calculations. Here are some calculation shortcuts that can help you get the job done more quickly:

  • Ctrl + =: Insert the SUM function
  • Alt + =: Insert the AVERAGE function
  • Ctrl + Shift + !: Apply the number format to selected cells
  • Ctrl + Shift + %: Apply the percentage format to selected cells

Data Entry Shortcuts

Excel Data Entry ShortcutsSource:

Entering data into Excel can be tedious, but these shortcuts can help you do it quickly:

  • Ctrl + ;: Insert the current date
  • Ctrl + :: Insert the current time
  • Ctrl + Shift + :: Insert the current date and time
  • Ctrl + Shift + #: Apply the date format to selected cells


Using keyboard shortcuts is a great way to save time and increase your productivity in Excel. By mastering these shortcut antar sheet Excel, you can perform tasks more efficiently and focus on more important aspects of your work. So the next time you’re working in Excel, try out some of these shortcuts and see how much time you can save!

Related video of Shortcut Antar Sheet Excel: Tips and Tricks to Save You Time

M Arthur
M Arthur

Pembelajar dan penyuka dunia teknologi. Suka sekali berbagi pengetahuan lewat tulisan. Terimakasih sudah membaca salah satu tulisan saya.