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!

Saucy Chicken Recipe!

Time: 15 to 20 minutes
Servings: 4

Things needed:

Boneless Chicken
Sauce
Flour

Step 1: Toss the chicken pieces with flour until its slightly dusted.
Step 2: Pour around 2 tablespoons of oil into a pan. Heat in high flame.
Step 3: Once oil becomes hot(you will see smoke), add all the chicken pieces into the pan. Let one layer of the chicken fry nicely for 5 minutes or until it turns brown. Meanwhile you should sprinkle salt and pepper.
Step 4: Later toss the chicken to the other side and fry until it gets a brownish color.
Step 5: Turn off the stove, let the pan cool for a moment. Next, add oil and in medium flame add pepper and garlic. After 2 minutes, add ketchup.
Step 6: You will see small bubbles after sometime. Slowly color of the ketchup becomes dark. Now put back the chicken into this pan to coat the pieces with this sauce.

That's it! Done!

Enjoy your dish!

How to Prepare Lemon Rice

Time: 15 minutes
Servings: For 4

Things needed:

Mustard seeds(half teaspoon)
Groundnut seeds(handfull)
Turmeric powder(half teaspoon)
Onion (just 1)
Green Chillies(4)
Curry leaves(2 strands, I mean you should have around 10 to 12 leaves)
Coriander
Rice
Lemon(1)

Pre-requisites:
Its always best to have ingredients ready before we actually start cooking. Wash the onion, green chillies, curry leaves , coriander and lemon.
1)Slice onion into long thin strands.
2)Cut the green chillies. Make sure not to slice these into very small pieces because you may end up eating them. Chillies are meant to give a spicy taste to the dish not to your tongue.
3)Coriander also need to be sliced.1 strand is more than enough. 1 strand will have many small strands in it.
4)You need to keep rice ready.


Steps:
1)Pour a tsp of cooking oil to the vessel , turn on the stove. There is one thing that is very common in most of our Indian recipes, use of oil and mustard seeds.
2)After few seconds put half tsp of mustard seeds. You will observe that the seeds slowly get fried. 
3)Add curry leaves, onion pieces, green chillies and groundnut seeds and let them get a little brownish color.
4)Now add turmeric powder(half teaspoon) to give a yellowish color to the dish.
6)Turn off the flame. Add lemon juice. Please make sure that stove is not on when adding lemon juice.
7)Warm rice needs to mixed in this bowl and then coriander needs to be put over this dish.

That's it! Enjoy the lemon rice!

Tips:
Stay a little away from the cooking spot when adding anything wet while oil is in the pan.

Your Man Not Wearing His WEDDING RING. Does it matter??

 It was a cloudy day. Susan was standing near a bus stop when a friend of her, Lizy, just passes by. Lizy notices that Susan was not wearing the usual smile on her face so stops by.

Lizy- Hi Susan. Congratulations on getting engaged. Now waiting for the big day right? The ring reminds you that you are now engaged and you have a person excited to marry you. I am sure his ring also reminds him of the same.

Susan(smiles)- Thanks Lizy. Yes I am waiting for the big day but I am not sure if he is also eagerly waiting like me.

Lizy- Why? What makes u think like that?

Susan- He isn't wearing my ring on his ring finger. 

Lizy- So? 

Susan- That is the symbol that he is engaged to me right? He is not wearing it. Don't know why.

Lizy- Hahaha. You really think that the ring is the symbol for your engagement? 

Susan- Yes , when I can wear it then why the heck can't he also wear it?

Lizy- Chill. You are pondering over something that has no meaning. Don't waste your time.

Lizy sees that Susan wasn't convinced so she holds her hand and tells her something that makes Lizy's face to lit up.

Susan- See Lizy, not all men like to wear ring on their hands. For instance, men like to ride bikes at good speed and forget everything else for that moment just to enjoy the air that just blows gracefully on their faces. If the ring slips in between then he would have to worry about it because you would surely feel very bad like the way you are feeling right now. So he would feel its better to keep the ring safe in the box rather than to lose it. Guys who love to play basketball, would again think about the ring atleast for a minute because he would have to use his right hand very softly on the ball in order to make sure that there is no scratch on the ring(laughs). If you have faith on the guy you are engaged to then you need not worry about that shiny damn thing! The ring should not become a reason for you both to stay together. There might be some cases where the guy might purposefully not wear the ring because that ring would alert every girl that he meets that he is engaged. That would mean that he is still looking out for someone more special than you. That should never be the case. If you get any clues that he isn't wearing the ring for such an intention then you might have to actually worry else not, definitely not. The ring should never be the only reason to make you realize that he loves you darling!

Lizy- Wow! Thanks Susan. I was totally clueless little while ago but now I am clear . I need not worry. He is a gem of a person and I trust him (smiles). Bye!