|
ABC ~ All
'Bout Computers |
|
|||||
What's New at Linda's Computer Stop
I want to welcome ABC's newest Fleet member, Charlene Russ.
Charlene's specialty is graphics and design and she's gonna teach us all a
LOT of good stuff. Go here to read all about her and the rest of the
Fleet: I wrote an article for Dian Chapman's Techtrax eZine which explains the new Task Pane in all the Office XP programs. It's actually a pretty cool feature, so if you want to get the most use out of it, you might want to check this out. You can go to the TechTrax site and read it (and while you are there, click on the link on the left to take the TechTrax survey...it only takes a couple minutes and there's a random drawing with some GREAT prizes you don't wanna miss). Or, read it here at my site, where there are no prizes :-( Fleet member, Vic Ferri also has an article at TechTrax that tells all about Holographic Video Storage, which is REALLY interesting. I've beefed up the Windows XP section of my Windows Page and added
some new links. If any of you know of some good resources for Windows
XP users, please send them to me and I will add them. The newest term at Eclectic Academy started this week and I am accepting
late enrollees until Sunday, November 10th, so if you hurry, you can still
get in. Read all about my online classes here: And, I've added a link to the MouseTrax Downloads page on my own
downloads page. Dian and Greg Chapman, MS MVPs, offer some great
freebie utilities. Scroll down til you see MouseTrax: Well...that's about it for this month. Please come back to my site often to see what else I've added and drop me a line if you have any suggestions. Linda PRINTING ALL THE FORMULAS IN YOUR EXCEL SPREADSHEET Do you want to print all the Formulas in one of your Excel spreadsheets so you can have the hard copy right beside you while you work? Well...here's the steps to do this easily. 1. Hit ctrl+` to show all your formulas. (` is the key above your tab on the left of your keyboard. It's a toggle, so if you hit ctrl+` again, it will turn the formulas off.) 2. Go to the Edit menu and select "Go To". 3. In the Go To box, click on the button that says Special. 4. In the Special box, put a check in Formulas and leave all the sub-boxes under Formulas checked. Click OK. 5. Now all your formulas are selected, so go to the File menu and choose Print and in the section where it says "Print What", choose Selection. ALSO...if you want to see the exact locations of the formulas, before you do this, go to the File menu and choose "Page Setup". In there, click on the "Sheet" tab and put a check in the boxes that say "Gridlines" and "Row & column headings" in the Print section. This way, you won't just see the formulas spread out all over your pages, but you will see the rows and columns where they are located. And there you go! Linda Johnson is a college instructor of all of the Microsoft Office Programs, as well as Adobe PhotoShop and Windows. She also teaches online distance learning classes in Excel, Outlook, PowerPoint, Publisher, and Word at Eclectic Academy. She has worked helpdesk and teaches and lectures at many local businesses and tech schools in her area. Support this newsletter by checking out Linda's eBooks, MS Word MAGIC!, Book I: Fonts, Fun & Formats and Book II: Table Wizardry, How To Get Started As a Software Trainer, and her newest series of MSOffice eBook Tutorials and CD |
,
