Tech Tips


10/17/2008: 11:21 am: PcmanTech Tips

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.

9/18/2008: 9:16 am: PcmanTech Tips

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.

 

8/20/2008: 4:09 pm: PcmanTech Tips

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.

7/16/2008: 8:23 am: PcmanTech Tips

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!

7/9/2008: 10:03 am: PcmanTech Tips

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.

 

(more…)

6/17/2008: 8:25 am: PcmanTech Tips

Robocopy GUI also extends the functionality of the existing Robocopy tool in some very interesting ways. For example, this tool is multithreaded, allowing you to create a Robocopy script, execute it, and begin creating another one while your first script is still running. It also allows you to save your scripts (even if you don’t actually execute them) so that you can create a library of common scripts or share them with your colleagues. And most importantly, Robocopy GUI allows you to save your default settings so you don’t have to start from scratch every time.

You can download it here.

6/11/2008: 10:40 am: PcmanTech Tips

I am sure many of you have had a drive, especially a very large one, that you did not want to have chkdsk run on when restarting a server. If so you can use the command below to disable it from occurring at boot up on a per drive basis.

chkntfs /x c: (where c: is you can replace with the drive you want to exclude from checking)

Next Page »

Sign by Danasoft - Myspace Layouts and Signs

Powered by WordPress

Site copyright © pcman.net. All rights reserved. - Comment or Question? -Click Here-