Excel shortcuts!

I will let you guys know some tips to save time while using excel spreadsheet.

1)Use ALT and = to give sum of the rows.
You need to keep the cursor in the highlighted cell as shown below.

Press ALT and =. The system shows up the formula '=Sum(B2:B3)'. That is the formula for calculating the sum so press 'Enter' to get the answer.

2)Use CTRL and Spacebar to get any particular column selected.

You need to keep the cursor in the highlighted cell as shown below.

Press CTRL and Spacebar to get the entire column selected.

3)Use Shift and Spacebar to get any particular row selected.

You need to keep the cursor in the highlighted cell as shown below.

Now press CTRL and Spacebar to get the entire row selected.

4)Use CTRL and ;(semicolon) to insert Date in the cell.

You need to keep the cursor in the highlighted cell as shown below.

Press CTRL and ; and then you will see the date inserted in the cell.

5)Use CTRL, Shift and ; to insert time in the cell.

You need to keep the cursor in the highlighted cell as shown below.

Press CTRL, Shift and ;.

6)Use CTRL and 0 to hide the data.

You need to keep the cursor in the highlighted cell to be hidden as shown below.

Press CTRL and 0 to hide the column.

The 'Time' column has been hidden. To unhide the same, double click on highlighted space below.

7)Use ALT 'E' and 'D' to delete the data.

You need to keep the cursor in the highlighted cell to be deleted as shown below.

Press ALT 'E' and 'D'. A dialog box appears requiring your input.

8)To navigate quickly over a big spreadsheet, use CTRL and 'Home' to navigate to the start of the spreadsheet or CTRL and 'END' to the end of the sheet.

How to Move Posts Into Pages On Blogspot

Issue: Moving posts into pages on blogspot

Solution:Blogger doesn't have the option of changing a post to a page. Nevertheless you could do it on your own!
Step 1)Go to Blogger.com. Sign into your account.
Step 2)Click on 'Edit Posts'.
Step 3)Go to the post that you would want to be seen in any page.
Step 4)Click 'Edit Html'.
Step 5)Press 'Ctrl+A' to select the content and then 'Ctrl+C' to copy the same to a notepad.
Step 6)Click on 'Close'. A pop-up would warn you of leaving without any changes being saved. Click 'Ok' .
Step 7)Now click on 'New Page'.
Step 8)Click 'HTML' and paste the content copied to notepad.
Step 9)Enter a title for the page.
Step 10)Click 'Publish'.
Step 11)Now Click 'delete' to delete the original post or to have a copy of the post , click 'Edit' and then 'Revert to Draft' to make sure that the post doesn't appear in the main page..

That's it!

Placing ads in the post

Issue:
How to place ads in the post?

Solution:
1)Click HTML section of the post.

2)Enter this code:
<div style="width:50%;margin: 0px auto">
<add your adsense code here--->
</div>

3)Now, add your ad code in the highlighted space.

4)Now click 'Preview' and check if the ad is appearing in the post.

6)Click 'Save Template'. 

This code must be added wherever you require the ad to appear in the post.

Blogger Problem: Undefined Date Issue

Issue:
Date not getting displayed in the webpage.

Solution:

1)Go to Blogger->Blogger Design.

 2)Click on Settings.

3)The following options appear.

4)Click on Timestamp format.

5)Select format: Tuesday, October 06, 2016.

5)Click 'Save'.

6)Go to Template.

7)The below code must be in the template for the time to be displayed in the website.

<script type='text/javascript'>

var timestamp = &quot;<data:post.timestamp/>&quot;;

if (timestamp != &#39;&#39;) {

  var timesplit = timestamp.split(&quot;,&quot;);

  var date_yyyy = timesplit[2];

  var timesplit = timesplit[1].split(&quot; &quot;);

  var date_dd = timesplit[2];

  var date_mmm = timesplit[1].substring(0, 3);

}

</script>

8)Click 'Save Template'.

9)Click 'View Blog' to view the page.

10)Date will get displayed!