Convert a Row to a Column in Excel the Easy Way
Mar/100
Sometimes we’ve entered data in a column in Excel, only to realize later that it would be better to have this data in a row, or vise-versa.? Here’s a simple trick to convert any row or set of rows into a column, or vise-versa, in Excel.
Please Note: This is tested in Excel 2003, 2007, and 2010.? Here we took screenshots from Excel 2010 x64, but it works the same on the other versions.
Convert a Row to a Column
Here’s our data in Excel:

We want to change these two columns into rows.? Select all the cells you wish to convert, right-click, and select copy (or simply press Ctrl+C):

Now, right-click in the cell where you want to put the data in rows, and select “Paste Special…”
?
Check the box at the bottom that says “Transpose”, and then click OK.

Now your data that was in columns is in rows!

This works the exact same for converting rows into columns.? Here’s some data in rows:
?
After copying and pasting special with Transpose selected, here’s the data in columns!

This is a great way to get your data organized just like you want in Excel.
| Similar Articles | Productive Geek Tips |
| Latest Software Reviews | Tinyhacker Random Tips |
Here is the original post:
Convert a Row to a Column in Excel the Easy Way
Shift Between Preset Window Sizes in Firefox with ResizeIT
Feb/100
Do you need multiple different “exact-size” windows for web-design work or other activities throughout your workday? Then see how easy it is to switch between sizes with the ResizeIT extension for Firefox.
Before
Here is our pre-extension test browser set against a 1280 x 1024 pixel sized background. Notice the position and size of the browser versus the wallpaper…

Options
As soon as you have installed the extension and restarted Firefox it is recommended to immediately access the “Options”. These are the default settings for the four window sizes that you can switch between.

For our tests we selected for “Position” in relation to all non full-screen sizes and made a slight change to the “Alt + 2” listing so that it was close in size (and proportional) to our browser’s size in the screenshot above.
Once you have made any desired changes click “OK” to save your new settings.

ResizeIT in Action
Here are the results of our settings. The “Alt + 1” keyboard shortcut setting of 300 x 300 pixels…

The “Alt + 2” keyboard shortcut setting with our altered browser window size of 869 x 651 pixels…

The “Alt + 3” keyboard shortcut setting of 1024 x 768 pixels…

And finally the “Alt + 4” keyboard shortcut setting for full-screen.

Now if you are wondering if you can enter in unique and/or unusual custom sizes the answer is yes. Just for fun we altered only the “height setting” for the “Alt + 1” keyboard shortcut. Enter in the appropriate pixel size(s) and click “OK” to save your settings.

Here is the result of the size modification. Custom sizing makes this an extremely useful extension…

Conclusion
If you need multiple different “exact size” windows for your work then the ResizeIT extension is going to make it a pleasure to quickly switch between them. This is definitely a recommended install.
Links
Download the ResizeIT extension (Mozilla Add-ons)
| Similar Articles | Productive Geek Tips |
| Latest Software Reviews | Tinyhacker Random Tips |
See original here:
Shift Between Preset Window Sizes in Firefox with ResizeIT
Back Up a Complete Vista PC Across a Network Using wbadmin
Feb/100
Compared to the backup tools that come with previous versions of Windows, Vista’s Backup and Restore Center, is a delight – except for one small problem:? It can’t do a complete system (image) backup to another computer on the network.? In this article we learn a workaround to this limitation.
Backup and Restore Center
The Windows Vista Backup and Restore Center introduced to Windows users the ability to backup your entire computer:? files, programs, settings, registry – everything.

Running The program created a VHD file – an image of your entire C drive.? In the event of a theft or hard disk failure, your system could be restored to the exact state it was in when the last backup was taken (using the Windows Recovery Environment on your Windows installation DVD).
This VHD image file would typically be enormous (the combined size of all files on your C drive), and so a location to store this file would need to be chosen carefully.? Unfortunately, the only options presented to you were other hard disks in your system (such as an internal D drive or an external USB drive) or a collection of blank DVDs.

An obvious omission was the ability to back up across a Local Area Network, to another computer such as to a file server or backup server.? Only Microsoft would be able to tell us why this option was omitted.? Thankfully it has been added into Windows 7.
If your backup regime requires that your Windows Vista system be backed up across a network, and you’re not willing to shell out for third-party software, such as Norton Ghost or Acronis True Image, then you’ll need to use the little-known Windows system backup utility called wbadmin.? wbadmin is a command-line tool, and so to use it you will probably choose one of the following methods:
- The Windows command prompt,
- Writing a batch file (script), or
- Automating the backup using the Windows Task Scheduler
Given that most people who need to back up a system won’t want to do it just once, and will more than likely have a need to do it on a regular (daily or weekly) basis, this tutorial will explore the third option:
Automating a regular full system backup using the Windows Task Scheduler
To schedule a regular backup, we must first open the Windows Task Scheduler.? This is easily located by clicking the Start button and typing “task“:

The Task Scheduler window then opens. To schedule a backup, click on Create Basic Task…

The Create Basic Task Wizard starts and prompts us for a name by which we would like to refer to this task.? We can give it a name such as “Weekly Full System Backup”:

We then click the Next button and are prompted for how frequently we would like to like to run the backup.? Obviously the choice made at this point is up to you (or your IT department), but for this tutorial we will choose Weekly:

We click the Next button and are prompted to complete the scheduling details.? We will choose Every Wednesday morning at 4:30am:

We click the Next button and are prompted for what type of task we want to perform.? We will choose Start a program:

We click the Next button and are prompted for the name of the program we wish to run, as well as any command-line arguments (parameters) we will to provide to the program.
We could browse for the program, but in this case it’s easier to simply type its name:? wbadmin..
The command-line arguments we will specify in this example are:
start backup -backuptarget:\servernamesharename -include:c:
-user:MYNAME -password:MYPASSWORD -quiet
These options mean the following:
- start? start the job (not now, but when the task is scheduled, of course)
- backup? the job to start is a backup
- ?-backuptarget:\servernamesharename? The location to back up to.? This could be a simple Drive:Folder path (e.g. D:/Backups), or – in this case – the UNC path of a computer and network shared folder.
- -include:c:?? The drives to include in the backup.? If you want multiple drives, separate them with commas (no spaces).? i.e.? -include c:,d:
- -user:MYNAME -password:MYPASSWORD?? The username and password required to access the remote target computer/folder on the network.? (obviously, you replace MYNAME with your actual username and MYPASSWORD with your actual password.)
- -quiet?? Run the job without prompting the user for any information
There are many other options for the wbadmin program.? These are all detailed on Microsoft’s TechNet page (link below).
It is not necessary to specify anything in the Start in box:

That is all the information that the wizard requires.? We click the Next button to see a summary of the task details:

…and then click the Finish button to return to the list of active tasks:

It may be necessary to double-click on the newly created task to adjust some of the properties or conditions, specifically:
- On the General tab, you may wish to ensure that the task runs even if you are not logged in.? If you do this, you will be prompted to supply the login credentials – username and password – of the user that the task is to be run as.
- On the Conditions tab (if your computer is a laptop), you may wish to elect to only run the backup task if the computer is plugged into mains power.
The task will now run every Wednesday morning.? You can also run it manually whenever you want by opening the Windows Task Scheduler, locating the task in the list and clicking the Run button in the Actions pane to the right.
Once the task has completed, you can navigate to the network computer/folder that you specified in the task settings and see the results.? You will see a folder called WindowsImageBackup, and within that a sub-folder with the same name as the computer you were backing up.? If you back up several machines with this technique, you will see one sub-folder for each computer.? Within each sub-folder you will see a subfolder called Backup with a date in its name.? That is where your image files are located, along with some XML housekeeping files.? The backup files are easy to identify, as they are many Gigabytes in size and have a VHD extension.

Notes:
- More information about the wbadmin program can be found on either Microsoft’s TechNet page or on the Wikipedia page.
- VHD files can be mounted and browsed (to restore individual files without having to restore the entire drive) by using the small and useful VHD Attach utility.
- When the task is run the following week, the previous backups will be automatically removed.? Only one set of VHD files will be present in the WindowsImageBackup folder for each computer at any given time.
| Similar Articles | Productive Geek Tips |
| Latest Software Reviews | Tinyhacker Random Tips |
See original here:
Back Up a Complete Vista PC Across a Network Using wbadmin
Access Wolfram Alpha Search in Google Chrome
Feb/100
Do you like using Wolfram Alpha Search and crave on-demand access to it in Google Chrome? See how easy it is to enjoy that Wolfram Alpha goodness with the Chrome Alpha extension.
Chrome Alpha in Action
To get started click on the “Toolbar Button”. This is what the drop-down window will look like…enter the term that you wish to conduct a search for and hit “Enter” on your keyboard or click on “Go!”. Notice how the “Toolbar Button” looks “at rest”…

Once a search is in progress the “Toolbar Button” will change in appearance. There will be a red rectangle across the lower portion with white dots moving through it. It will return to normal when the search is finished.

For our example we conducted searches on three terms (a website, a location, & a business). Our first search was for information on “YouTube”.
Note: If a term generates no results the drop-down window will be blank.

The second search term was “Singapore”…

And the final search term was “Microsoft”. The drop-down window will retain the results for the last search conducted until a new term is entered (even if you restart your browser). Very useful and convenient if you need to refer back to that particular information for a bit during your day.

Conclusion
If you like using Wolfram Alpha Search and have been waiting for an easy way to access it in Chrome, then this extension will be a perfect addition to your browser.
Links
Download the Chrome Alpha extension (Google Chrome Extensions)
| Similar Articles | Productive Geek Tips |
| Latest Software Reviews | Tinyhacker Random Tips |
See the rest here:
Access Wolfram Alpha Search in Google Chrome
Create A Windows Home Server Home Computer Restore Disc
Feb/100
There may come a time when one of the computers on your network will need to be restored from a home server backup. To do this you’ll need a WHS Home Computer Restore CD and here we take a look at how to create one.
Create Home Computer Restore CD
There used to be an ISO stored in the Software folder of WHS that would allow you to create a Restore CD. If you see an image there it’s more than likely outdated. To get the new image head over to the Microsoft site and download restorecd.msi (link below).
?
By default the image is installed to My Documents in the Windows Home Server Home Computer Restore CD (Dual Boot) folder. However, you point it to any directory on your computer you want to use. Actually you might want to send it to the Software share of WHS.
?
To burn the image to CD in Windows 7 you can use the built in Disc Image Burner utility.
If you’re using Vista or XP you can use the free utility ISO Recorder to burn the CD following this guide. They offer both a 32 & 64 bit version of ISO Recorder.
?
Once you have the the restore CD created make sure to keep it in a safe place in case you need it to restore one of the machines on your network.
It’s good to have this disc ready in case disaster strikes so you can restore a machine from WHS backups. In the near future we’ll take a look at completely restoring a computer using the Restore CD and a backup from WHS. Backing up your computer data is extremely important and WHS makes it a “set it and forget it” process. You might also be interested in learning how to configure your computer to backup to Windows Home Server.?
Download The WHS Home Computer Restore CD
Burn ISO Image to Disc with ISO Recorder in Vista and XP
| Similar Articles | Productive Geek Tips |
| Latest Software Reviews | Tinyhacker Random Tips |
Read the rest here:
Create A Windows Home Server Home Computer Restore Disc
Focused New Tabs Quick-Fix for Google Chrome
Feb/100
Are you frustrated with Chrome always opening “right click selected” new tabs in the background instead of focused? If so, then you will definitely want to have a look at the Tabs To The Front! extension.
Before
The standard behavior in Chrome has any new tab that you open from from the “Right Click Menu” always appear in the background. Once in a while might not be much of a problem but if you open lots of tabs this way every day it can get very tiring using your mouse to bring all those tabs to the front.

Tabs To The Front! in Action
Here we are ready to open the link pictured above in a new tab once again…

With the Tabs To The Front! extension that extra mouse click is eliminated and our new tab is focused and ready to go. Think of all the hassle that could be eliminated from a day’s worth of browsing!

Conclusion
If you are tired of having to use your mouse to focus new tabs all day long, then this little extension is going to make browsing a much more pleasant experience for you.
Links
Download the Tabs To The Front! extension (Google Chrome Extensions)
| Similar Articles | Productive Geek Tips |
| Latest Software Reviews | Tinyhacker Random Tips |
Excerpt from:
Focused New Tabs Quick-Fix for Google Chrome
Clear Browsing History in Firefox with a Keyboard Shortcut
Feb/100
Are you tired of manually deleting your browser history or having to wait until the browser is closed to remove it? Then you will want to have a look at the Clear History extension for Firefox.
Before
Unless you use “Private Browsing Mode” 100% of the time, you are naturally going to have browser history build up. Most of the time this is nothing to worry about but what if you:
- Forgot to use “Private Browsing Mode” and need an extremely quick way to delete the history.
- Just want a simple way to instantly clear out the history “clutter and build up” while your browser is still open.

There is no help for deleting history in the “History Menu”…

You could do manual deletions in the “History Sidebar”…but this is not the most efficient method.

Or if you prefer you could have modified the “Privacy Options” ahead of time.

But even with the modifications available in the “Privacy Options” you will still have to wait until your close your browser.

Even selecting “Never remember history” may not be the best choice for you. What you need is a “quick and easy” on-demand option.

After
After restarting you will find a new menu entry in your “History Menu”. All that you need to do to delete all of your browser’s history is click on “Clear history” or use the keyboard shortcut “Meta + Alt + C”.

Instant satisfaction…it just does not get any easier than that while you have your browser open in a regular browsing session.

Conclusion
If you need to clear your browser’s history at a moment’s notice or just want to remove the history “clutter and build up” then you will absolutely love Clear History’s one click cleaning goodness.
Links
Download the Clear History extension (Mozilla Add-ons)
| Similar Articles | Productive Geek Tips |
| Latest Software Reviews | Tinyhacker Random Tips |
Here is the original:
Clear Browsing History in Firefox with a Keyboard Shortcut






















Convert YouTube Videos to MP3 with YouTube Downloader
Mar/100
Are you looking for a way to take the music videos you watch on YouTube and convert them to MP3? Today we take a look at an easy way to convert those YouTube videos to MP3 for free with YouTube Downloader.
The YouTube Downloader functions in two steps. First, it downloads the video from YouTube in MP4 format, and then allows you to convert that MP4 file to MP3.
Note: It also supports conversion conversion to some other formats such as AVI video, MOV, iPhone, PSP, 3GP, and WMV. ?
Installation and usage
Download and Install YouTube Downloader. (See download link below)
Open the YouTube Downloader by clicking on the desktop icon.
Find a YouTube video you’d like to convert to MP3 and copy the URL.
Paste the URL into the “Enter video URL” text box in YouTube Downloader. When you hover your mouse over the text box, the text box will auto-fill with the URL from your clipboard.
Select the “Download video from YouTube” radio button and click “Ok.”
Choose a folder to location to download your YouTube video and click “Save.” The video is downloaded in MP4 format.
Now wait while the video is downloaded to your hard drive.
Select the “Convert video (previously downloaded) from file” radio button.
Click the (…) button to the right of the “Select video file” text box to browse for and select the MP4 file you just downloaded.
Then select “MPEG Audio Layer (MP3) from the “Convert to” drop down list.
Select “OK” to begin the conversion.
Choose the conversion quality by moving the slider to the right or left. The options are: Low (96kbps bite rate), Medium (128kbps bit rate), Optimal (192kbps bit rate), and High 256kbps bit rate). Here you can select the output volume as well. Click “OK” when finished.
If there is a portion of the beginning or end of the video that you wish to cut out of the MP3, select the “Cut video” check box and choose a Start and End time. Click “OK” when finished. Note: The start and end time represent the audio portion of the MP3 you wish to keep. All portions before and after these times will be cut.
The conversion process will begin and should only take a few moments. Times will vary depending on the size of the video you’re converting.
Conversion was successful!
The MP3 you converted will be in the same directory you downloaded the video to.
Now you’re ready to listen to your MP3 or import it to your Zune, iTunes, or music library. You may also want to delete the MP4 files after the conversion if you will no longer need them.
Conclusion
YouTube Downloader features a very simple interface that’s user friendly and easy to use. It comes in handy when you watch videos that look horrible, but the sound quality is good. Or if you just need to hear the audio of something posted and don’t need the video. It also allows you to download from Google Video, MySpace, and others.
Download YouTube Downloader
See more here:
Convert YouTube Videos to MP3 with YouTube Downloader