Wednesday, December 2, 2009
Printing Parts of a File - Excel 2003/2007
If you have to print specific parts of a file over and over again, it can be quite time consuming, especially if you have to keep selecting the area before firing a print command. If you have a single such printable area, you can set it as a 'Print Area'. If you have multiple print ranges you can store each of them as custom views. Here's how,
- Select the range and set its print preferences.
- Go to the 'View | Custom Views…'menu command.
- Click the 'Add' button on the 'Custom Views' dialog box.
- Enter a view name for future use.
- Check the 'Print Settings' option appearing under the 'Include in view' section of the dialog box.
- Click 'OK' to save the changes.To view the saved views,
- Go to 'View | Custom Views…'.
- Select the required view name and click the 'Show' button on the 'Custom Views' dialog box.
To create views in MS Excel 2007 follow these steps:
- Select the range and set its print preferences.
- Go to the 'View' tab and click the 'Custom Views' option under 'Workbook Views'.
- Click the 'Add' button on the 'Custom Views' dialog box.
- Enter a view name for future use.
- Check the 'Print Settings' option appearing under the 'Include in view' section of the dialog box.
- Click 'OK' to save the changes. To view the saved views,
- Go to the 'View' tab and click the 'Custom Views' option appearing under the 'Workbook Views' section.
- Select the required view name and click the 'Show' button on the 'Custom Views' dialog box.
You can add as many views as you wish to. You just need to make sure that the name of the view is relevant. To print, just display the view and fire the print
Thursday, November 19, 2009
Microsoft Office 2010 Beta Is Now Available
The first public beta of Microsoft Office 2010 is now available as a free download on microsoft.com/office.The beta is available in seven languages : English, Spanish, 
New features :
- Outlook Social Connector
- Deeper integration between Office client and Web Apps allowing users to save directly to Windows Live Sky Drive or SharePoint 2010
- Improved navigation, visual design and icon update
- New Office logo
- Increased performance and stability
The beta version of Office 2010 will expire in October 2010.You can either upgrade your current version of Microsoft Office to Office 2010 Beta or select the Customize option during installation and set your current version of Microsoft Office to coexist with Office 2010 Beta.
Download : 
Thursday, September 24, 2009
How to Adjust the Width of the Characters in Word 2003&2007
You can adjust the look of the characters horizontally in your document. Word enables you to adjust the appearance of your text without affecting the height. This can be done using the scaling feature available in Word. Scaling can be applied to any character in the selection.Here is what you need to do.
- Select the characters to be scaled.
- Click ‘Format | Font’.
- In the dialogue box click the ‘Character Spacing’ tab.
- Select the required scaling value to be applied to the characters from the drop-down list.
- Enter any value between 1% to 600% in the drop-down box, finally click ‘OK’.
If you scale the characters in your document on a regular basis, add a scaling tool to the Quick Access toolbar for ease.Here’s how you can do it:
- Click ‘Office’.
- Now click ‘Word Options’.
- From the left, click ‘Customize’
- Now, choose ‘All Commands’
- Select ‘Character Scaling’
- Click once to select the command.
- Click ‘Add’
- Click ‘OK’ to save the changes.
You can view the command on the Quick Access tool bar appearing on the top of the Word 2007 window.
Sunday, September 13, 2009
Friday, September 11, 2009
Office Tab – Tabbed Browsing in Ms-Office
Recently Tabbed Browsing is a common feature available in most of the browsers. Definitely it has improved the efficiency of browsers like Firefox and IE.Have you ever thought to have such a great feature in Microsoft Office as well?
Office Tab is a small add-on which will bring tabbed browsing to Microsoft office. With this you can open any number of tabs in the same Office application window and you can save a lot of space and also can easily switch back and forth between the document or even view them side by side within one window.
Office Tab works with office 2003 and office 2007 and is very light on resources.After installation ,from the settings panel you can enable or disable tabbed support in each application, move the tabs to the side or bottom, and change the appearance of the tabs with a number of styles to choose from,set tab layout to auto size,size to fit,fixed, set the width of the tab, set tab appearance and color and more .To add a new document tab just right-click the tab bar .
Download Office Tab and use it to make your work easier.This makes it easy to manage multiple things you are working on at the same time.
Thursday, August 6, 2009
How to Save Documents in Word 2003 & 2007
When you create a document in Word,you need to save it in a particular format. Usually these formats are Word or Word version specific. This can cause a problem especially if you open your Word documents on more than one machine with different versions of Word. However, there are a few formats that are supported by all versions of Word and most of the other word processors. Saving your documents in these formats can save you a lot of trouble while exporting your Word document to different versions. You can save your self a lot of trouble by setting a file format as Word's default saving format. This will ensure that all your files will be saved in this format, unless specified otherwise. To set a default format in Word 2003:
- Go to "Tools | Options". The"Options" dialog box will now appear.
- Click the "Save" tab.
- From the "Default format" section,select the format you want to set as the default format to save all your documents, from the "Save Word file as:" drop-down menu.
- Once done, click "OK".
NOTE: If you wish to use your document with older versions of Word,select "Disable features introduced after", and select the version of Word you wish to use the document with.
If you are using Word 2007, here are the steps to set your default document format.
- Click the "Office" button which appears on the top left corner of the window.
- Click the "Word Options" button. A dialog box pops up.
- Click "Save" from the left hand navigation bar.
- Select the format you want to set as default from the "Save files in this format" drop-down menu
Saturday, August 1, 2009
“The document caused a serious error the last time it was opened” How to Solve?
When you try to open a file that Microsoft Excel or Microsoft Word you may receive the following error message:”The document 'Filename' caused a serious error the last time it was opened. Would you like to continue opening it?”
The file stops responding completely and you have to end-task .Every time that you try to open the file this message will popup.
This issue occurs because the file appears on the list of disabled files for the Microsoft Office program .When Word or Excel opens a file that previously caused the program to crash two or more times, the program adds such files to this disabled Items list.Files in this list produce the above error message every time you try to open them.
To solve this issue, you have to remove the file from the list of disabled files. To do this, follow the steps.
Excel 2003 / Excel 2002 , Word 2003 / Word 2002
- On the Help menu, click About Microsoft Program, and then click Disabled Items.
- Select the file, and then click Enable.
Excel 2007 or Word 2007
- Click the Microsoft Office Button, click Program Name Options, click the Add-Ins tab.
- Click to select Disabled Items in the Manage list, and then click Go.
- Select the file, and then click Enable
However,removing a file from this list doesn’t mean the file will be problem-free.
Saturday, July 25, 2009
Using the Camera Tool in Excel 2007
Sometimes you need to collate important fragments of data lying in different parts of your Excel sheet.You can use collate the data and cell referencing , but it create a lot of
To enable the Camera Tool in Excel do the following steps:
- Right click the Office Button and enable “Show Quick Access Toolbar Below the Ribbon”
- Click the arrow appearing near the “Quick Access Toolbar”.
- In the drop-down menu, click the “More Commands…” option.
- The “Customize” option is selected by default in the left-side panel.
- In the “Choose commands from:”drop-down menu, select “Commands Not in the Ribbon”.
- Select the “Camera” option, and click the “Add>>” button.
- Click “OK” to close the “Excel Options” dialog box.
- The “Camera” icon appears on the “Quick Access Toolbar”.
- To take a snapshot of a cell range,select the cells.
NOTE: The camera tool does not work with charts.
- Click on the “Camera” icon.
- Go to the destination sheet and use the left-click of your mouse to draw the object.
- You can go to the source data by double-clicking on the image.
- You can create as multiple images in succession after selecting a cell range.
Sunday, May 17, 2009
How to Remove 'Groove Folder Synchronization‘ From Context Menu
Those who are using Office 2007 , will notice an extremely annoying option on the right click context menu of everything - “Groove Folder Synchronization”
You can remove the Groove Folder Synchronization from the context menu .For that Start>Run>Type “regedit” without the “quote” marks.Locate the following Registry keys and delete them to remove the Groove Folder Synchronization entries:
HKEY_CLASSES_ROOT\*\shellex\ContextMenuHandlers\XXX Groove GFS Context Menu Handler XXX
HKEY_CLASSES_ROOT\Directory\shellex\ContextMenuHandlers\XXX Groove GFS Context Menu Handler XXX
HKEY_CLASSES_ROOT\Directory\Background\shellex\ContextMenuHandlers\XXX Groove GFS Context Menu Handler XXX
HKEY_CLASSES_ROOT\Folder\shellex\ContextMenuHandlers\XXX Groove GFS Context Menu Handler XXX
HKEY_CLASSES_ROOT\AllFilesystemObjects\shellex\ContextMenuHandlers\XXX Groove GFS Context Menu Handler XXX
Saturday, May 16, 2009
Microsoft Office 2010 Technical Preview Registration
The Microsoft Office 2010 Technical Preview is a limited, invitation only program which will provide you with the opportunity to experience early, pre-release versions of Office 2010 which will include the following applications: Word 2010, Excel 2010, Outlook 2010, PowerPoint 2010, OneNote 2010, Access 2010, InfoPath 2010 and Publisher 2010.
By registering you are signing up to be considered for the Technical Preview Program, you will be waitlisted for consideration to be invited into the Technical Preview Program.
1. Office 2010 will be available in both 32-bit and 64-bit versions.
2. Office 2010 will run on Windows XP SP3, Windows Vista, and Windows 7.
3. You don't need to replace hardware that is capable of running 2007, it will support Office 2010.
Register :https://microsoft.crgevents.com/Office2010T/Register/Contact/Default.aspx
Wednesday, April 29, 2009
Microsoft Office 2007 SP2 Released
Microsoft released Office Service Pack 2, which improves the performance of Microsoft Outlook and adds support for Open Document Format in Word, Excel and PowerPoint
Features
- Support for Open Document Format (ODF)
- Support for XML Paper Specification (XPS),
- Support for Portable Document Format (PDF)
For Office Desktop Programs:
- Improved Outlook Calendaring Reliability
- Improved Outlook Performance
- Enabling Object Model support for Charts in PowerPoint and Word
- Improved cryptographic functionality by supporting all cryptographic algorithms offered by the operating system
- Improved functionality in Excel’s charting mechanism
- Ability to ungroup SmartArt graphics (and as a result, the ability to add animations to them in PowerPoint)
- Ability for Visio to export UML models to an XML file compliant with the XMI standard
- Tool that enables the uninstall of Office client Service Packs
For Servers:
- Performance and manageability improvements to variations in Enterprise Content Management (ECM) including STSADM commands for repairing links between source and target pages
- Improvements around processing status approvals from Office Project Web Access into Office Project Professional 2007
- Improvements to read-only content databases and index rebuild timer jobs in Windows SharePoint Services 3.0
More here http://support.microsoft.com/kb/953195 | Download | 290 MB|Free
Alternatively you can install this update from Microsoft Update
Tuesday, April 28, 2009
Windows Clipboard and Office Clipboard
The main difference is that the Windows Clipboard only holds one item at a time. When a new item is added, it replaces any existing one. Although the Windows Clipboard works when you copy, cut or paste, the Windows Clipboard Viewer isn’t readily accessible by default these days. However, if you open the clpbrd.exe file in the C:\WINDOWS\system32 folder, you can see anything that has been recently copied or cut.
The Office Clipboard can hold up to 24 items .The first item is only deleted when the 25th is added. The Office Clipboard allows you to choose whether items are collected or not when the Clipboard Task pane isn’t displayed. (They’re always collected when the pane is displayed.)Under the Home tab, below Format Painter, click the arrow to the right of ‘Clipboard’. At the bottom of the displayed Task pane is an Options button. Check or don’t check ‘Collect Without Showing Office Clipboard’.
Wednesday, March 18, 2009
Send Large Files from Outlook with Acrobat.com –Free with 5GB
E-mail has become one of the primary means of communicating media .E-mails often involve sending out large email attachments. Different restrictions on the size of attachments and spam filter policies means that not all attachments get through.For example YahooMail will not process emails with attachment over 10MB while Gmail can handle email attachments upto 20MB. Main thing , there is no guarantee of email being successfully delivered ,when email attachment size is large.
Here is a great news!.Acrobat.com now provides a Plugin for Microsoft Outlook 2007 for easily, securely and reliably sharing documents from your desktop e-mail client by making it as easy as adding an attachment.
Once you have installed the Acrobat.com add-in on your computer, you can send large files by uploading them to your Acrobat.com account, which provides users with 5GB of free space.Files that you've already uploaded can be easily added to a new message with the Insert Link button, which opens up a pane on the right-hand side listing your previously uploaded files—making this a great utility anytime you want to send a large file through email.
Features
Related Reading
Saturday, February 28, 2009
Video Tutorial: Working with Functions in Excel
Saturday, December 13, 2008
Modify the Gridline color in Excel 2007
If you are teaching young children Excel 2007, it is a good idea to make the learning as colorful as possible.This means that you can change the color of the gridlines from the usual boring black to something bold and bright! By default the gridlines are set to a very light shade of gray, which makes them invisible during printing. Read on to find out how you can make the change possible. It is very simple, just follows the steps listed below.
- Go to Excel, and click ‘Office’ .
- The ‘Excel Options’ dialog box is displayed.
- Click on ‘Advanced’ option.
- Scroll down to ‘Display options for this worksheet:’ section.
- Check on ‘Show Gridlines’.
- Locate the ‘Gridline Color’ dropdown color list
- Select a color, this changes the gridline color of the selected sheet
You also have an option to change the line color of parts of your sheet. A line however is different from a gridline in Excel. A gridline in Excel is a transparent table border, which is not visible on print. Whereas a line, is a solid border,visible on print.
Saturday, November 22, 2008
Send Your Files Directly From Microsoft Office With YouSendIt Add-in.
YouSendIt has released a Microsoft office plug-in that allows Microsoft office users to directly send large files . This new Microsoft office plug-in allows Microsoft office users to send 2GB large files with few clicks. YouSendIt Microsoft office plug-in works only with Microsoft office 2003 and 2007.
The installation is very simple, it adds a new menu item in “Send” menu if office applications. For sending a document go to send and select yousendit.
Features
- 25% faster uploads than the Web application
- Add additional files and folders of any kind to the same upload batch
- Resumable upload- handles network interruptions
- Includes all standard YouSendIt features like password protection, certified delivery, and file expiration control
- Convenient drag-and-drop and right-click sending options
Installation instructions
- Click on the Download now button to download the YouSendItOfficeFamilyAddinSetup1_1_0.exe file to a folder of your choice.
- Double click on YouSendItOfficeFamilyAddinSetup1_1_0.exe to begin the installation. This installation requires administrator privileges.
- Click on the Run button and follow the instructions to install two packages onto your system: (1) YouSendIt Express 1.7.3, (2) YouSendIt Add-in for Microsoft Office.
- The packages will be installed in
"C:\Program Files\YouSendIt\"
Quick tutorial
- Start Microsoft Office.
- You should see new menu items. For Microsoft Office 2003 on the file->Send To->Recipient using YouSendIt..., and toolbar. For Microsoft Office 2007 on the Menu->Send->Send by YouSendIt and Mailings tab on Microsoft Word ribbon bar.
- When you are ready with your files, select file->Send To->Recipient using YouSendIt...
- This will launch Express.
- Enter your YouSendIt account name and password and sign in.
- After you sign in enter the email address of the recipient, an optional message.
- Click on Send It button to send the file.
- A progress bar will be displayed showing the file upload progress
SysReq: Microsoft office 2003 or 2007|12MB|Freeware|You must be a registered user to download and use this plug-in.
Thursday, October 23, 2008
Office 2007 SP2 Due in Early 2009
Microsoft Office Service Pack team has announced that Office 2007 SP2 will be out in the near future,probably it will fall between February and April of 2009.Office Team several months ago announced that SP2 will have support for Open Document Format (ODF), XML Paper Specification (XPS), and Portable Document Format (PDF).
In addition to those file format additions, some other highlights that you’ll find in SP2 include:
For Office Desktop Programs:
· Improved Outlook Calendaring Reliability
· Improved Outlook Performance
· Enabling Object Model support for Charts in PowerPoint and Word
· Improved cryptographic functionality by supporting all cryptographic algorithms offered by the operating system
· Improved functionality in Excel’s charting mechanism
· Ability to ungroup SmartArt graphics (and as a result, the ability to add animations to them in PowerPoint)
· Ability for Visio to export UML models to an XML file compliant with the XMI standard
· Tool that enables the uninstall of Office client Service Packs
For Servers:
· Performance and manageability improvements to variations in Enterprise Content Management (ECM) including STSADM commands for repairing links between source and target pages
· Improvements around processing status approvals from Office Project Web Access into Office Project Professional 2007
· Improvements to read-only content databases and index rebuild timer jobs in Windows SharePoint Services 3.0
Thursday, September 25, 2008
Repair My Word
Sometimes you can not open Microsoft Word documents/ corrupted due some unknown reason .Common error messages are…
- "The document name or path is not valid. Try these suggestions. Check the file permissions for the document or drive. Use the File Open dialog box to locate the document."
- "Word cannot open the document."
- "Word cannot open the document: user does not have access privileges."
- When you attempt to open a Microsoft Word 97 document into Microsoft Word version 6.x or 7.x, the document contains garbage characters.
The corrupted MS word document (.doc) can’t be repair or fix by MS Word application itself.
Repair My Word will allow you to obtain access to the contents of corrupt word documents. It will repair Microsoft Word 6.0, Word 95, 97, 2000, XP, and 2003 for Windows.To use Repair My Word recover damaged word files is simple. All you need is open the corrupt Word file, preview the recoverable text in the preview window and save this text to a new error free Word file.
Repair MyWord Freeware1.50MB
Sunday, September 21, 2008
How to Open and Convert .docx Files
All the word documents created in Microsoft Word 2007 will be saved in DOCX format until and unless you specifically save them in DOC format using the SAVE AS format.There are few ways through which you can convert the DOCX files into DOC format, so that they can be opened using older version of Microsoft Office.
To open Microsoft Office Word 2007 .docx or .docm files with Microsoft Office Word 2003, Word 2002, or Word 2000, you need to install the Microsoft Office Compatibility Pack for 2007 Office Word, Excel and PowerPoint File Formats and any necessary Office updates.
If you have Office 2007 installed and want to save your files in .doc format, you can set this option in Word options > Save > Save files in this format, and choose Word 97-2003 Document from the drop-down menu.
And if you have Office 2007 installed, you can convert .docx files to .doc using Windows Explorer: Select the .docx file and click the mouse button to open the context menu. You'll see a Save as... option that will allow you to do it without opening Word.
Another online converter and this one is specifically for converting the files from DOCX to DOC. Visit DOCX2DOC.COM
You can simply go on ZamZar.com & then upload the DOCX file and then select the option of exporting it to DOC format.
Windows users could also download the Word Viewer application from Microsoft that opens .docx documents properly but cannot alter them.
