Skip to main content

Posts

Showing posts from October, 2015

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…

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!

Great Amazon Deals!

Seagate Backup Plus Slim for 7,680 Rs4,250 Rs  !! You save a whopping 3,430 Rs!
Details:BrandSeagateModelSTDR1000300Model NameBackup Plus PortableItem Weight159 gProduct Dimensions11.4 x 7.6 x 1.2 cmItem model numberSTDR1000300Memory Storage Capacity1 TBHard Drive Size1 TBHardware PlatformPC, MacIncluded ComponentsSeagate Backup Plus drive, Seagate Dashboard pre-loaded on drive, NTFS driver for Mac pre-loaded on drive, 18-inch USB 3.0 cable, Quick start guideNetwork Interface DescriptionUSB

Click below link to buy!
Seagate Backup Plus Slim 1TB Portable External Hard Drive with 200GB of Cloud Storage & Mobile Device Backup (Black)



HP 15-r245TX 15.6-inch Laptop (Core i3-5th Gen/4GB/500GB/2GB Graphics/DOS), Black for 36,819 Rs 28,399 Rs.
You save 8,420 Rs!