#Basics of #VBA #Programming

The basics of Formatting in Excel

The Windows GUI, when it was introduced way back in the 1990’s changed a lot of things, especially how the human mind works. However, the first concept of WYSIWYG (What You See Is What You Get) was initially introduced to me while using one of the later versions of Lotus 1-2-3, wherein the usual non-graphical interface of Lotus 1-2-3 was not very appealing when it came to the rendition of Charts and Graphs. However, we are not going to discuss the real appearance of WYSIWYG, which you can find under Wikipedia here.The real reason for this article is therefore, why I chose to name this page as WYSIWYG and not something that is more apparently linked to Microsoft Excel. From the time that Microsoft Excel – I have been creating formats that have been used by the clients that I have had in the past and even today in the present. And basically, what this page tries to emphasise is that any physical format, be it a voucher or an invoice or any other printed document, can be created in Microsoft Excel. With the advent of Laserjet Printers, and now that they are also affordable at home, printing a copy that would not really look that much different than if it were printed by a proper publisher/printing agency, certainly became very much possible.Just as an example, here I will show you a format created by me way back in 2006-2007, the Saral 2D Income-Tax Return, below:

Saral 2D Form, Page 1

Saral 2D Form Page 2

Another example that I have created from scratch for a friend and then it became quite popular with some of my other clients too is the “Cash Payment Voucher” or CPV, for short, shown below. In this format, you had the freedom to make whatever sort of entry you would usually make on a printed CPV and the entry was saved onto another worksheet, which was aptly called the Cash Payment Register. Not only that, you could even retrieve past vouchers onto the voucher format shown below and print it again, if you liked another copy for any reason at all.

Cash Payment Voucher

I think the above two examples illustrate quite beautifully why I have named this page as WYSIWYG.

CA VIKRAM SHANKAR MATHUR 28-Feb-2017 | 16:28 Hours IST


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s