Fill handle and Cell Drag and Drop is one of the most commonly used feature or say functionality in excel when dealing with sequences and numbers.

This by far has been the most frequently used functionality in excel throughout my career. Be it writing a formula and applying the same throughout different other cells or writing a common insert/delete script query for SQL and applying the same on other cells in the spreadsheet.

You can enable this feature [Excel 2010] if in case it is not enabled by following steps:

STEP 1: Go to File tab in excel as shown in the screen shot below and click on “Options” below “Help” section

Options

Options

STEP 2: after you click on options in the window that pops up click on “Advanced” section. In this section you can find that there is a check box to “Enable Fill handle and Cell Drag and Drop” as shown below

Advanced Tab

Advanced Tab

STEP 3: Once you enable this write a sequence of number say 1 and 2 in the first two cells. Select the two cells and drag it down till 5th row to see the numbers being filled in a sequence.

Drag Drop

Drag Drop

Well the feature is used very commonly but finding where to enable or disable needs lil bit of “Googling” and this blog serves the purpose :)

Aside  —  Posted: January 16, 2014 in Excel

Today when I was attaching a database, I encountered a common error that pops up if there is no proper access rights set for the “mdf” file that you are trying to attach.

I remember few years back when I had encountered same error, I had wasted quite a lot of time than needed on getting this up and running…J

So here goes the step to generate the error and fix it.

I downloaded the adventure work database from http://msftdbprodsamples.codeplex.com/releases/view/93587

STEP 1: Right click on the databases in SSMS and click “Attach…”

STEP 2: Click on ADD and go to the path where you have your downloaded adventure work database and click ok.

In case you already have the permissions set properly the database will get created.

If the permissions are not set then you will get a pop up as shown in the screen shot below:

Error 1

Error 1

If you click on the hyper link present in the Message section then you will have this popup saying the detail of the error as shown below:

Error 2

Error 2

So by looking at the details in the popup it becomes evident that the error is due to some access rights on the file that you are trying to attach.

Go to the folder where your mdf file is present right click –> Properties and go to Security tab, click on authenticated user and Select the checkbox for “Fill Control” as shown in the screen shot below.

Error 3

Again follow the Step 1 and 2, this time the database gets created without any error.

Hope this helps someone in need.

Aside  —  Posted: October 29, 2013 in SQL Server

Working with Macros in excel is always fun and for a C# developer, I bet it is always a challenge to work on VB code. One of the most handy thing to get going with excel form designing is the developer tab in the menu.

By default the developer tab will not be enabled, we should specifically enable it. This blog post shows you how to do it with screen shots.

STEP 1:

Click on the File as shown in the screen shot below.

STEP 1

STEP 1

STEP 2:

Click on Options as shown in the screen shot below.

STEP 2

STEP 2

STEP 3:

Once you click on the Options a window will be opened in which we have to select customize Ribbon.

Select the check box for developer as highlighted in the screen shot below.

STEP 3

STEP 3

STEP 4:

There you go with the developer tab in the excel where you can start designing your macros.

STEP 4

STEP 4

Well a simple tip for those who are starting on Macro’s in excel.

Hope you liked the post.

Aside  —  Posted: August 6, 2013 in Excel