PCs Place

How to Use Multi-Lined Custom Formats in Excel Cells

Prasanth Chandra — Sat, 07 Nov 2009 09:33:00 +0000

Formatting cells to suit your requirement in Excel is one of the easiest tasks to perform. Excel is ﬂexible enough to let you customize formats to suit your needs as well. But what if you require two lined custom formats in Excel?

You can use the wrap text feature of Excel but that depends on the column width and text length. You can use the [Alt] + [Enter] break key, but it does not work with formats. What if you need a format with the day and date on top followed by the month?

You can maintain consistency by creating a multi-line custom format with the help of this simple tip. To do so just carry out the following steps:

Select the cell to which the format is to be applied.
Click the “Home” tab. Click the small arrow near the “Numbers” group.
The “Number” tab of the “Format Cells” dialog box appears.
Under the “Category” list, select the “Custom” option.
In the “Type” text box, type “ddd d” without the quotes.
Press the [Alt] key and type “0010” from the numeric keypad.
The cursor jumps to the next line.
Although it is not visible, Type “mmmm” without the quotes.
Next, click the “Alignment” tab.
Check the “Wrap Text” option.

You can try this tip to make your custom formatted cells in multiple lines. Also check out our previous Microsoft Excel Tips.

Related posts:

How to Share a Drive over a Network in Windows Vista

Prasanth Chandra — Wed, 04 Nov 2009 12:08:00 +0000

At times you may require transferring huge ﬁles from one system to another. This process could be tedious especially when it comes to using several storage devices to transfer data. But with Vista, this process is simpliﬁed if you’re connected via a LAN. You can share your drives of hard disk over a network easily in Windows Vista.

Previously we discussed How to Turn Off or Disable Admin shares of your Drives. Now let us see how to share your drive over a network, follow the steps given below:

Double-click “My Computer”.
Right-click on a particular drive and click “Share”.
Click the “Advanced sharing” button.
Select the “Share this folder” checkbox.
Once done click “OK”.

You can set permissions for different users who access your drive i.e. Full Control, Change and Read. Full Control allows a user to read, write, modify or delete the ﬁles in the drive. The Change option allows a user to only read and make changes to a ﬁle without deleting it whereas the Read option only allows the user to read the ﬁle.To set these permissions:

Double-click “My Computer”.
Right-click on a particular drive and click “Share”.
Click the “Advanced sharing” button.
Select the “Share this folder” checkbox.
Click the “Permissions” button.
In the “Permissions for Everyone” section, select the “Allow” or “Deny” checkboxes next to corresponding permissions.
Once done, click “OK”.

Related posts:

xVideoServiceThief – Download Videos / Movies from YouTube, Metacafe, Vimeo, Daily Motion, Blip like Websites

Prasanth Chandra — Tue, 03 Nov 2009 12:52:00 +0000

xVideoServiceThief ( xVST ) is free software to download video clips or Movies from 73 + various video sharing or hosting websites like YouTube, Metacafe, Google Video, Yahoo, bebo, Blip, Dailymotion, live video, MySpace, Vimeo, Zedge, etc. The video files can be downloaded either by input of the URL or via drag and drop to the list.

It also has ability to convert each video in most popular formats like AVI, MPEG1, MPEG2, WMV, MP4, 3GP, MP3 file formats. The options of xVideoServiceThief are amazing and are very helpful to get any video from any website easily. Here is a quick list of its never ending features..

Download videos from different websites.
HTTP & RTMP support
Convert downloaded videos
Simultaneous downloads with scheduling
Search, play, pause and resume videos
Drag & Drop support
Proxy server support

In addition to these it also has Children protection which disables adult website support and protect your children from porn sites. You can even select which websites are allowed and which websites must be blocked. It is available in 14 languages for Windows, Linux and Mac platforms.

Get xVideoServiceThief

Related posts:

TrapCall – Unmask Blocked / Restricted Calls on your Mobile Phone

Prasanth Chandra — Mon, 02 Nov 2009 11:57:00 +0000

TrapCall is a free web service which lets you unmask blocked or restricted calls on your mobile phone without any software. It can be used to identify the number behind any call and reveal the caller identity of unidentified or masked calls.. It works on almost every phone with any provider. You don’t even need to change your current number.

When you get any annoying blocked or restricted call, Trapcall receives the blocked call and its ultra-high tech servers snap their digital fingers and the convenience begins and the unblocked number is instantly sent to your cell phone.

The free version of TrapCall has Caller ID unmasking but with paid versions you get other features like blacklist unwanted calls, Missed call alerts, record incoming calls etc. You can always know who is calling with TrapCall.

Related posts:

Optimize And Tweak The Performance Of Windows 7 & Vista – TweakStar

Prasanth Chandra — Sun, 01 Nov 2009 11:44:00 +0000

TweakStar is a free program which is competently easy to use for optimize the performance of Windows 7 and Windows Vista operating systems. This optimization tool offers you to optimize the performance of newly released Windows 7 in a simple and intuitive manner.

Once installed, it will do an analysis of your system and tells you what can be optimized, thereby giving you a proper advice. There are several categories that can be summarized in: Windows / System, File System, Network / Internet, Configuration / Appearance, Security Leaks, Privacy Leaks, Application Tuning, and CPU / Memory / Hardware.

Each category has a link called Customize, on clicking that you can see all the Tweak and tips for that particular category and you can choose one or more tweaks to be applied.

There are different profiles that you can choose which already contain a number of pre-packaged tweaks that you can apply immediately. Following are some: Default, Windows Appearance, IE and Explorer appearance and functionality, Security and Privacy, Speedup and increase free disk space, Enhanced Customization, and Internet / Network.You can also create a backup of the registry of Windows.

Download Tweak Star

Also check out how to optimize Win 7 using GigaTweaker.

Related posts:

Hide / Make Files Invisible On Your Hard Disk & Pen Drive – WinMend Hidden Folder

Prasanth Chandra — Sat, 31 Oct 2009 10:33:00 +0000

WinMend Hidden Folder is a free program which enables you to hide files and folders. It guarantees optimal security and data protection, the program can quickly make invisible files and folders both on the local drive or on removable disks such as pen drive / USB flash drive.

The files or folders made invisible are accessible even from another operating system on the same PC or another computer. You can even set a password to those invisible files and folders. The hidden data can be made visible again only when you insert the password.

The data is completely invisible to other programs running on your computer or another operating system. However please note that this application is for personal use.

Remember that the configuration and use of True Crypt is more complex and takes longer to configure and understand its operation, to be used only in cases where data are extremely important to maintain a certain level of secrecy. For everything else you can use Folder Hidden WinMend which is more than enough to have good security.

Download WinMend Hidden Folder

Related posts:

Create your Custom Theme for Firefox with AnyColor

Prasanth Chandra — Fri, 30 Oct 2009 13:09:00 +0000

No wonder than soon with time, Mozilla Firefox have become one of the most favorite Internet browsers for most of the users. There are number of tricks and programs used to tweak and enhance the performance of Firefox. AnyColor is a free add-on which allows you to create your own customized theme for your Mozilla Firefox browser.

Also check out our Firefox Section with articles like 25 best and most useful Firefox Addons.

We try themes to make our desktops look gorgeous. But this amazing program will make you Mozilla Firefox go beyond amazing functions. Looks with premium functions will always make you more addicted to Firefox browser.

It ‘a great add-on that allows you to create your own custom theme in minutes. Below are the features of AnyColor:

Choose your own colors and make an instant preview
Choose your custom image for the top and bottom of the browser
Choose a preset already included or edit / create one for you
Create scripts and change the appearance of the browser tubes using dynamically generated content

Download AnyColor.

Related posts:

How To Choose The Best Windows 7 Version For Your Computer

Prasanth Chandra — Thu, 29 Oct 2009 12:23:00 +0000

Windows 7 is available in several versions that are obviously of different costs. So how do you choose the right one that fits to your computer configuration? Here’s a brief guide to help you better understand features offered by each version of Windows 7, which will help you to make the best of this much awaited operating system. You can look at this complete table that compares all the features of different versions of Windows 7

Windows 7 Starter

Windows 7 Starter is the basic version and one that has fewer features of all primarily suitable for Netbook, but I personally do not understand the reason behind it.There is not much difference between the Home Basic and Premium. The Basic does not have the Multitouch, gaming and media center.

Windows 7 Home Premium

Windows 7 Home Premium is the recommended minimum for a PC version of the cost. Aero Peek has functions for previewing the programs and to clean the desktop, Aero Snap resizing windows and Aero Skins for translucent windows and the taskbar with all the effects. Also contains Aero Shake is a quick way to minimize windows and clean the desktop. It also allows you to manage themes and other customizations.

Windows 7 Professional

Windows 7 Professional is the most powerful (it also costs a bit more) and is suitable for home use but especially for the office. Supports up to 192Gb of RAM in 64-bit mode.Windows 7 Ultimate supports all the features plus the virtual hard disk boot and a system for managing applications under Unix. Great for developers and advanced users.

Windows 7 Ultimate

Windows 7 Ultimate is the complete package of the operating system. It has got every feature like Aero, Windows media center, Domain joining, App locker, presentation mode, MUI language packs, virtual desktop interface, etc. This is the ultimate version as the name suggests and if you are looking to use each and every feature of Windows 7, this will be the best choice.

We recommend the Home Basic version for normal users who do not often use the PC, the Home Premium for the most expert users who use it often. And all other versions for experienced and advanced users and Ultimate for people who want the fully featured Windows 7.

Related posts:

Clipboard Help + Spell – Free Text-based Clipboard Utility

Prasanth Chandra — Wed, 28 Oct 2009 09:31:32 +0000

Clipboard Help and Spell can enhance the clipboard of your Windows PC. It is a free text based clipboard utility embedded with so many features which will simplify organizing the clipboard data. It helps you view, sort, search, and filter by text, last view date, modification date. Organizing notes or clips is more convenient this way. Along with this you can even do text formatting like spell checker, identifying mistakes, etc.

Features of Clipboard Help + Spell :

Database stores history of all past text clipboard entries for easy viewing, modification, and search
Use it for keeping hierarchical notes – search, sort, filter by text, modification date, last view date
Super easy and super fast search function – or use complex filters if you need them – you’ll never have a problem finding a note again!
Organize your notes and clips any way you want – show them all or view by group or category; view your clips any way you like
High-quality spell check – underlined mistakes; learning spellchecker
Configurable hotkeys for common functions
Powerful text formatting options – make your own presets for common functions
Simple functions for copying and pasting into and out of other applications

Download Clipboard Help+Spell

Related posts:

JPG illuminator – Adjust Light, Color Contrast of Underexposed / Dark Photos

Prasanth Chandra — Tue, 27 Oct 2009 08:48:40 +0000

JPG Illuminator is a free photo-editing tool that can do small corrections to images. It can adjust light and coloring and specializes in brightening and the white balance of images. It covers all basic image editing features along with options to edit underexposed photos and adjust the colors red, blue and yellow.

This application is highly useful for Photographers and people who love to manipulate photos or pictures using software so that they can correct the flaws and get the perfect output. This helps to put pictures of circumcised straight, raise, or tone.

Features of JPG Illuminator..

Lights on the characteristics of the exposure of a camera with precise color correction white balance
Manipulation of the lights, the middle, the shadow and the black dot
Three contrasting features, spectral color correction
Black / White conversion with color filters and toning
Smoothing and sharpening of images
Alignment, of perspective deskew and cropping
Correction of chromatic transverse imperfections
Dashing Working with Filter Presets
Simple fast operation with smart features

It is very small and fast and runs without installation. JPG Illuminator is the best free tool to repair your dark photos. It can work only with JPG format images.

Related posts: