Showing posts with label Office tricks. Show all posts
Showing posts with label Office tricks. Show all posts

Top 10 Printer Tips and Tricks

Utilitarian workhorses of the computing industry, our printers are ignored until they run out of ink. Then we replace the tanks as quickly (and as cheaply) as we can and don't think about the devices for another few months. And as with monitors, we replace them only when they fail completely. Six-year-old printer? No problem. Dot matrix? Still functioning! This collection of tips and tricks shows you how to keep nozzles clear, print sharper pictures, test out your document formatting easily, and more.


1. Prevent clogs with a humidifier 
An unpleasant fact of life for inkjets is that nozzles can and do clog. Anecdotal evidence gathered from e-mails to PCMag.com (and supplemented by similar complaints on the Web) suggests that they are more likely to clog if you live in an area with particularly low humidity. That's not a problem we run into in PCMag.com country, New York City, but cities built in the middle of the desert often boast humidities as low as 10 or 15 percent. If you live in an area with low humidity, and you're having a problem with clogging nozzles, you may be able to solve it by adding a humidifier to the room where you keep your printer. Not in a humid area but experiencing clogs nonetheless? Unfortunately, you'll probably need to replace the cartridge. After you do, think about printing a page or two every few days.

2. Fix smeary printouts 
If you use an inkjet printer and see smearing on a page, it's typically because something is sticking to the printhead. If your printer includes the nozzles in the cartridges—as most HP printers do, for example—and you see smearing immediately after changing a cartridge, remove the cartridge and check to make sure the protective tape over the nozzles is completely removed. If some of the tape is still attached, remove it, being careful not to touch the nozzle plate.

3. Print in the right order 
Most laser printers print pages so they come out face down. For a multipage document, this puts the pages in the right order when you turn over the stack. Most inkjets print pages face up, which will normally put the first page on the bottom of the stack, so you have to reorder the pages. A few inkjets default to reversing the print order, so the last page prints first and the first page prints last, and everything's in the right order. Many don't have that feature, however.

For those inkjets that don't have a reverse print feature in the driver, some programs offer printing in reverse order. In Word 2003, for example, you can choose Tools |Options, then the Print tab, and add a check to the Reverse Print Order check box. In Word 2007, you can choose the Microsoft Office Button, click Word Options, and pick the Advanced options in the pane on the left-hand side of the dialog box. Then scroll down to the print options, and check the Print Pages In Reverse Order box.

An alternative approach for Word is to tell the program to print the range in reverse order. To print a 24 page file in Word 2003, for example, instead of searching for the Reverse Print Order option, you can just choose File | Print, and, in the Pages text box, tell Word to print pages 24-1.

This alternative approach may also work for some programs that lack a reverse-print option but offer the option to print a range of pages. Don't try using both approaches at the same time, however, or use either with a driver that also reverses the order. Just as two negatives equal a positive, two commands to reverse order will cancel each other out.

4. Reduce bloatware 
Some printers (particularly all-in-ones) install a lot of software that you don't necessarily use and may not want. The possibilities range from a utility that automatically checks for driver updates to a graphics program that you don't need. To minimize unnecessary software, look for a Custom option when you install your next printer, rather than using the Typical or Recommended option, and then pick just the software you want to install—the minimum requirement being the driver itself. In some cases, you can download a minimal installation file from the manufacturer's Web site and skip the CD altogether.


5. Test out formatting 

It's often useful to create a text document in Word, to test a printing or formatting feature, for example. To create as much text as you need quickly, simply type =rand(p,s) in a paragraph by itself, with p indicating the number of paragraphs you want and s the number of sentences in each paragraph. Then hit Enter. Word 2003 and earlier will create the text using the sentence The quick brown fox jumps over the lazy dog. Word 2007 uses different text, but if you prefer the earlier version, use the command =rand.old(p,s). Word 2007 offers still another variation of dummy text: the command =lorem(p,s).


6. Check which is the default printer 

Some printer installation programs assume you want the printer you're installing to be the default, and set it as such without asking. Others leave it to you to set it as the default manually by going to the Printers and Faxes dialog box (or Printers dialog box, depending on your version of Windows), then right-clicking on the printer name and choosing Set as Default Printer. Given that there is no standard, it's a good idea after installing a printer to go to the Windows dialog box and check the settings, so you won't be surprised by what happens (or doesn't happen!) the first time you give a print command after installing a printer.


7. Maintain consistency with PostScript 

Typically today, you don't have to worry about printer languages, but there are exceptions. A case in point: The big advantage of PostScript has always been that line breaks, page breaks, placement of graphics, and the like don't change when you print on a different PostScript printer—something you can't guarantee with other printer languages. That's worth knowing about if you need to create a document to print on more than one printer. If you care about format consistency, stay with PostScript printers if possible. If it isn't possible, convert the document to a PDF file, and print from Acrobat.


8. Print monochrome documents as black-only 

Few printer issues are as annoying as trying to print a monochrome document in a hurry and getting an error message that the printer won't print because it's out of some other ink color. Before you take a sledgehammer to the printer, take a careful look through the driver. Many—unfortunately, not all—printer drivers include an option to print using black only, or equivalent options to override the refusal to print. If your printer's driver doesn't offer a black-only option, you can always make sure that you have a supply of ink cartridges on hand.


9. Improve quality with the right paper setting

One of the most common reasons for complaints about inkjet output quality is that the driver is set for the wrong type of paper. Different papers require different amounts of ink and different proportions of ink colors to produce the correct final colors. Setting the paper type tells the driver which color tables to use. Some inkjets are supposed to recognize the paper type automatically, but the feature doesn't always work. So if you're not getting the results you expect, don't give up on the printer until you've made sure you're setting the driver manually for the paper you're actually using.


10. And speaking of the right paper

The paper you print on can make a real difference in how your output looks. All other things being equal, whiter, brighter paper makes text and line graphics crisper and colors more vibrant, because the human visual system sees colors differently depending on the surrounding color—in this case the paper color. For inkjets, the paper also determines how much of the ink gets absorbed into the paper and whether it bleeds into the surrounding area or stays in the spot where the drop hits paper. So if you care about how your output looks, stay away from cheap copy paper, and invest some time and money experimenting with other choices.

Use the Notepad as your personal diary


There is a simple feature in Notepad that can make it work like a personal diary for you.Here is how to go about it:

1.Firstly open a blank Notepad file.
2. Now write .LOG as the first line in the file, then press enter. Now save the file and close it.
3.Open the notepad file now and you will find that the current date and time has been
appended (put) at the end and the cursor is in the next line.
4. Type your notes and then save and close the file.
5. Each time you open the file, Notepad repeats the process,that is it appends the date and time
to the end of the file and places the cursor below it.

Symbols for notepad

Alt+15= ¤ Alt+79= O Alt+129= ü Alt+179= ¦ Alt+229= Õ Alt+20= ¶ Alt+80= P Alt+130= é Alt+180= ¦ Alt+230= µ Alt+21= § Alt+81= Q Alt+131= â Alt+181= Á Alt+231= þ Alt+32=espaço Alt+82= R Alt+132= ä Alt+182= Â Alt+232= Þ Alt+33= ! Alt+83= S Alt+133= à Alt+183= À Alt+233= Ú Alt+34=" Alt+84= T Alt+134= å Alt+184= © Alt+234= Û Alt+35= # Alt+85= U Alt+135= ç Alt+185= ¦ Alt+235= Ù Alt+36= $ Alt+86= V Alt+136= ê Alt+186= ¦ Alt+236= ý Alt+37= % Alt+87= W Alt+137= ë Alt+187= + Alt+237= Ý Alt+38= & Alt+88= X Alt+138= è Alt+188= + Alt+238= ¯ Alt+39= ' Alt+89= Y Alt+139= ï Alt+189= ¢ Alt+239= ´ Alt+40= ( Alt+90= Z Alt+140= î Alt+190= ¥ Alt+240= ­ Alt+41= ) Alt+91= [ Alt+141= ì Alt+191= + Alt+241= ± Alt+42= * Alt+92= Alt+142= Ä Alt+192= + Alt+242= _ Alt+43= + Alt+93= ] Alt+143= Å Alt+193= - Alt+243= ¾ Alt+44= , Alt+94= ^ Alt+144= É Alt+194= - Alt+244= ¶ Alt+45= - Alt+95= _ Alt+145= æ Alt+195= + Alt+245= § Alt+46= . Alt+96= ` Alt+146= Æ Alt+196= - Alt+246= ÷ Alt+47= / Alt+97= a Alt+147= ô Alt+197= + Alt+247= ¸ Alt+48= 0 Alt+98= b Alt+148= ö Alt+198= ã Alt+248= ° Alt+49= 1 Alt+99= c Alt+149= ò Alt+199= Ã Alt+249= ¨ Alt+50= 2 Alt+100= d Alt+150= û Alt+200= + Alt+250= · Alt+51= 3 Alt+101= e Alt+151= ù Alt+201= + Alt+251= ¹ Alt+52= 4 Alt+102= f Alt+152= ÿ Alt+202= - Alt+252= ³ Alt+53= 5 Alt+103= g Alt+153= Ö Alt+203= - Alt+253= ² Alt+54= 6 Alt+104= h Alt+154= Ü Alt+204= ¦ Alt+254= _ Alt+55= 7 Alt+105= i Alt+155= ø Alt+205= - Alt+56= 8 Alt+106= j Alt+156= £ Alt+206= + Alt+57= 9 Alt+107= k Alt+157= Ø Alt+207= ¤ Alt+58= : Alt+108= l Alt+158= × Alt+208= ð Alt+59= ; Alt+109= m Alt+159= ƒ Alt+209= Ð Alt+60= < 110=" n" 160=" á" 210=" +" 61=" =" 111=" o" 161=" í" 211=" Ë" 62=" "> Alt+112= p Alt+162= ó Alt+212= È Alt+63= ? Alt+113= q Alt+163= ú Alt+213= i Alt+64= @ Alt+114= r Alt+164= ñ Alt+214= Í Alt+65= A Alt+115= s Alt+165= Ñ Alt+215= Î Alt+66= B Alt+116= t Alt+166= ª Alt+216= Ï Alt+67= C Alt+117= u Alt+167= º
♀& #9792 widout spaces♂& #9794 widout spaces◘& #9688 widout spaces•& #8266 widout spaces♠& #9824 widout spaces♣& #9827 widout spaces Δ & #916 widout spacesΘ & #920 widout spacesΞ & #926 widout spacesΠ & #928 widout spacesΣ & #931 widout spacesΦ& #934 widout spacesΨ& #936 widout spacesΩ& #937 widout spacesα& #945 widout spacesβ& #946 widout spacesγ& #947 widout spacesδ& #948 widout spacesε& #949 widout spacesζ& #950 widout spacesη& #951 widout spacesθ& #952 widout spacesι& #953 widout spacesκ& #954 widout spacesλ& #955 widout spacesμ& #956 widout spacesξ& #958 widout spacesς
& #962 widout spacesσ & #963 widout spacesτ & #964 widout spacesψ
& #968 widout spacesω & #969 widout spacesθ & #977 widout spaces & #9829 ♥
alt+987=█ alt+6=♠

PDF Trick!!!

Hey peeps now u can listen to wats there in a pdf document instead of reading the whole document....
Try out the following key
combinations for Acrobat 6.0 & 7.0:
- ctrl+ shift + b ---> To hear the whole document
ctrl + shift + v ---> To hear only the page
ctrl + shift + c ---> To resume
ctrl + shift + e ---> To stop

Hidden unknown fact in MICROSOFT WORD

Bill Gates still doesn't know why it happens:
Try out yourself...
Open Microsoft Word and type
=rand(200,99)
and then HIT ENTER....see what happens.

Useful Microsoft Office Cheats & Shortcuts


Learning how to use Microsoft Office is fun, especially if you become familiar with the shortcuts of its programs. Here is a comprehensive list of Microsoft Office shortcuts that you may use as a cheat sheet for your projects. Enjoy learning!

Microsoft Excel

The following functions apply to version 97/98/2000 of Excel:
  • Save As allows you to save files into older versions
  • Format Cell provides you the option to format your text, including Text Wrapping under the Alignment Tab
  • Paste Special lets you paste the formatting of the cell you copied but not the data
  • Double-clicking the edge of any row or column allows you resize it so your data will fit
  • Double-clicking a cell gets you in cell edit mode so you can make changes in your data
  • Insert Row/Column provides you the option to insert a new row/column above or to the left of an existing row/column
  • Freeze Panes lets you freeze everything above and to the left of the cell you selected which is very useful when you’re working on a large spreadsheet
Now here are some shortcuts for Microsoft Excel that can be beneficial to you; some of which also work in Microsoft Word:
Documents
  • F1 (Help)
  • Ctrl+O (Open)
  • Ctrl+N (New)
  • Ctrl+S (Save)
  • Ctrl+P (Print)
  • Ctrl+F (Search)
  • Ctrl+H (Replace)
  • Ctrl+Home (First Word or Cell)
  • Ctrl+End (Last Word or Cell)
  • F7 (Spellcheck)
Selection
  • Ctrl+X (Cut)
  • Ctrl+C (Copy )
  • Ctrl+V (Paste)
  • Ctrl+A (All)
  • Ctrl+Space (Select Column)
  • Alt+= (Sum)
Editing and Formatting
  • F2 (Edit Cell)
  • Ctrl+B (Bold)
  • Ctrl+I (Italic)
  • Ctrl+U (Underline)
  • F4 (Repeat Action)
  • Ctrl+1 (Format Cell)
  • Ctrl+Shift+F (Font)
Useful Functions
  • today() (Today’s date)
  • now() (Date and time)
  • sum() (Total of values)
  • average() (Average of values)
  • max() (Highest value)
  • min() (Lowest value)
  • sqrt() (Square root)

Microsoft Word

Documents
  • F12 (Save As)
  • Ctrl+F2 (Print Preview)
  • Ctrl+P (Print)
  • F7 (Spelling and grammar)
  • Ctrl+H (Replace)
  • Ctrl+G (Go to)
Text Style
  • Ctrl+Shift+P (Font size)
  • Ctrl+Shift+D (Double underline)
  • Ctrl+Shift+W (Word underline)
  • Shift+F3 (Change case)
  • Ctrl+K (Make web hyperlink)
Formatting
  • Ctrl+L (Left alignment)
  • Ctrl+E (Center alignment)
  • Ctrl+R (Right alignment)
  • Ctrl+J (Justified)
  • Ctrl+M (Indent)
Tables
  • Tab (Go to next cell)
  • Shift+Tab (Go to previous cell)
  • ALT+PageUp (Go to beginning of column
  • ALT+PageDown (Go to end of column
  • ALT+End (Go to end of row)
Miscellaneous
  • ALT+Ctrl+C (Copyright symbol)
  • ALT+Shift+D (Date field)
  • Shift+7 (Thesaurus)
  • ALT+Ctrl+F (Go to footnotes)
To print a list of all Microsoft Word commands and functions, perform the following steps.
  • Select Tools|Macro|Macros from the menu bar.
  • From the Macros In drop-down menu, select Word Commands.
  • Select Listcommands from the macro listing.
  • Click the Run button.
  • Choose Current Menu & Keyboard Settings from the popup window, and click OK.
  • Microsoft Word will provide you a new document that lists all the keystrokes for the program. Print it and start experiencing the power of Word.

Microsoft Outlook

  • F9 (Check for mail)
  • Alt+S (Save, Close, and Send)
  • Ctrl+R (Reply)
  • ALT+L (Reply All)
  • Ctrl+Shift+B (Address book)
  • ALT+Tab (Switch Between Applications)
These are just a few of the shortcuts and commands available for Microsoft Office. This is definitely not the complete list, but it should suffice for your regular projects. Spending a little time to learn these tricks will help you become a more proficient Microsoft Office user – the Office expert in your company!



Office tips and tricks

We probably use office programs - word processors, spreadsheets, email and presentation applications - more than any other kind of software on our computers. Of this kind of software, Microsoft's Office suite is the most popular.
It can, however, be hard to get to grips with all the time-saving features; all those menus, toolbars and buttons can seem overwhelming at times, particularly if you are just starting out.
Once you delve a little deeper and discover Office's hidden shortcuts and tricks, however, you can make your software work a lot harder for you and make your life easier in the process.
Use our handy guide to the 100 most useful hints, tips and shortcuts in Word, PowerPoint, Excel and Outlook and you will know just how to get the most out of your Office applications.

WORD
1. Date
To stop Word from adding today's date to any year you type, changing, say, 'Letter 2004' to 'Letter 2004-08-22', go to the Insert menu, click on AutoCorrect and select AutoText in the next menu. Untick the box marked 'Show Autocomplete Suggestions'. If you want to use an AutoText shortcut in future, type the abbreviation and press F3.

2. Add places
Add a folder to the Places Bar in Word 2002's Open and Save boxes to help you find files quickly. Find the folder you require in Windows Explorer, highlight it and then click on the Tools menu. Now click on the option marked 'Add to My Places'. If you are a Word 2000 user, you can download a Microsoft add-on to customise the Places Bar

3. Turn off fast save
Fast saves aren't much faster than normal saves and instead of properly saving your document, Word just appends anything you have added to the text to the end of the file. Nothing is ever deleted from the document file, so it can end up being huge. It's best to turn off fast saves by going to the Tools menu, clicking on Options, then on the Save tab and removing the tick from the 'Allow fast saves' checkbox.

4. No mouse styles
If you often write the same style of documents in Word, you may be aware of the Styles option, which can reduce the time you spend formatting a document. You can assign a keyboard shortcut to a style so that you don't have to use the mouse to find it by going to the Tools menu, then Customize, then pressing Keyboard and selecting Styles from the list on the left.

5. Follow style
If your styles naturally follow one another, say a particular text style always follows a particular headline style, you can cut down further on the time required to select them by going to the Format menu, and selecting Style. Choose the relevant style and click on Modify, then choose another from the box marked 'Style for following paragraph'.

6. Repeat find
To find a piece of text, press F3, enter the text you're looking for in the text box and press Enter. You don't need to keep the box open to find other instances of this text, however. Click on Cancel, and notice that the double arrows at the bottom of the right-hand side scroll bars have turned blue. Clicking on one of them will take you to the next place this text occurs, either forwards or backwards through the document, depending on which button you click.

7. AutoCorrect
AutoCorrect allows you to change text automatically as you type it, which can be handy for correcting frequently mistyped words. Click on the Tools menu, then on AutoCorrect and enter a piece of text in the left-hand column. Whenever you type it, it will be replaced by the text in the same row in the right-hand column of the dialogue box.

8. Select lots of text
It can be very difficult to select more than a few paragraphs of text at once using only the mouse, particularly if you have a fast PC, as the text will shoot past before you notice. But you can select large amounts of text easily by clicking where you want your selection to start, then navigating to the end of the intended selection using the mouse wheel or scroll bars. Then just hold down Shift and click again to select the block of text.

9. Saving grace
If you are working on several documents at once, you can save them all without closing Word in the process. Just hold down Shift and click on the File menu. You will see a new option Save All. There is also an option to Close All if you want to do so without closing Word.

10. Simple formatting
If you're going to create a number of documents that are similar in appearance, it's best to use styles to format text rather than applying the formatting yourself. This ensures that you can change it easily throughout the documents, if you need to. You can, however, use the Format Painter to copy the formats from one paragraph and apply it to another. Select the Format Painter button from the Word toolbar and click on the portion of text you want to copy a format from. Now drag the pointer over the selection you want to apply the formatting to.

11. Scraps
You can create 'scraps' in Word, which are small blocks of text from a document. Highlight some text in an open document and drag it to the Desktop, and you will see it appear as a document scrap. You can arrange and rename your scraps on the Desktop, and simply drop them back into Word documents as you need them. The scraps can be pasted into most other applications too.

12. Snappy corrections
Instead of using the spell checker once you've finished writing a document, you can correct words as you type. Right-click on a red-underlined word, and Word will show you a menu of replacements it thinks are suitable. This also works for green-underlined phrases that Word thinks are not grammatically correct. Right-clicking them will again open a menu with suggested replacements.

Word shortcut keys
Most of us spend more time using Microsoft Word than any other Office application, so make use of our handy guide to Word's shortcut keys and cut down the time you spend hunting for what you want among the many menus and toolbars.

Ctrl+B Make selected text bold
Ctrl+U Underline selected text
Ctrl+I Make selected text italic
Ctrl+L Align selection or paragraph to the left of the screen
Ctrl+E Align selection or paragraph to the centre of the screen
Ctrl+M Indent paragraph or selection
Ctrl+1 Single-space all the lines in selection
Ctrl+2 Double-space all the lines in selection
Ctrl+5 1.5-space all the lines in selection
Ctrl+Space Toggle AutoCorrect
Ctrl+Del Delete the word to the right of the cursor
Ctrl+Backspace Delete the word to the left of the cursor
Ctrl+Shift+8 Toggle hidden characters that mark spaces, carriage returns, and so on
F7 Run a spelling and grammar check
Shift+F7 Use the Thesaurus

EXCEL
13. Use Smart Tags in XP
Office XP features Smart Tags, which are like intelligent links to websites or locations on your PC's hard disk. Excel will recognise certain words and show Smart Tag action buttons next to them. Go to the AutoCorrect options part of the Tools menu and select Smart Tags to see which words it will recognise. You can download and install new Smart Tags from the Microsoft Office website. You will find tags there for both Excel and Word.

14. Spot corrections and errors
If you share Excel documents with others, it can be useful to see any changes they have made. Excel 2000 used red triangular indicators to highlight cells in which there were comments. In Excel 2002, there are purple indicators for Smart Tags and green ones for possible errors in formulas. Options can be found in the Tools menu, under the Error Checking tab of Options.

15. Open older macros
You will probably not be able to open old macros (from Excel 97 or 2000 workbooks) in Excel 2002 as the program will throw up a security warning notice. If you need to use old macros, go to the Tools menu and select Options, Security, then Macro Security and make sure Low is selected. Under Trusted Sources, place a tick in the Trust add-ins and Trust Visual Basic boxes. You will then need to restart Windows before you can run your old macros.

16. View important cells
Using the Watch window you can keep an eye on important cells in a spreadsheet. Click on a cell containing data and go to the Tools menu, choose Formula Auditing and then Show Watch Window. Click on Add Watch and it will display values and formulas for any cell of any open workbook.

17. Use labels in cells
You can make Excel work with labels you have given to cells instead of having to use the cell position ('Profit' instead of 'A6', for example). Go to Options in the Tools menu, and click on the Calculation tab, then tick the 'Accept labels in formulas' box.

18. Create formulas
Create a formula by clicking on the Paste Function tool (which is marked 'fx') on the standard toolbar. If you select a function from the list, its description will appear in the dialogue box, and the Help button will explain more about the formula. Alternatively, clicking on the equals sign in the formula bar will display a list of recently used functions.

19. Links
If you are seeing error messages about broken or invalid links to other workbooks or other applications, go to the Options part of the Tools menu and choose the Workbook Options tab. Make sure the box marked 'Update Remote References' is ticked. If you tick the box marked 'Save External Link Values', you won't have to worry about maintaining links but your file may end up significantly larger.

20. Create subtotals
It's easy to create sums of columns using the AutoSum tool but what about subtotals? Creating these needn't be hard either. Just use the function =SUBTOTAL (9,B2:B10). The 9 is a function number, representing SUM, and you should replace the cell references with the ones from your own worksheet. You could place it in cell B11 and then repeat it with figures below, say =SUBTOTAL (9,B12:B20), in cell B21. If you then used the AutoSum tool in cell B22 it would just display the sum of the subtotals, from cells B11 and B21.

21. Delete vs clear
There two ways to remove information from cells: Delete and Clear. Clicking on a cell and selecting Delete (or pressing Del or Backspace) will remove the cell's value or formula, but any formatting and comments will remain in place. If you want to return the cell to its original state, with no formatting, choose Clear instead.

22. Informative printouts
Many of us have spreadsheets that spread over more than a page. If you want your column titles to print on every page, go to the File menu, click on Page Setup and go to the Sheet tab. Click on the red arrow in the box marked 'Rows to repeat at top' and select the rows that contain your column titles, then click on OK.

23. Delete comments
You can delete all the comments from your worksheet at once, for instance if you have finished the sheet and want to distribute it without annotations. Press Control, Shift and O at the same time, and this will select all the cells in the worksheet that contain comments. Right-click on one of them and select Delete Comment, then click anywhere on the sheet and all the comments will have vanished.

24. Keep track of online orders
When you order online, it can be hard to keep a record of all your orders. You can, however, transfer the table from the confirmation email the retailer sends you into an Excel workbook. Open the email and click at the start of the table, then hold down Shift and click at the end of the table. Right-click on it and choose Copy, then open a blank Excel worksheet. Right-click on a cell and choose Paste. You may have to correct the formatting for it to look better.

25. Figuring out formulas
If you have a formula that's puzzling you because you can't figure out how it was derived, click on the cell that contains it, and choose the Auditing option in the Tools menu, and select Trace Precedents. You will see blue dots in the relevant cells, with arrows pointing towards the formula. When you have finished, choose Remove All Arrows.

26. Import finance data
You can import data from most online banks and finance programs into Excel, but it's often not quite as simple as just opening the document in Excel. It will usually be in Comma Separated Value (.csv) format. In Excel, click on the File menu and choose Open, then choose 'Text Files (*.txt, *.prn, *.csv)' from the 'Files of type' box, and select the CSV file you obtained from the bank website. Once it has opened, just adjust the column widths so they look right.

27. Show zeros the door
You can remove zeros that you don't need from your cells by going to Tools, Options and then View, and removing the tick from the Zero values box. If you want zeros to appear in certain cells, give those cells the custom format '0;-0;;@'. To enter a custom format, go to Format and Cells, and choose the Number tab, then select Custom and enter the format. For dashes to appear instead of zeros, use the custom format '0;-0;?-?;@'.

Excel shortcut keys
Don't get bogged down in Excel's options and commands. Use this guide to its keyboard shortcuts to fly around the keyboard and get your work done without having to take your hands away to move the mouse all the time.

Ctrl+- Delete the current cell or selection
Ctrl+Shift++ Insert cell or selection
Ctrl+; Insert current date at the selected cell
Ctrl+Shift+; Insert current time at the selected cell
Ctrl+K Insert a hyperlink or web link
Ctrl+Tab Switch to the next worksheet in the workbook
Shift+F3 Open the formula window
F11 Create a chart
Ctrl+Space Select all of the current column
Shift+Space Select all of the current row
Ctrl+Shift+1 Format the current cell with commas
Ctrl+Shift+4 Format the current cell as currency
Ctrl+Shift+5 Format the current cell as a percentage
Ctrl+Arrow key Move to the next used cell in the direction of the arrow key
Ctrl+F Open the search box

How To Uninstall GrooveMonitor.exe

GrooveMonitor is a service utility that tracks groove behavour and creates reports for error reporting to MS (what else does it report?). It loads on startup. It gets installed when you install Office 2007. However it doesn’t get uninstalled when you uninstall Office 2007. GrooveMonitor starts upon Windows startup (via registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run).

To remove GrooveMonitor from your machine you have to go to Control Panel and then select Add/Remove programs. GrooveMonitor is one of the displayed applications. Uninstall it from there. That should do it for any normal windows program. Not surprisingly Microsoft himself often violates this basic principle (which surprisingly would give you more control over their crappy [pardon my French] software), and GrooveMonitor will still load on startup.

You can however use msconfig to prevent it from coming up on Windows startup.
1. Go to Start menu and click Run
2. Type msconfig and press Enter.
3. Go to Startup tab and then uncheck any reference to “groovemonitor”
4. Reboot

Note: Some malware may also camouflage themselves as GrooveMonitor.exe, particularly if they are located in c:\windows or c:\windows\system32 folder.

GrooveMonitor is currently owned by Microsoft Corporation.

Crack Office 2007 trail

Follow these steps to Convert Trail to Full Microsoft Office 2007

start -> run .. type regedit ->HKEY_LOCAL_MACHINE -> software -> microsoft -> office -> 12.0 ->

registration -> (clik on the first number series) -> now select (DigitalProductID,LicenseType,TrialType)

and press ‘del’ key to delete them and then exit registry….

now open C:\Program Files\Common Files\Microsoft Shared\Office12\Office Setup Controller\Proof.en …

now open the Proof file(XML Document) in it with NOTEPAD ….

now under the last line u wil find

….


now replace “


” with “neverinstalled” …(including the inverted commas

 
too)….

pls be careful while editing them…

OR

==> Just use this Key

vv6dk-v8pb2-rhbyv-m6y6w-xjk38

How to open office 2007, 2010 file in office 2003

Today tip will help you to resolve the compatibility issues between the Office 2003 and Office 2007. Because all programs in office 2003 used the old file extensions for its different programs. For example Word 2003 saved files with extension .doc, Excel 2003 with .xls and PowerPoint with .ppt. but on the other office 2007 used the new file extensions for its different programs. For example Word 2007 saved files with extension .docx, Excel 2007 with .xlsx and PowerPoint with .pptx.

Now the problem is that when you will try to open office 2007 files into office 2003 and you will not open the file due to compatibility issues between both office versions. Microsoft provides a free compatibility pack to convert office 2007 documents to the office 2003 format. There are many third party free converter are available but here we are using Microsoft office compatibility pack.

Follow the given steps to download free Microsoft compatibility pack and install it. To use this feature, you will need to be logged into your computer with administrative rights.

Visit the following link to download the Microsoft compatibility pack: Link

 
Worlds best tips and tricks website