Some Basic Tutorial of MS Excel

Quick Sorting Tutorial:
One Column
To sort on one column, execute the following steps.

1. Click any cell in the column you want to sort.
2. To sort in ascending order, on the Data tab, in the Sort & Filter group, click AZ.


To sort on multiple columns, execute the following steps.

1. On the Data tab, in the Sort & Filter group, click Sort.
The Sort dialog box appears.

2. Select Last Name from the 'Sort by' drop-down list.
3. Click on Add Level.
4. Select Sales from the 'Then by' drop-down list.
5. Click OK.

Result. Records are sorted by Last Name first and Sales second.


Quickly Delete blank rows in Excel
After selecting the data range, continue as follows:

  1. Press [F5].
  2. In the resulting Go To dialog box, click Special.
  3. Click the Blanks option and click OK. Doing so selects the blank cells
  4. Now you're ready to delete the selected cells. On the Home tab, click the Delete dropdown in the Cells group and choose Delete Cells. Excel will display the Delete dialog box, with the Delete Cells Up option selected. Click OK. Or, press [Ctrl]+-. Excel will delete the blank cells from the selected data range

Add some word to all or some rows in MS Excel?


If I want to add some words before or after each word of a column, how can I do that?
Ex:
Lora
Muhit
Jana
Devid
John
Kanon
Rivery

I mean: for example, I put the words "who is" before each number in the first column and get

Who is Lora
Who is Muhit
Who is Jana
Who is Devid
Who is John
Who is Kanon
Who is Rivery

Solution:
The easiest way is:

  • Select All cells that want to change.
  • right click and select Format  cell.
  • In category select Custom.
  • In Type select General and insert this format ----> "Who is "@
Add some word to all or some rows in Excel?

Add some word to all

How to solve wordpress multisite subdomain error for hostgator

After a lot of trying, finally, I managed to set up a WordPress multisite to work on a HostGator server setup.

First, 
You need to add setup a wildcard subdomain from hostgator subdomain setup.
Go to subdomains and add one with just an asterisk(*).

To check if the wildcard setup is really working:  

If your domain is mydomain.com, then visit any random subdomain which is not assigned yet. For example: notAssigned.mydomain.com
If this subdomain redirects to your main domain, then your wildcard setup is ok. Otherwise, you have to manually edit the A record for the asterisk(*).
To do that go: Simple DNS Zone Editor
Add an A record to: *
You will find the address below of that page. The IP address or record (ex: 108.167.172.175) which is assigned to your main domain.
After adding this record, I think you will not find any error now. But in case do the wildcard checking again.

Two,
Add this into wp-config.php to enable multisite.
define('WP_ALLOW_MULTISITE', true);

Three,
Login to your WordPress dashboard and go to Tools>>Network (.com/wp-admin/network.php) You will then see the following type of instructions. Just follow the instruction.

Four,
I don't know. Your site should be ok now.