I have had many inquiries regarding this tip and it is such an easy thing to do!
To learn how to copy and paste row height in MS Excel, follow the steps below:
That’s all there is to it! You have now copied the format to your new row.
I know that a lot of you know many keyboard shortcuts that you use all the time in MS Word, but I have a couple to share with you in this newsletter that I don’t think that most of you are aware of, and let’s face it, you can never have enough shortcuts and quick keys, right??
| Do this |
To Accomplish This
|
|---|---|
| CTRL + K | Inserts a link |
| CTRL + L | Aligns the line or selected text to the left of the screen |
| CTRL + M | Indents the paragraph |
| CTRL + F | Changes your font |
| CTRL _ Del | Deletes word to the right of the cursor |
| CTRL + Spacebar | Resets highlighted text to the default font |
| CTRL + N | Opens a new Document |
| F7 | Spell and Grammar check selected text and/or document |
| ALT + SHIFT + D | Inserts the current date |
| ALT + SHIFT + T | Inserts the current time |
Some folks use note pads or Post Its to jot down quick notes to themselves and save them on their desk or stick them to their monitor.
Other folks, like the technologically savvy (geeks) use another alternative that doesn’t take them away from their computer. You may want to give this a try; it’s quite easy. The benefit is that creating scraps is just a click and drag session and you do not have to take the time to name and save a file!
Follow the steps below to learn how:
Once you have dropped the selection onto your desktop, Windows XP recognizes the selection as an OLE (Object Linking and Embedding) object from WordPad and creates a scrap, complete with a special icon with the default title name of Scrap. You can always rename the scrap so that it is more intuitive for you.
When you want to view your note, just double-click it and WordPad will open it for you!
Ever enter your data into the wrong cell in your spreadsheet? I know I’ve done that a couple of hundred times or so. If you get distracted as easily as I do, I am happy to tell you that there is a quick and easy method to move that data to the proper cell.
Follow the steps below:
I think this is a quick and easy way to take care of this.
I know that a lot of you know many keyboard shortcuts that you use all the time in MS Excel, but I have a couple to share with you in this newsletter that I don’t think that most of you are aware of, and ones which I find to be absolutely helpful and real time savers. I think you will agree with me.
| Do this |
To Accomplish This
|
|---|---|
| ALT + = | Insert autosum |
| CTRL + SHIFT +U | Resize the Excel formula bar (2007 only) |
| ALT + ‘ | Allows for the selection of a named style by typing the first few letters of the style name |
| ALT + ‘ | In 2007 brings up the style details box |
| CTRL + Y | Repeat last action |
| F4 | Repeat last action |
Fonts are not the only customized or customizable items in MS PowerPoint 2007.
You can give shadows to pictures, new shapes, styles and effects as well! You can also crop your pictures as needed.
Follow the steps below to learn how:
You can now experiment with Picture Styles or make up your own custom styles!
Sometimes you want someone to select only from a list that you offer in your worksheet. This is very easy to do in MS Excel 2007.
Follow the steps below to learn how:
Not difficult at all!
Sometimes you feel like a Ribbon and sometimes you don’t! Well guess what? You can have it your way someplace other than Burger King!
Follow the steps below to learn how to hide and restore the Ribbon in MS Office:
The Ribbon will now be treated like a menu – it will remain hidden until you click the tab or use the ALT key to bring up keystrokes.
In MS Word 2007 you can translate words and even sentences into French, Arabic or Spanish, quickly and easily!
Follow the steps below to learn how:
Pretty nifty eh?
When you select text in MS Word 2007 the Mini-toolbar appears. At first it is faint but when you hover your mouse over it, it becomes much clearer and prominent.
The Mini toolbar is designed to put common formatting commands close at hand for you. It is very convenient if you want to highlight a selection or change font characteristics, but the Mini toolbar can be cumbersome if you want to rearrange text by clicking and dragging. It can also be very distracting when you want to right-click to access the contextual menu.
If, for whatever reason, you find you do not like the Mini toolbar, follow the steps below to disable it:
Poof! It’s gone!
