Excel - Autofill entire formula column easily

-
Let us take the following example.

Now you need to add NUMBER1 and NUMBER2 and display the total.
you guys already know its very simple only.
just place the cursor on C2 and type =A2+B2 (OR) you can use autosum option

but for applying the formula to the entire column there is a simple method.



first find total of C2 using above formula or Autosum
then place the cursor on the black dot on the C2 cell and double click on the black dot

thats it!!!..

Location: Chennai, Tamil Nadu, India

Comments

Post a Comment

Popular posts from this blog

Find & Replace + Transpose in Notepad++

-
Image
one of the useful features which I learned in Notepad++ is to transpose a comma separated values to columns using Find and Replace option. This feature is going to save lot time when you have very long list. with the above example, go to replace option (CTRL+H) now enter the values as per below screenshot, Make sure to select the Extended option. when you click replace all you will get same data in a column format.
Read more

Simple Login Page Using HTML5

-
Image
hi.. i find HTML5 is the easiest way to develop a site. so me tell you how to create a login page using HTML5 with all validations.. 1. use dreamweaver to create the login form. 2. insert a form, create a table, type those text and add 3 text fields or just copy& paste the following code .. //index.html <html> <head> <title>Untitled Document</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body bgcolor="#FFFFFF" text="#000000"> <table width="100%" border="0"> <tr> <td valign="middle" height="700"> <form name="form1" method="post" action="login.php"> <table width="300" border="0" align="center"> <tr bgcolor="#CCCCCC"> <td colspan="2"> ...
Read more

Run C++ (Full Screen mode) in Windows7

-
Image
The installation procedure of TC++ compiler is very simple. However if you install TC++ compiler in windows Vista/7, window size becomes very small. or you may get following error when you tried to open TC++ To overcome this you can download x86 emulator called DOSBOX from the following link http://sourceforge.net/projects/dosbox/files/dosbox/ once you have downloaded this emulator carry out the following steps: install the dosbox create a folder called 'Turbo' on your c drive copy entire Turbo C++ software inside this 'c:\Turbo' folder start dosbox you would be presented with two screens. you need to use the one which has z> prompt in it.  Type the following command at z>prompt mount x c:\Turbo mount d c:\Turbo\TC d: cd bin tc By typing the last command "tc" you are executing the turbo c++ software. This would bring up the normal blue colored TC++ window. to increase the window size just press Alt+Enter. now the TC++ window wi...
Read more