Tag Archives: Excel

How to Add a Watermark to a Worksheet in Microsoft Excel 2013

In this tutorial you will learn how to add a watermark to a worksheet in Microsoft Excel 2013.

Adding a watermark to your Excel worksheet makes it look cool and it may come handy if you want to enhance your company documents, say, the lists of workshop participants that you want to print out and even your company invoices!

Adding a watermark to a worksheet in Microsoft Excel 2013 does not happen just in a couple of clicks, but is still quite easy to do. Before you proceed, make sure you have your image file prepared. A nice JPG or PNG image with your logo or any other watermark-suitable picture is okay.

read more »

How to Create and Clear Array VBA (Excel)

In this tutorial we will guide you on how to create and clear arrays in VBA Excel.

Arrays are basically a group of variables which have similar properties. Instead of using multiple variables, it’s better to use a single array. By using arrays, we can use a single variable for several values. It can store from 1 to more than thousands of values depending on the size of program. Arrays use a loop function to work which helps to store, retrieve and modify values in it. It is also a good practice to clear arrays in VBA programs at the end to free up the memory used to store it. This is very helpful when working on large data or spreadsheets as it slows down the overall performance of the program. Here we are using arrays in VBA Excel to input more than one values in a single variable with the help of macros.

read more »

How to Write Excel Macros via VBA

You can easily get started with writing the visual basic code by enabling the feature in Microsoft Excel. By writing VBA excel macro, you can automate a number of tasks which otherwise might take a lot of your time. For example, changing the formatting of a whole document in a specific way, etc.

Follow this step by step tutorial where we will guide you on how to write Microsoft excel macros using Visual Basic.

read more »

How to Use Symbols and Special Characters in Excel

In this tutorial, you will learn how to use symbols and special characters in Excel.

read more »

How to Open Excel File in C#

Microsoft Excel can be managed and operated through C# code with the help of several built in libraries, which include functions to operate Excel. In this tutorial, we will show you how to open an excel file in C# application.

read more »