How to Create a Browse Tab in Excel

Spreadsheet tables are great for computers, but difficult for people – all that scrolling right and left to see all the data in a row. A Browse tab is a freely arranged screen of data taken from a single row with a scrollbar for navigation among rows. A high number of columns poses no constraint, since the full area of the screen is available.

Check out how to do it here.

Leave a Comment

Open each Excel spreadsheet in new window

I am sure you have noticed that when you already have a spreadsheet open and you open another via Windows Explorer it opens in the same instance of Excel. How great would it be to have each spreadsheet open in it’s own instance (multi monitors anyone?). Well you can and it’s easy to do. Just follow the instructions below.

You have to tell Excel not to use DDE to open the worksheet.
Open Windows Explorer, Tools, Options, File Types
Scroll down to XLS
Select Advance Button
Click on OPEN in the Actions window, Then Edit
On the 2nd line for application used add "%1".
Make sure to put the quotes around %1.
Example …\Excel.exe" /e "%1"
Write down what you see in the DDE Section.
You will need this information if you want to return to the original settings.
Now DeSelect Use DDE
When you double click on any XLS file a separate instance of excel will run. Another advantage is that you can open more than one XLS file with the same name.

Sourced from Techrepublic.

 

Comments (36)

Sound and ringtone editor

I have found and used a nice little application to edit sounds and make ringtones. It’s called WavePad Sound Editor.

A full featured professional audio editor for Windows or Mac OS X. It lets you make and edit music, voice and other audio recordings. When editing audio files you can cut, copy and paste parts of recordings and, if required, add effects like echo, amplification and noise reduction. WavePad works as a wav editor or mp3 editor but it also supports a number of other file formats including vox, gsm, real audio, au, aif, flac, ogg and more.

 

Here is a link to the site.

Leave a Comment

CERN LHC Rap Video

Been having a tough time figuring out just what CERN’s Large Hadron Collider does? Well check out this nicely made video and all will be explained.

 

Comments (1)

More Cowbell

"More cowbell" is an American pop culture catchphrase that started from an April 8, 2000 Saturday Night Live comedy sketch about the recording of the song "(Don’t Fear) The Reaper" by Blue Oyster Cult. The sketch featured guest host Christopher Walken as music producer Bruce Dickinson and Will Ferrell as fictional cowbell player Gene Frenkle. In the television special Saturday Night Live: 101 Most Unforgettable Moments, this sketch is moment number five.

Watch the full sketch here.

Leave a Comment

Randy Pausch has passed away. He was amazingly inspirational

Randy Pausch, a computer science professor whose "last lecture" about facing terminal cancer became an internet sensation and a best-selling book has passed away at 47. Pausch was diagnosed with incurable pancreatic cancer in September 2006. His popular last lecture at Carnegie Mellon University in September 2007 garnered international attention and was viewed by millions on the internet. Here is a link to his last lecture at CMU on Youtube.

Leave a Comment

Internet Explorer 7 Professional

IE7Pro is a must have add-on for Internet Explorer, which includes a lot of features and tweaks to make your IE friendlier, more useful, secure and customizable. IE7Pro includes Tabbed Browsing Management, Spell Check, Inline Search, Super Drag Drop, Crash Recovery, Proxy Switcher, Mouse Gesture, Tab History Browser, Web Accelerator, User Agent Switcher, Webpage Capturer, AD Blocker, Flash Block, Greasemonkey like User Scripts platform, User Plug-ins, MiniDM, Google sponsored search,IE Faster and many more power packed features. You can customize not just Internet Explorer, but even your favorite website according to your need and taste using IE7Pro

Download it here!

Leave a Comment

Ride to Work Day!!!

 This Wednesday July 16th is Ride To Work Day.  Like I need to tell you a reason to get on your bike and ride but…well….be sure to ride!!

 

Leave a Comment

Managing Terminal Services Sessions Remotely

There are only 2 users allowed for administration so occasionally both are used up and you can’t access the server.  This may happen if two people are legitimately using the servers or if someone forgot to log off.

You would think this would be as easy as connecting to the remote server by adding the Terminal Services Manager snap-in to a MMC console or remotely stopping and starting the service (in a pinch).  Strangely, these obvious solutions aren’t available.  Terminal Services Manager doesn’t exist as a snap-in to connect to a remote machine and because the TermService service is a core system service, you can’t even stop it on the local machine, let alone a remote one.

Fortunately there is an easy solution.  Windows 2000+  (includes Windows XP and 2003) have two command-line tools called qwinsta and rwinsta that can query and reset a remote session.

 

[Read the rest of this entry…]

Leave a Comment

The Lego Secret Vault

Gizmodo has an exclusive video and feature of one of the most heavily guarded secrets in Lego: the security vault where they store all the Lego sets ever created, new in their boxes. 4,720 sets from 1953 to 2008. Really amazing stuff and a trip down memory lane to every person who has played with the magic bricks. All combined, the collection must be worth millions, not only because of the collector value, but also because Lego uses it as a safeguard in copyright and patent cases.

Leave a Comment