2 Quick Ways to Auto Fit Tables to Contents or Page in Your Word Document

This article is cropped to provide you with 2 quick and manageable ways to auto fit tables to contents or Page in your Word document. Inserting a table to hold data is now inevitable in Word using. More often than not, we don’t stop in merely having a table but try to make it look great in document. This means we will need to properly adjust table size accordingly. Now, let’s first take a look at occasions when we must change a table size: It’s pretty often to insert a new page in...

Read more »

2 Methods to Alternate Row or Column Colors in Your Word Table

In this article, we will introduce 2 methods for you to alternate row or column colors in your Word table. When it comes to a long table, we always find it pretty tiresome to stare at those numbers and try so hard not to make a mistake. But now, we have 2 awesome ways to deal with such an issue that is to apply different colors for odd and even rows or columns. Following are details: Method 1: Create a New Table Style Firstly, select the entire target table. Then, click “Design” tab...

Read more »

How to Using Excel to Read and Write an External Database

Excel can do virtually anything; whether it should be made to do everything is another matter. While the spreadsheet is very powerful in manipulating data, it isn’t too great at storing normalised data. Harnessing Excel to a relational database like SQL Server enhances the application’s power. To start with, you will need MS Access or the more stable and free - SQL Server Express. It is assumed that the reader has the Excel Developer ribbon displayed, and is familiar with the VBA Editor and...

Read more »