DavidTan.org

Personal Tech . How To . Tips . Web. Development

You are here: Home / Archives for Tips, Hacks, Tricks
amazon discount deals

How To Disable BitTorrent Support In Opera

My favorite internet browser, Opera, has a buit in download manager which helps you to handle BitTorrent downloads automatically. This is a nice utility and there’s absolutely nothing wrong with it as long as you are already happy using it. However, the only thing that Opera’s BitTorrent built-in client doesn’t do is that it doesn’t allow you to select which files to download in the packaged torrent.

This need got me looking for other download managers such as Thunder (XunLei) and Free Download Manager (FDM) to handle all my downloads. However, by default, Opera still uses its built-in BitTorrent client to download any .torrent files you clicked. In order to get other download managers to handle BitTorrent downloads while using Opera, you have to disable that by doing one of the followings:
[Read more…]

Microsoft Office Excel Keyboard Shortcuts

Here’s a list of excel shortcut keys that can help you improve your productivity when working with spreadsheets in Excel.

Column 1 Column 2
Absolute/relative/mixed reference F4
AutoSum Alt =
Bold Ctrl-B
Border lines off Ctrl-Shift _
Border lines on Ctrl-Shift &
Calculate active sheet Shift-F9
Calculate all worksheets F9
Close Ctrl-W
Collapse selection to active cell Shift-Backspace
Comment insert/edit Shift-F2
Copy Ctrl-C
Copy formula from cell above Ctrl ‘
Copy value from cell above Ctrl-Shift “
Cut Ctrl-X
Date Ctrl ;
Delete range Ctrl –
Delete to end of line Ctrl-Del
Show values/formulas Ctrl `
Edit cell F2
Enter formula as array Ctrl-Shift-Enter
Fill down Ctrl-D
Fill right Ctrl-R
Find Ctrl-F
Format commas (2 decimal places) Ctrl-Shift !
Format currency (2 decimal places) Ctrl-Shift $
Format date (day, month, year) Ctrl-Shift #
Format exponential number (2 decimal places) Ctrl-Shift ^
Format general number Ctrl-Shift ~
Format percentage (0 decimal places) Ctrl-Shift %
Format time (hour and minute) Ctrl-Shift @
Formula =
Function Wizard Shift-F3
GoTo Ctrl-G
Group row/column Alt-Shift-Right
Hard Return in cell Alt-Enter
Hide selected column(s) Ctrl-0 (zero)
Hide selected row(s) Ctrl-9
Insert chart sheet F11
Insert Function components Ctrl-Shift-A
Insert range Ctrl-Shift-Plus
Insert worksheet Shift-F11
Italics Ctrl-I
Menu bar F10
Move between noncontiguous selections Ctrl-Alt-Left/Right
Move left/right one screen Alt-PgUp/PgDn
Move to beginning of worksheet Ctrl-Home
Move to edge of region Ctrl-Arrow
Move to end of row End, Enter
Move to end of worksheet Ctrl-End
Move to next corner of selection Ctrl .
Move up through a selection Shift-Enter
Name a range (Insert/Name/Create) Ctrl-Shift-F3
Name a range (Insert/Name/Define) Ctrl-F3
New Ctrl-N
Next window Ctrl-F6
Next worksheet Ctrl-PgUp
Open Ctrl-O
Outline symbols display/hide Ctrl-8
Paste Ctrl-V
Paste named range (Insert/Name/Paste) F3
Previous window Ctrl-Shift-F6
Previous worksheet Ctrl-PgDn
Print Ctrl-P
Repeat Find Shift-F4
Repeat/Redo Ctrl-Y
Replace Ctrl-H
Save Ctrl-S
Save As F12
Scroll to display active cell Ctrl-Backspace
Select array to which active cell belongs Ctrl /
Select cells directly referred to by selected formula Ctrl [
Select cells referred to by selected formula Ctrl-Shift {
Select cells with comments Ctrl-Shift ?
Select column Ctrl-spacebar
Select current region Ctrl-Shift *
Select formulas that directly refer to active cell Ctrl ]
Select formulas that refer to active cell Ctrl-Shift }
Select objects on worksheet Ctrl-Shift-spacebar
Select row Shift-spacebar
Select to beginning of row Shift-Home
Select to beginning of worksheet Ctrl-Shift-Home
Select to edge of region Ctrl-Shift-(Arrow)
Select to end of row End, Shift-Enter
Select to end of worksheet Ctrl-Shift-End
Select visible cells in selection Alt ;
Select worksheet Ctrl-A
Shortcut menu Shift-F10
Spelling and Grammar check F7
Strikethrough on/off Ctrl-5
Style box Alt ‘
Tab inserted Ctrl-Alt-Tab
Time Ctrl-Shift-Colon
Underline Ctrl-U
Undo Ctrl-Z
Ungroup row/column Alt-Shift-Left
Unhide column(s) Ctrl-Shift )
Unhide row(s) Ctrl-Shift (

Remote Desktop and Screen Sharing Presentation Tool

I was checking out how Mikogo can help me join or share an online presentation and seeing everything that the other person is doing online from his/her computer.

The features are pretty standard as you have expected from this kind of application:
– Screen Sharing
– Change Presenters – I love this feature!
– Remote Control
– Pause Transmission
– Application Selection – Unique Offering not found anywhere else
– File Transfer
– Idustry-leading 256-AES end-to-end encryption.
– No configurations or network/firewall changes
– As a presenter, invite and share your screen with up to 10 people at the same time
[Read more…]

Top 16 Rapidshare Share Search Engines

Rapidshare is one of the most popular file hosting provider on the internet but unfortunately doesn’t offer any file search utility. Here’s a list of third party rapidshare search engines which crawls and indexes files that can be downloaded from rapidshare (some of them also do megaupload and a couple of others).
[Read more…]

Categories

Social