how to

Excel Tips: Cell selection with Excel Keyboard shortcuts

by Sujoy on September 12, 2010

Microsoft Excel TipsIn the past couple of months of working on Excel and VBA Macros, I have been exposed to a few challenges which in the course of time, I have overcome. So, I thought I would share them with my beloved readers. This section: Excel Tips aims at sharing the small tips and tricks that I have come across which makes life easier for anyone working with Excel or VBA Macros. Cheers!

Keyboard shortcuts are like the secret tools of every power Excel user. If we use too much of Excel in our day-to-day work, these handy Keyboard shortcuts on Excell cell selection will save a lot of time, and also save you from dragging the mouse into frustration land.

So here, we go.

Selecting entire Column (vertical ) : – Ctrl + Spacebar

Selecting entire Row (horizontal ) : – Shift + Spacebar

Selecting all rows & columns : – Ctrl + A

Selecting first active cell  : Ctrl + Home

Selecting last active cell : Ctrl + End

Selecting all columns from a particular cell to the beginning of the column: Ctrl + Shift + Left

Selecting all columns from a particular cell to the end of the column: Ctrl + Shift + Right

Selecting all rows from a particular cell to the beginning of the row : Ctrl + Shift + Up

Selecting all rows from a particular cell to the end of the row : Ctrl + Shift + Down

Selecting first active cell in a row: Ctrl + Left

Selecting last active cell in a row: Ctrl + Right

Selecting first active cell in a column: Ctrl + Up

Selecting last active cell in a column: Ctrl + Down

Do let us know if these simple tips helped you out, and leave your comments. :) Cheerio and happy exceling.

{ 0 comments }

Pwn YouTube with PwnYouTube to download Youtube videos

by Sujoy on August 20, 2010

Yes, we have done quite a few YouTube downloading how-tos in the past. Some of them still work, some don’t. The one which continues to work is the ever-updating awesome tool – KeepVid.com. But remember the good ol’ days of the javascript bookmarklet which used to make life so much easier. Well, the bookmarklet is back again.

And it’s called – PwnYouTube. Go drag and drop it on your bookmarks bar just as I did.

PwnYouTube Bookmarklet

Now when you visit a YouTube video, on the page, when you hit the bookmarklet, the menu option appears on top of the screen. Its on a yellow background, so I don’t think you’ll miss it. For your convenience, it looks like this.

PwnYouTube to download HD videos from YouTube

Right click, and save as shown. Voila! Easy peasy!

Else, there is another alternative. Just append ‘pwn’ before the youtube video URL.

e.g. To download video:  http://www.youtube.com/watch?v=66TuSJo4dZM, enter

http://www.pwnyoutube.com/watch?v=66TuSJo4dZM

You’ll be redirected to deturl.com, and there, you’ll find options to download it from SaveVid, YouDDL and KeepVid.

So there you go, happy downloading YouTube videos.

{ 0 comments }

Google Image Search Hack: Full size images, No Thumbnails

by Sujoy on August 4, 2010

**********************************************************

Google Image Hack

Google Image search is one of the most visited search engines. Be it searching for normal images we want for a project, or something we want to grace our desktop/laptop as a wallpaper. And more often than not, it is the latter. So, it is quite cumbersome when it comes to searching on Google Images for the appropriate sized – or in other words, wallpaper sized images from the huge list of thumbnails. It is a further pain to sort out by clicking on each of them to verify if they are indeed good looking images in the full size, and if they are not pixelised.

The solution: a Google Image Search hack which allows Full size image results, no thumbnails whatsoever, for your full viewing pleasure. [ as shown in the pic above]

The link is here:

Google Image Ripper » Dear Computer,.

Enter your search keyword, choose your size – which ranges from icon to xxlarge to huge. Press “Rip Google” and voila. Just be prepared to be hit by a massive wall of wallpapers. And just for your viewing pleasure, I’ll attach a massive High Definition wallpaper of Inception. Of course, this one’s a thumbnail, so do click on it to enjoy it in full HD glory. [ The image below might take a while to load ]

Inception High Definition Movie Still

{ 0 comments }

Edit and Share YouTube videos online with TubeChop

by Sujoy on July 10, 2010

TubeChop

We all love to share YouTube videos don’t we. Especially with the ever growing number of excellent videos on the world’s biggest video database, we always find something or the other which we would rate as amusing or simply a must-watch. But for some impatient ones like me, we always tend to be really excited about the stuff we share. And we want to share a specific portion of a YouTube video. We often even use YouTube videos for referencing – like a particular portion from a video would help an opinion etc etc. You get it. But how do we achieve it. Well, the usual drill was to mention, please refer the video from 2 mins and 40 seconds onwards blah blah! But not anymore. Techkeyla is here to the rescue. Enter – TubeChop. Not only can you edit YouTube videos, but also share it, embed it, and prove your awesomeness.

So how do you actually do it?

Glad you asked. Just go to TubeChop. The text bar on the site, asks for the YouTube video URL. Just paste your desired URL . For our tutorial, we are using this supercute LOLcat video. Once you paste and hit enter, it will ask you to select the start and end points of the video.

Just drag and seek the start and end position bars as required. Easy peasy!!

TubeChop tutorial - Editing LOLCAT video

Once done, hit the Chop It button.  The next page gives you the link, as well as the Embed Code. Howzzat!
The only weakness of this tool is that it does not work with videos which have disabled embedding.

And because you have been so attentive, you get to see this really cute and home-edited version of LOLCATS. Enjoy and happy edited sharing. Cheerio!

{ 0 comments }

← Previous Entries

Next Entries →