Excel Shortcut: Tukar Baris

Excel ShortcutSource: bing.com

Are you tired of manually rearranging rows of data in Microsoft Excel? Fortunately, there is a shortcut known as “tukar baris” (which translates to “swap rows” in English) that can save you time and effort. In this article, we will explain how to use this shortcut and why it is useful.

What is Tukar Baris?

Tukar BarisSource: bing.com

Tukar Baris is an Excel shortcut that allows you to swap or interchange the position of two rows of data with just a few clicks. This feature is particularly useful when you need to reorder data and don’t want to waste time manually moving rows up and down.

How to Use Tukar Baris

How To Use Tukar BarisSource: bing.com

Using Tukar Baris is easy. First, select the rows you want to swap by clicking on the row numbers on the left-hand side of the Excel worksheet. Next, press the “Shift” key and the “Alt” key at the same time. While holding these keys down, press the “Up” or “Down” arrow key to swap the selected rows up or down, respectively.

Alternatively, you can right-click on the selected rows and choose “Cut” from the drop-down menu. Then, right-click on the row where you want to move the selected rows and choose “Insert Cut Cells” from the drop-down menu. This method achieves the same result as using the Tukar Baris shortcut.

Why Use Tukar Baris?

Why Use Tukar BarisSource: bing.com

Tukar Baris is a valuable shortcut for anyone who frequently works with large datasets in Excel. Not only does it save time and effort, but it also helps to reduce the risk of errors that can occur when manually moving rows. Additionally, Tukar Baris can be helpful when you need to sort data in a specific order or group similar data together.


In summary, Tukar Baris is a useful Excel shortcut that simplifies the process of rearranging data rows. Whether you’re working with a large dataset or just need to sort data quickly and efficiently, Tukar Baris can save you time and help prevent errors. Give it a try and see how it can improve your Excel workflow!

Related video of Excel Shortcut: Tukar Baris

M Arthur
M Arthur

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

Articles: 1031