|
It is very rare to be able to create a
worksheet and everything falls
into the proper order. For example, often when working with spreadsheets,
we discover the second column should really be after the third column.
Most novices would erase everything and start again, or ignore the issue
and be left with something less than satisfying. That is where cut
and paste comes into play. We want to cut something out and move
it to another location.
STEPS
|
This feature is absolutely one of your best friends.
When you make a mistake, DON'T PANIC. If you do, you will probably
kill your file completely. Just utilize the undo feature. It
should be noted that current releases of most Excel processing programs
have many undo levels, meaning you can remove more than the last action.
For multiple undo actions use the drop list attached to the button or continue using the shortcut until all the unwanted commands are removed. |
If you have overdone your undo's bring the actions back
by utilizing the reverse feature.
For multiple undo actions use the drop list attached to the button or continue using the shortcut until all the unwanted commands are removed. |
When you want to set any style that is not readily available
on the formatting toolbar, you should utilize the font dialog box.
There is a wide variety of options available.
1. Select the text using either the keyboard or mouse conventions. 2. From the Format menu, choose Font 3. Select the Font Face, Size, and Style. 4. Select other Font options as desired 5. Click on OK or tap the Enter key |
Bold - Italics - Underline text
These options are the most widely used.
They are so popular that learning the shortcuts can be a very good idea.
Or
|
|
Once you've formatted text to look
the way you want, you can copy the formatting to other text in the document.
For example, you have a 30 page spreadsheet that has Subtotals that you want to have stand out. To make the Subtotals stand out, you have decided to make the font different by changing the: style, size, color, bold and italics those cells, and Set the subtotals to a currancy style. If you wanted to do that to every subtotal, you would have to remember 6 different setting options for each cell. This feature is marvelous. It does take a little practice, but once you have mastered it, the feature is really kind of fun. Needless to say, there are several ways of using format painter. Mouse
You can copy the character formatting of selected text quickly by using shortcut keys. Select the text with the formats you want to copy and then press CTRL+SHIFT+C. Then select the text you want to change, and press CTRL+SHIFT+V. |
Have a problem and can't
find the answer on our site?
Click Here To
Contact Us. |
Want to know what people say about us? Visit our Comments page. |
Let us know what you think about our site or want
to offer any suggestions. |
Thanks for visiting |
||
These links will lead you into our
framed website. It is best viewed at a screen
resolution of 1024 x 768
dpi, however, 800 x 600 dpi will
also work. |