April on Tue, 16 Jul 2002 10:14:01 +0200 (CEST)


[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]

[Nettime-bold] MS Office Tips 07-16-2002 [ Word Highlighter + Hide Excel Columns ]


Title: MS Office Tips & Tricks

Useful Links

Message Board
Subscribe
Software Store
Computer Terms

Guides

Windows Shortcuts
Downloading
E-mail
Virus Guide
Digital Cameras
Emoticons :-)
Internet Errors
Software Install
File Sizes
Image Formats

Software Deals!

Check out our new bargain bin!
Click here now!


NNY Times Crosswords
Play hundreds of different crossword puzzles!


Only $12.97!


Pajama Sam's Sock Works
Awesome Kids Game!


Only $7.97


Business Cards
The easy way to make business cards!


Only $12.95!


Ulead PhotoImpact 6
Awesome graphics program - great for the web!


Only $34.97!


Encyclopedia Britannica 2002 w/ FREE Myst Game
The best encyclopedia with the # 1 game of all time!


Only $24.97!


Norton Personal Firewall 2002
Keep hackers out of your computer!!


Only $19.97!


Announcements

Want to be an expert with Internet Explorer?

You do? Good, cuz we have an incredible deal for you. It's a program called Professor Teaches Internet Explorer and we have it for only $4.97! And yes, US shipping is still FREE! Is that an incredible deal or what? I mean, you can hardly get a fast food "value" meal for that kind of money.

This program is designed to teach you - step by step - to use Internet Explorer 5.5. Now, if you're not using version 5.5, DON'T WORRY - 99% of the program applies to version 5 and 6.

This program will take you from the absolute basics (like how to launch Internet Explorer) to more advanced techniques (like cleaning out your History file and such).

It is divided into 8 different categories including Introduction to Internet Explorer, exploring the web, further into the web, saving information from the internet, working with e-mail, usenet newsgroups, searching, and advanced techniques.

The really cool thing is the way it teaches using a "hands on" approach. It doesn't just show you screen shots, but has sample windows you can actually click and work with. It's fantastic if you are a "learn by doing" type of person. (That's me, how about you?)

Anyhow, be sure to get to the site ASAP for these. It was a one time deal and once these are gone, they're gone. Again, it's only $4.97, and US shipping is FREE! Here's the link:

http://www.worldstart.com/store/internet-explorer-55.htm

Don't miss out! These are a super way to learn Internet Explorer and they won't last long!

MS Office 101

The Word Highlighter

Have you ever been working on a Word document and come to a point where you need to enter a fact that you're not sure of? Do you really want to stop this very minute to look up the information?

I'm not sure about you, but I hate to stop every few minutes to look something up. I'd rather keep going with the typing part, look information up after I'm done and double check the facts during the editing stage.

So the new question becomes, "How do I remember everything I have to check on?" I mean, what can you use to remind yourself of the places you know you may need to change?

There's a neat little feature in MS Word that can help you with this situation, it's called a highlight. It works just like the highlighter you use on printed pages. (I can remember the countless highlighters I used in college - makes me shudder - fortunately I like this one a whole lot better.)

The Highlight button is on the Formatting Toolbar and looks like this:

To use the Highlighter, simply use your mouse or keyboard to highlight (select) the text to be highlighted. Then, click on the Highlight button.

That's it - the selected text should now be highlighted - just like the good old fashioned marker type (except it doesn't make a mess on the monitor).

By clicking on the little arrow to the right of the highlighter in the button, a color palette will be displayed. This will allow you to change the color of the highlighter. Sometimes color coding information is extremely helpful.

To remove the coloring completely, highlight (select) the text and select the None choice from the color palette.

Now that you have a digital highlighter, have fun!

P. S. This is also a good tool when you have someone else proof reading your work. It draws their attention to specific places you need them to check carefully. There are an endless number of uses for the highlighter. Pretend you're a kid again and these are the new Crayolas!

Office Tip of the Day

Excel: Hiding Columns

Ever have a beautiful MS Excel worksheet, I mean absolutely perfect, except that one column. You know - the one column with the necessary data for your calculations but not really a part of the presentation. The essential column that you must keep, but don't want displayed for a presentation or on the hard copy.

Often, Excel users have a lot more data in the worksheet then they need to display in the final presentation. Some users will put this data far to the right on the worksheet. They then set the print area so that it does not include the unwanted columns.

Others will put the extra data on a different worksheet and have the formulas draw from that location. This can be a good solution to the problem, but can be time-consuming because of the extra time spent going back and forth between the worksheets.

There are many different solutions to this particular problem and everyone will have their favorite.However, I think the easiest solution is the one that people are usually unaware of. Simply hide the column!

Hide the columns?

Yes, hide them! They will not be visible on the screen or in the printouts, but rest assured, the data is there and can be displayed again.

So, how do you hide a column?

Well, the first thing you need to do is select a single cell in the column to be hidden.

Then go to the Format menu, Column choice. When the submenu pops up select the Hide choice.

Poof! Your column is gone. But is it really?

Take a look at the column letters at the top. Notice anything?

You should. Careful inspection will tell you that a letter has been skipped. The missing letter is your hidden column.

All formulas dependent on the data in this column are still working, you just don't see the raw data any longer.

Now, how do you display the column again if you need to edit or add data to it?

  • Locate where the column should be.
  • Select one cell from each column on either side of the hidden column. (For example, if column C is hidden, select cells B3 and D3.)

  • Go to the Format menu, Column choice. From the pop-up submenu select Unhide, and presto! The column is back in its original location with all of the original data.

Now, here's another cool fact. You can do this same stuff with the rows.

In the Format menu, choose Row instead of Column. Then follow the same Hide and Unhide procedures.

That's it. It's a little trick that sometimes comes in pretty handy.

Once again, if only I had this option in life. Tons of stuff to hide - the undone laundry, the sinkful of dishes, the mosquitos in the backyard, the bills in the mailbox, the cat's litterbox... The list goes on and on...

 


Copyright & Disclaimer

ISSN: 1529-336X
Copyright 2001, WorldStart. All unauthorized reproduction strictly prohibited.

You are welcome to reproduce this newsletter (i.e. print it, store it) for your own personal use. You are also welcome to forward it, in its entirety, to friends and family.

If you would like to reproduce this publication, or any part of it, in any other publication, be it web based or otherwise, you must contact us for permission. Any unauthorized re-distribution will be considered a copyright infringement and grounds
for a lawsuit.

Finally, you agree to try any advice contained or suggested in this newsletter at your own risk.

To remove yourself from this list, simply place a check next to the "Remove Me >From This List" checkbox then click the "Remove" button below. If that doesn't work, head to:

http://www.worldstart.com/newsletterunsub.htm

Remove Me From This List

If your e-mail address doesn't appear below, enter it and press the Remove button to unsubscribe.



You are currently subscribed as nettime-bold@nettime.org

 

 

_______________________________________________ Nettime-bold mailing list Nettime-bold@nettime.org http://amsterdam.nettime.org/cgi-bin/mailman/listinfo/nettime-bold