Scale your spreadsheet to fit on one page when printing from Excel.

Printing from Excel can be very frustrating, especially if your spreadsheet is too wide or too tall to fit on a single page.

You can use the Scaling option in Page Setup to set limits on how many pages wide and tall your document should be when you print it. The problem with that is that you can find your page fits onto one page, but becomes too small to read. Not only that, but Excel ignores any manual page breaks you've entered. This lesson explains how you can print your spreadsheet so it automatically scales to be one page wide without forcing the rows into a single page.

Scaling your spreadsheet when printing

You can use the Scaling option in Page Setup to set limits on how many pages wide and tall your document should be when you print it.

If you're using Excel 2010 

1. Click the Page Layout tab.
2. Set the Scale to Fit options for Width and Height to the values you want.
3. Print your spreadsheet.

If you're using Excel 2007 and earlier for PC, or Excel for Mac 2008 or 2011

1. Open Page Layout
2. In Excel 2007, click the Page Layout tab, then click the small arrow in the bottom right corner of the Page Setup group (this also works for Excel 2010 as an alternative to the instructions above)
3. In earlier versions of Excel, and for Excel 2008 and 2011 for Mac, click File, then Page Setup.
4. Enter the number of pages wide and tall you want your spreadsheet to be when printed. For example, you may choose to set your spreadsheet to be 1 page wide and 2 pages tall when printed.
5. Print your spreadsheet.

The problem with this approach is that you can find your spreadsheet is scaled down too far and becomes too small to read. Not only that, but Excel ignores any manual page breaks you've entered.

Scaling an Excel spreadsheet to a specific number of pages

Suppose you want your Excel spreadsheet to print out one page wide, but you don't mind how many pages tall the print out is. It could also be that you have horizontal page breaks that you want to keep when you print your spreadsheet.

Scaling to Fit in Excel 2010 (method 1) 

1. Click the Page Layout tab.
2. Set the Scale to Fit option for Width to be 1 page.
3. Set the Scale to Fit option for Height to be Automatic.
4. Print your spreadsheet.

Scaling to Fit in Excel 2010 (method 2)

1. Choose File > Print
2. Choose Fit all columns on one page
3. Print your spreadsheet

Both methods will scale your spreadsheet so it prints out exactly one page wide. The number of pages it prints will depend on how many pages tall the scaled down spreadsheet is. Excel will ignore any vertical page breaks you've inserted when you do this, but will keep your manual horizontal page breaks.

Of course, if you want the spreadsheet to print out just 1 page tall, and as many pages across as it needs, you'd reverse the values in steps 2 and 3 of method 1 above.

Scaling to fit in other versions of Excel (PC and Mac)

You can get the same result when printing from other versions of Excel for both PC and Mac. This tip works in Excel 2010 as well, but the instructions above are an easier way to do it.

1. Open Page Setup.
2. Click the Page tab.
3. Click the Fit To option.
4. Enter 1 for the number of pages wide.
5. Delete the value for the number of pages tall and leave it blank.

WinSetupFromUSB – Install Windows XP from USB Flash Drive

This guide will show you, how to use WinSetupFromUSB to create a bootable USB Flash Drive including all Windows source files, plus the following installation of Windows XP. Compare to the different USB_Multiboot versions, WinSetupFromUSB comes with a Graphical User Interface (GUI) and is in my opinion easier to use.

Here you can get the latest version of the program and you will also find many detailed informations about WinSetupFromUSB.
I’ve tested this guide with a 32-bit version of Windows XP and a 64-bit version of Windows Vista and it worked flawlessly.

Prerequisites:

All you need is:

• a USB Flash Drive with at least 1GB of storage
• the original Windows XP Setup CD
• WinSetupFromUSB

If you use nLite to slim down your version of Windows XP, please keep the following in mind:

DO NOT remove “Manual Install and Upgrade”
under Operating System Options!

I also recommend to integrate Service Pack 3 into your Windows XP source files.

1. Preparations

Download and install WinSetupFromUSB. Default installation path is C:\WinSetupFromUSB.
Create a new folder with the name WINXPCD in the root directory of drive C:\ and copy all files from your Windows XP Setup CD into this folder. Depending on your version of Windows XP, the content of C:\WINXPCD should look approximately like this:

The following files will show you, which Service Pack is already integrated into your CD:

• WIN51IC.SP1, Sevice Pack 1
• WIN51IC.SP2, Sevice Pack 2
• WIN51IC.SP3, Sevice Pack 3

2. Start WinSetupFromUSB

Connect the USB Flash Drive to your PC and start WinSetupFromUSB. It should show up under USB Disk Selection :

3. Select your Source Path

Click on Browse under Windows 2000/XP/2003 Source and navigate to the folder with your Windows XP Source Files. It should be C:\WINXPCD:

Click OK and C:\WINXPCD should show up under Windows 2000/XP/2003 Source :

4. Format USB Flash Drive

PeToUSB or HP Format Tool are used to format the USB Flash Drive. There is no need to download these programs seperately as they are already included in WinSetupFromUSB.
USB Flash Drives up to 2GB should be formatted with PeToUSB in FAT16, USB Flash Drives with 4GB or more with HP Format Tool in FAT32.
I will use PeToUSB to format my Kingston Data Traveler with 2GB.
In the main window of WinSetupFromUSB click PeToUSB under Format target using to start the program. The USB Flash Drive should show up under Destination Drive. Check USB Removable, Enable Disk Format and Quick Format. Uncheck Enable File Copy under File Copy Options :

Click Start and answer the following two questions “Continue?” with Yes.

All existing volumes and data will be lost!

If everything goes well, the message “Operation Completed Successfully!” should appear. Click OK and close PeToUSB.
The process with HP Format Tool is similar.

5. Copy Windows XP Source Files

To start the process of copying the Windows XP source files to the USB Flash Drive, click GO in the main window of WinSetupFromUSB. Depending on the write speed of your USB Flash drive it may take a while to copy all files.

At the end the following notice about the Windows installation process should be displayed:

Click OK and close WinSetupFromUSB with EXIT.

6. Windows Installation – Part 1

Connect the USB Flash Drive to your PC and turn on the computer. Press ESC at the boot screen and you will be able to select the USB Flash Drive as your boot device from the boot menu.

The ESC key is used by ASUS for the Eee PC series.
Other manufacturers may use other keys, e.g. F8 or F12.

After booting from USB Flash Drive, the following menu should be displayed:

• Windows XP/2000/2003 Setup – First and Second parts

Press Enter or wait 10 seconds to get to the next menu:

• First part of Windows XP Home Edition setup
• Second part of XP Home Edition setup+Start Windows for first time

First part of Windows XP Home Edition setup is already selected. Press Enter or wait 10 seconds to start the Text mode part of setup. During this part you can create, delete and format partitions and finally the setup files are copied to your hard disk. At the end the system will restart automatically.

7. Windows Installation – Part 2

After restart, boot the PC again from your USB Flash Drive. The same menu should be displayed:

• Windows XP/2000/2003 Setup – First and Second parts

Press Enter or wait 10 seconds to get to the next menu:

• First part of Windows XP Home Edition setup
• Second part of XP Home Edition setup+Start Windows for first time

Second part of XP Home Edition setup+Start Windows for first time is already selected. Press Enter or wait 10 seconds to start the GUI mode part of setup. During this part you will be asked for your product key, timezone, usernames and other necessary informations. At the end the system will restart automatically.

8. Windows Installation – Part 3

After restart, boot the PC again from your USB Flash Drive. The same menu should be displayed:

• Windows XP/2000/2003 Setup – First and Second parts

Press Enter or wait 10 seconds to get to the next menu:

• First part of Windows XP Home Edition setup
• Second part of XP Home Edition setup+Start Windows for first time

Second part of XP Home Edition setup+Start Windows for first time is already selected. Press Enter or wait 10 seconds to Start Windows for the first time. The Windows installation process will be finished and finally the Windows Desktop will appear.

DO NOT disconnect the USB Flash Drive too early!

At next startup you can boot into Windows from your hard disk.

Notes:

After successsful installation, the following boot menu will always be displayed during startup:

Please select the operating system to start:

• Microsoft Windows XP Home Edition
• USB Repair NOT to Start Microsoft Windows XP Home Edition

If you don’t plan to use the repair option and want to boot directly into windows, you have to do the following:
Open the file boot.ini in the root directory of drive C:\ with Notepad:

[Boot Loader]timeout=30
Default=multi(0)disk(0)rdisk(0)partition(1)WINDOWS
[Operating Systems]
multi(0)disk(0)rdisk(0)partition(1)WINDOWS=”Microsoft Windows XP Home Edition” /noexecute=optin /fastdetect
multi(0)disk(0)rdisk(1)partition(1)WINDOWS=”USB Repair NOT to Start Microsoft Windows XP Home Edition” /noexecute=optin /fastdetect

Delete the following line:

multi(0)disk(0)rdisk(1)partition(1)WINDOWS=”USB Repair NOT to Start Microsoft Windows XP Home Edition” /noexecute=optin /fastdetect

DO NOT delete the wrong line!
Your computer may not boot the next time!

Save changes to the file.
At next startup the boot menu will not be displayed.
If you want to keep the repair option, you can reduce the time to display the operating system options from 30 to 5 seconds:

[Boot Loader]
timeout=5

Save changes to the file.
At next startup the boot menu will be displayed only 5 seconds.

A Guide to the “IRQL Not Less Or Equal” Blue Screen of Death Error

IRQL_NOT_LESS_OR_EQUAL

IRQL_NOT_LESS_OR_EQUAL means one of two things: driver issues, or a bad Windows Service caused by a backup utility or antivirus scanner. This is a similar, but different error to the previous one we discussed, KMODE_EXCEPTION_NOT_HANDLED, so much of this guide will be familiar.

Driver Issues

Sometimes the additional information on your Blue Screen will list the specific driver causing the problem, but this isn’t always the case.
If it does list the driver, you’re going to want to disable it. If it doesn’t list it, read below.
Disabling a specific driver is tricky, but here’s how you do it.

Disable the Problem Driver

To track down the specific problem driver, you’ll need to run Driver Verifier, an application included with Windows.

1. Click Start
2. Type verifier in the box and press Enter
3. Select Create Standard Settings, then click Next, then select Automatically Select all Drivers Installed on this Computer
4. Click Next, then Finish
5. Reboot your computer, and you will see the list of drivers to be verified during startup. If there is a faulty driver you will get a BSOD with its respective error message
You can then identify the driver listed and uninstall it when you log back into Windows

6. When you have determined the faulty driver, log back into Windows and you can uninstall the driver via the Device Manager (see below)
Next, you will want to disable the Driver Verification so it doesn’t always check on startup.

7. Click Start and type verifier /reset

To disable a driver once you’ve identified it:

1. Restart your PC in Safe Mode in order to avoid any further Blue Screens of Death while you’re trying to take care of the problem
2. Click Start
3. Click Control Panel
4. Click Device Manager
5. Click the arrow next to individual devices, right click on the device, and click Properties
6. click Details to see the driver name. If you see any devices with a yellow exclamation mark, you’re on the right track, but this will not necessarily be the case
7. Additionally, try doing a CTRL + F on the Windows desktop for the driver name to see what folder it’s in; this will provide a clue as to what device the driver belongs to
8. Once you find the offending driver, click Uninstall from that same Properties screen
9. Windows will attempt to reinstall the driver itself from information it provides from the Internet. This is called Plug and Play. Allow it to do so
10. Run Driver Reviver to update the new driver to the most recent version

Run Driver Reviver

Alternatively, run Driver Reviver first, and see if updating your drivers to the latest version takes care of the problem.

Faulty Windows Service

Sometimes, this error will occur when a backup utility or antivirus scanner makes changes to Windows that it doesn’t like. If you’ve installed and run such an app lately, you’re going to want to reboot in Safe Mode and uninstall it. If that doesn’t work, restore to a Restore Point that’s just before you installed said app, and use a different app instead. We’ve got recommendations for reputable backup utilities as well as antivirus scanners.

How to Move Mail to Different Folders in Gmail

1. Go to your Gmail settings. This button looks like a cog and is in the upper right-hand portion of the window.
   
   
   
2. 2
   Go to the Labels tab.
   
   
   
3. 3
   Scroll down to Labels and hit Create New Label.
   
   
   
4. 4
   Modify label info and hit Create. In addition to naming it, you can decide whether or not to “nest it under” (i.e. turn it into a subfolder of) a different label.
   
   
   
5. 5
   Look for the label/folder underneath the others. It should be at or near the bottom of the list of your other label/folder(s).
   
   
   

Automatically Move Mail to Labels

1. 1
   Go to Settings > Filters and hit Create New Filter. You will be using this filter to channel desired emails into your new label.
   
   
   
2. 2
   Define your label criteria. If you want to group emails from specific sender(s), add them to the From category; if you want to filter by content, modify the Has the Words category; if you want to modify several categories to get more specific results, fill them all out simultaneously. To run a test search to make sure your settings filter the desired emails, click the magnifying glass at the bottom of the window.
   
   
   
3. 3
   When you’re satisfied, click Create Filter with this Search.
   
   
   
4. 4
   In the new window that appears, click Choose Label.
   
   
   
5. 5
   Choose the desired label from those listed.
   
   
   
6. 6
   Decide whether or not to apply the label to existing messages. If you want to label any emails you may already have that match your criteria, check Also Apply Filter to ___ Matching Conversations. If you only want the label to apply to incoming messages, leave this blank.
   
   
   
7. 7
   Click Create Filter. The desired emails should now be labeled / begin labeling.
   
   
   

Manually Move Mail to Labels

1. 1
   Find and select the desired emails.
   
   
   
2. 2
   Click Label and select the desired label. The label button looks like a small paper tag.
   
   
   

How to Remove and Delete Facebook Account and Profile Permanently

Facebook offers a convenient way to deactivate Facebook account. However, deactivation of Facebook does not completely and permanently the Facebook profile and accoucnt.

According to Facebook FAQ, deactivate Facebook account will render user’s profile and all information associated with it immediately inaccessible to other Facebook users. In other words, the account is effectively disappear from the Facebook service. However, the Facebook account is not been purged from Facebook’s servers. Instead, the profile information (friends, photos, interests, etc.) is saved, so that the account can be recovered and reactivated in future with the information intact if the user decides to do so, or regret on the deactivation decision.
Permanently delete the Facebook account will completely remove and purge all personally identifiable information associated with the Facebook account from Facebook database. This includes information like name, email address, mailing address, and IM screen name. However, do note that copies of some material (photos, notes, etc.) may remain in Facebook servers for technical reasons, but this material is disassociated from any personal identifiers and completely inaccessible to other users.
Facebook users who want to get rid of Facebook once and for what, and do not think that he or she will use Facebook again, Facebook provides a way to delete the account. Once Facebook account is deleted, it’s impossible to reactivate the account or retrieve any of the content or information previously associated in the account. There is no option for recovery once Facebook account is deleted.
To delete a Facebook account, log in to the Facebook account, and then submit the “Delete My Account” at https://ssl.facebook.com/help/contact.php?show_form=delete_account.

Click on Submit button. Enter the password to confirm it’s your account, and the captcha security spam check. Then click on Okay button. An email will be sent to indicate that the Facebook account will be deleted in 14 days.





During the 14 days account deletion grace period, do not login or sign in to Facebook account, nor perform any action utilizing Facebook, such as Share on Facebook on Like in Facebook, or login and sign up to other websites by using Facebook Connect (Facebook user name and password credentials). Any interaction and usage of the Facebook account during the period will prevent the account from being deleted.
Alternative Method to Delete Facebook Account
If the above official method to delete the Facebook account fails, it’s also possible to email Facebook to request them to delete your Facebook account directly. The email address is:
privacy@facebook.com

Within a few days (allows up to a week), an email response should be sent by Facebook to confirm that the account has been permanently deleted.

If there is no response from Facebook, and you can still access your Facebook account or given an option to reactivate the account, try email Facebook again, with the following three email addresses:
privacy@facebook.com
support@facebook.com
info@facebook.com

The Facebook account is permanently deleted when user cannot login to the account anymore, and there is not message which offers user a chance to reactivate the Facebook account.

Convert and Save PowerPoint 2010 Presentation or Slideshow in Windows Media Video (WMV) Without Third-Party App

Prior to the release of Microsoft Office PowerPoint 2010, users of older versions of PowerPoint such as PowerPoint 2007, PowerPoint 2003, PowerPoint XP, PowerPoint 2000 and PowerPoint 97 will need the help of third-party software programs to save and convert PowerPoint presentations as video or to CD and DVD. However, for PowerPoint users who want to convert or save the presentation in a video format, PowerPoint 2010 has made it easy.

PowerPoint has been widely used to prepare presentations, animations, slide shows and multimedia for work, commercial, training education, government, leisure and many other purposes. On many occasions, PowerPoint users will want to save the presentations created as a video file, as the presentations in proprietary PowerPoint file format such as PPT, PPTX, PPS and etc requires a computer with PowerPoint program or PowerPoint Viewer (download PowerPoint Viewer 2010 and PowerPoint Viewer 2007) installed.
By converting the PowerPoint presentation to video, users can upload and share the presentation video or slideshow easily on Youtube, Facebook, MySpace and other video sharing sites. Video can also be burned to CD, DVD or Blu-Ray disc for distribution or playback on TV. And video files can be directly played by increasingly popular HD media player for playback on LCD TV.
In PowerPoint 2010, users no longer need any third party software application to save presentations in video format anymore. PowerPoint 2010 includes built-in support to save presentation as Windows Media Video (wmv) video format. Windows Media Video encoding is widely supported, thanks to built-in codec support by Windows operating system.
Here’s how to save a presentation as WMV video in PowerPoint 2010:

1. In PowerPoint 2010, click on File tab, then click on Save As. 
2. 
3. In the “Save As” dialog box, select Windows Media Video in “Save as type” drop down list.
   
   
   
   
4. Enter a file name for the video, and click on Save button.
5. A video creation progress bar will be displayed on PowerPoint’s status bar. Once process completed, the video can be played in Windows Media Player right away.
   

Remove or Reset Trend Micro OfficeScan Uninstall Password to Default

Trend Micro OfficeScan is an enterprise security solution with complete anti-virus, anti-spyware and anti-rootkit that been deployed on company’s desktops, laptops and file servers to protect and secure the perimeters of corporate network and systems against today’s complex, blended threats and Web-based attacks.

Usually, administrators will lock the corporate edition of Trend Micro Office Scan client program by assigning an uninstallation password, which must be entered correctly when computer user attempt to uninstall Trend Micro OfficeScan client from the PC.
So how to uninstall or remove Trend Micro Office Scan when the password to uninstall is unknown or lost? Here’s a simple hack to remove or reset the uninstallation password for TrendMicro OfficeScan, after which user can uninstall Trend Micro Office Scan by using the default password.

1. Search for Ofcscan.ini file. Normally the file is located in C:\Windows folder for Windows 95 and Windows 98, or C:\WINNT directory for Windows NT and Windows 2000. In newer operating system, the Ofcscan.ini can be saved in C:\Program Files\ folder.
2. Open the Ofcscan.ini file using Notepad for editing.
3. Search for the [INI_CLIENT_SECTION] section heading.
4. Locate the line starting with Uninstall_Pwd=. Comment the line (make it inactive by typing a # at the beginning of the line, i.e. #Uninstall_Pwd=…..
5. Insert a new line beneath the existing line as following: Uninstall_Pwd=70
   
6. Save the Ofcscan.ini file.
7. Try to uninstall Trend Microsoft OfficeScan again. When prompted to enter a password to continue to uninstall, enter 1 as the password.

Alternatively, if above hack does not work, user can always manually uninstall Trend Micro OfficeScan client, bypassing and skipping all password requirement.