Posts

Showing posts with the label Tips/Tricks - Windows

Excel 2013 Scaling Sheets for Printing

Image
This short video shows how to scale your spreadsheet for printing. As you can see initially this spreadsheet occupies 4 pages. In print preview you can use scaling to make printing more economical. Your options are Fit sheet to one page or fit columns to one page or fit rows to one page. HTH.

How to Export Outlook 2013 Contacts into iCloud

Image

Export Contacts from Outlook 2013 to iCloud

Image

Tips & Tricks // Ninite Installer

Image
If you have a Windows machine you should be using this nifty app. Step 1: Go to http://ninite.com/ Step 2: Check the apps you use Step 3: Save the installer and run it. Step 4: Enjoy your apps without pesky toolbars! By the way you can also use this installer to update your apps… If you are not using ninite you are missing out!

HTC HOME vs METRO HOME

Image
check out these great looking weather widgets for your windows 7 pc :o) http://www.htchome.org/en/

Tips & Tricks|Customize USB Drive Icons

Image
[ As you can see I have named my 320Gb WD Passport as TK-320 and put a stormtrooper icon on it, my 4Gb Pirate Nero drive is named NERO ] If you have a lot of USB sticks or HDD drives (ATM: I have 17 and 2 respectively) it may become confusing which is which. Sure naming them would help but having a custom icon is way better :P It’s pretty simple and straight forward. Create a Text Document Copy and paste this code (3 lines total): [autorun]    icon=YOUR_ICON.ico label=NAME_YOUR_DRIVE Modify the code to fit your requirements Save Rename as autorun.inf Copy autorun.inf and your icon file to the root (no folders) of your drive. -- The next time you plug-in your device you should see your custom icon & drive name.

Tips & Tricks|Deleting Multiple Files Using A Batch File

I noticed that iTunes was creating and dumping *.tmp (temp files) in my iTunes Media Folder and that it was eating up my storage space. Here is a quick and easy way to get rid of these storage munching files. Create a new Text Document and give it a memorable name Copy the code bellow and paste it to your Text Document cd\ cd C:\Users\ <UserAccountName> \Music\iTunes del /Q *.tmp echo Deleting Files echo File Deleted exit NB <UserAccountName> change this to your user account name. Save the file Rename it and change the file extension from .txt to .bat Click on the file to execute the command HTH

Tips & Tricks|Moving iTunes Library to a New PC

Image
The most painless way I have tried so far. There are two (2) parts to your iTunes Files & Library, files are self explanatory and the library will include your playcounts, playlists etc etc. If you sync your iPhone or iPod you need to move your entire library so that you won’t have to make a new partnership. Here’s what you need: iTunes USB HDD Patience Step 1: Copy your files to Ext HDD Plug-in the USB HDD to source PC Start iTunes Edit > Preferences > Advanced (tab) Point it to your USB HDD click ok File > Library > Organize Library… Consolidate Library iTunes will now copy the files over to your HDD Exit iTunes Step 2: Move your Library to Ext HDD Start > Run… type in the library location Copy the files to your Ext HDD Eject your HDD ========================================== Step 3: Move files to new PC Hold Shift key and click on iTunes you will see...

Tips & Tricks|Create Partitions on an External HDD

Image
WARNING THIS WILL DELETE ALL FILES ON THE DRIVE. PLEASE BACK UP YOUR FILES BEFORE PROCEEDING. There are a lot of benefits to making partitions on an installed drive but if you wish to extend this to your external drive here is how. Press WINDOWS FLAG + R (RUN) Type diskmgmt.msc press ENTER You will be presented with the Disk Management Interface, be sure you select your External HDD (here it is My Passport ) Right click and delete the existing partition you should see that your whole drive has become un allocated space (black bar) Right click again and choose New Partition… and follow the Wizard. For storage we will be using Primary partition , hit Next Select how much storage you will allocate for the 1st partition for this example I will create a 100Gb partition , type in the size and hit Next I choose not to assign drive letter, hit Next You may choose to Format the new partition here or later under Windows Explorer . For this tutori...

Windows 7 Window Manipulation Goodies

Ok try these out on your unlocked Protected Features build 6801 of Windows 7 pre beta... -- Whilst Clicked on a Window bring it up to the Top Edge of the Screen, you will see sort of a water drop effect and when you release the mouse button the window will be maximized. -- Aero Shake - While grabbing a Window go left and right with your mouse and it will minimize other Windows and leave current one open. -- AWESOME! Use this and the Win7 keyboard shortcuts and take control of your machine now!

Windows 7 Keyboard Shortcuts / Hotkeys

I was listening to TWiW [This Week in Windows] - and one of the topics discussed was keyboard shortcuts. I immediately started tapping around my keyboard and here is what I've come up with... Really useful! ---- Windows Key + -- Tab = Aero [press Tab to cycle between Windows] E = Windows Explorer R = Run Command F = Search X = Mobility Center L = Lock Computer U = Ease of Access P = Projector T = Cycle Super Taskbar Items S = OneNote Screen Clipping Tool [requires OneNote] M = Minimize All Windows D = Show/Hide Desktop Up = Maximize Current Window Down = Restore Down / Minimize Current Windows Left = Tile Current Window to the Left Right = Tile Current Windows to the Right # = Quicklaunch = = Magnifier -- In Windows Explorer -- Alt + Up = Go up one level Alt + Left = Back Alt + Right = Forward ---- I think some of these will work on older versions like XP and Vista, go try it out on your PC/Notebook/Netbook and let me know how you like it.

Reminders...

Technology is supposed to help us make things easier however sometimes it gives headaches as well. Here's a few reminders on how to lessen tech stress specially nowadays with viri, malware, trojans etc. I wrote about this in May '07 but it is still relevant today! --- READ ON ---

Bow To Me Compaq Presario B1900

Finally finished fixing Yap's notebook. It was stubborn at first but a little tinkering in safe mode and tinkering with msconfig did the trick. Uninstalled Symantec the resource hog and switched to avast. Also swapped out Azureus for uTorrent. Updated Firefox, Yahoo Messenger, Skype, QTime and iTunes. Anyway it's running smooth now. I do suggest that Yap bump the RAM to atleast 1024Mb right now the ATI chip is eating up about 128Mb for VRAM. I think XP with 1024Mb is just about right for most things.

Tips & Tricks|Spyware/Malware Removal + Safe Usage

Image
My friend's notebook was infected by SPYWARELOCK [formerly SPYLOCKED] a nagging malware that is usually disguised as an Audio or Video Codec installer. Which when installed shows fake alerts and tries to get you to purchase crap software. Don't buy it!!! Though it was fairly easy to remove [this is the 2nd time the same notebook had been infected by a similar malicious app, and this is the 4th time I've done this 2x more with different notebooks of different friends]. It maybe frightful to people who don't know what to do. -- First off don't panic. Identifty the infection and see if it can be treated. Worst case scenario is that you have to rebuild or reformat your system which is a PITA. Best case scenario you find the infection and clean your system. Although some say once you get bit you're system is un-secure forever and opt to reformat after backing up their data. Well a quick Google search turned up these instructions and tools and I was done in 5-10 mins....

Hamad Darwish Vista Wallpaper Pack

Check out Hamad Darwish's [aka Vista Wallpaper Photographer] site to get additional Wallpapers that didn't make it to the RTM release of Vista. The images are really nice. Thanks for sharing Hamad. -- http://www.hamaddarwish.com/index.html

Updates for the VGN-UX280P on Vista

If you own a SONY VAIO VGN-UX280P on Vista, head on over to the eSupport Website . There are 2 Hotfixes from Microsoft. One for Windows Media and the other for the Camera. There's a BIOS update and the new SmartWi Manager for Cingular.

New Outlook 2007 Update Out

If you've upgraded to Office 2007 and are experiencing some performance problems with Outlook, maybe this fix will help you out. It's supposed to address issues with performance when dealing with big PSTs. I installed it on my system and will report back if it indeed gave a significant boost to Outlook 2007's performance. Click here for more info and download.

My PC's Windows Vista Experience Index

Image
[Right Click the My Computer Icon then Properties] [Clicking Windows Experience Index will show more details] [you can get even more details too...] Snipped my VAIO's Windows Vista Experience Index [the score is so so IMO], as you can see the processor brought down the score significantly still not too bad for a UMPC. I do feel a lag sometimes when trying to do too much all together. Photoshop is not the best on this system I can tell you that. My next system should probably have a higher score than this. The price of mobility I guess.

WWAN performance Globe Telecom

Image
Did some speed tests last night with the UX280P and my Globe SIM. Location Power Plant Mall, Makati. Used the 200Kb test.

Tips & Tricks|Origami Experience on the UX280P ~ VistaGami :o)

Image
[Music] [Pictures] [Program Launcher] [Videos] [SuDoKu] Found this in one of the forums I joined in the past few days to tweak and optimize my UX280P. Anyway it explains how to get the Origami Experience Pack onto your non-UMPC system [note ORIGAMI was/is the codename for UMPC's], the whole post explains everything you need to do as well as provides links to the softwares needed! :o) So far I'm liking OE except for the fact that it is a bit blurry on my VAIO's 1024 x 600 reso screen [I think it was designed for 800 x 600] no matter I like the interface and the big buttons are easy to press / tap. I'm also liking the included game... SUDOKU! Yeah! So what are you waiting for? Start reading/downloading/tweaking/installing and enjoying follow the link bellow! -- ORIGAMI EXPERIENCE PACK on non-UMPC systems