Convert to Debit/(Credit) Amount by using Paste Special

Excel is one of the important tool for finance professionals. If I want to present anything or want to draft anything, my mouse directly hit Excel.

Today topic may be very much useful for the accounting guys, who post Journal Entries in the systems.

Most of the ERPs (Enterprise Resource Planning) allow the Journal Entry in the following way.

Particulars	Dr/(Cr) Amount
Cash a/c	$2,500.00
Income a/c	$(2,500.00)

Do you know the other side of 'Copy' in Excel? (Copy as Picture)

Since we habituate to use Ctrl+C for Copy, we usually thought there is only one option for Copy.

In fact, Copy has two options. One is Copy as data (Ctrl+C) and other is Copy as Picture.

Try using Copy as picture option instead snipping tool to cut any Excel data and impress your boss in the meeting.

Without any late, I am starting to explain you the other side of Copy.