Skip to main content

Posts

How to Deactivate and Reactivate (OFF or ON ) WiFi Signal of Router

Recent posts

How to auto fit Excel cell to text width while copy paste

How to auto fit Excel cell to text width
It is a very simple but most important job which we must know while doing any data base job in excel. The first most burning problem arises when we copy a data from a sheet that have different text length for several columns. It is very tedious process to correct the width individually. For exampla column A have 5 text length, Column B have 70 texts length and Column C have 15 text length and so on. If there are 50 columns like this, then you can not choose to correct these one by one individually. But when we copy the sheet , all the copied data remains with a constant cell width wiht hidden texts for larger text length. These cell data can be formated in one click. Here is the step. Step1: Select all the cell. Step2: Go to format tool bar of HOME tab and click the arrow to expand the drop down menu. Step3: Click on "Autofit Column width". Now all the cells get expanded widthwise as per its text length. Watch this video.

How to Control Adsense Ad Sizes with Media Query at Various Screen of Different Dievices

This technique of controlling responsive ad sizes is very important if you need to control certain type of ad size to appear on desktop or mobile or other devices. It is because the responsive adsense ad codes normally shows 728x90 banner on desktop and 328x250 ad size on mobile. But when you need to make appear other ad code format on desktop say 728x250 size, then media query do a great job. These setting are vey important to control the RESPONSIVE ad units. It is because responsive ad unit will not perform better only by placing the plane ads. You need to match it according to your webpage to earn maximum. That is why google reccommends for these setting if you can. Note: if you are unfamilia with media query. Then don't try , because it may disturb your ad code. Only try if you are well known to it. I reccomend you to create a template backup before trying it.
Example 1 : Suppose it is needed to show an ad on three screen with various width say on mobile , tablet and deskt…

How to Copy Paste Formated Texts from a Word Table to Excel without Formating problem

Performing copy paste from an MS Word file's table or from other formatted text, it is always an irritating task that we normally face when we paste the copied texts from these places I want to clarify it with an example. Suppose a table cell is copied from a table of ms word file; in which there are two lines of the texts in a cell of the table. It is pasted in a cell of an excel file, and then it has been noticed that the texts spreads over two cells in two individual rows. It can be seen in the image given below. Whatever we try, it becomes a tail of a dog that never attains a pattern we want. See this table in the figure. Copy the texts and paste it in a cell of excel file, you will notice that the texts spread over two or more rows. This problem has very simple solution; which we never try and think. Just before doing paste action press F2 function key to highlight the text entry cursor in the cell of the excel file. After that do paste the copied texts from the table …

How to Change Adsense Payment Method | How to fill Adsense Payment Detail | Wire Transfer to Receive Money to your Account

Google Adsense made it very easy to receive Adsense payment directly to your account. It is important to fill the account details carefully. A fear is always carried in our mind whenever we perform a financial transaction and there remains a risk of money loss. But to overcome this psychological fear, we need to do a research. First go to your bank and get the SWIFT details of the bank. IFCI code is already written on your bank passbook and also available on Chaque leaflet. Therefore the Straight rule for this is to do a good homework for filling SWIFT details for WIRE TRANSFER. Before this first see the form of Adsense. You can reach to this form in these steps: Go to setting > Payment > click on Payment Method > Click Add payment method.Your will see the form as in this image at left. A sample data has been filled up in the given form. You need to change the details as per your bank details. After filling your details of a primary account, a secondary account…

How to remove Express Accounting Free_14904_i1588738344_il584659.exe Virus from PC of Laptop

Express Accounting Free_14904_i1588738344_il584659.exe is a type of virus which creates a permission lock on your desktop and protect itself from getting deleted. Whenever any delete actin is tried. It changes its permission from previous administrator to a new administrator. It again prompts to ask permission from this new administrator. In this it puzzles the user. Any unwanted file must not be left in the computer, because at background it can harm the pc security. Watch the video for deleting steps. To delete this exe file from my computer I have got an idea to assign a new administrator. When I assigned a new administrator and I also checked the box of all control , then It got deleted easily. These images show the result of deleting action of this file which has express accounting virus.

How to Share Internet at two Mobiles with One Internet Account

It is very cost effective to share internet of one mobile with other mobile . it saves lot of money; when calculated for longer period of time. Many of us are not using one mobile at this age of high technology. also many of us are using one costly high range smart phone like Galaxy series (may be Samsung Galaxy S4, Samsung Galaxy Note 3, Samsung Galaxy Note 3, Samsung Galaxy Tabs, Sony Xperia , HTC mobile etc.) . Smart phones are not providing dual SIM facility. And these mobiles are highly secure. These devices don't allow to connect easily with other device. Therefore sharing internet of these smart mobiles with other mobiles needs to be securely connected with these devices that need MAC id of the other device; which you want to connect with the smart mobiles. To find MAC id of any device , these steps to be followed. Steps of finding MAC 1. Tap Settings

2. Tap Wireless and Networks / Connection
3 Tap w-Fi to enable it

4 Press the Back button
5. Tap general
6. Tap Abo…

Follow by Email