Wednesday, June 24, 2009

[TechRepublic] Transpose Excel data from rows to columns, or vice versa

Trouble viewing this mail? Read it online | Manage my newsletters | Unsubscribe

TechRepublic Microsoft Office Suite

TechRepublic Member | June 24, 2009

Transpose Excel data from rows to columns, or vice versa

When you need to flip-flop data in an Excel worksheet, don't waste time doing it manually. Excel offers a handy Transpose option that will quickly take care of the task. Read more


How much do your peers earn?

Find out on activeTechPros if you're an IT professional.

* * * * * * * *

Introducing activeBizPros: a salary resource for business professionals
We're in the midst of building our beta community site. Come join us and help drive the salary charts.

Popular power tips


E-mail multiple recipients without sharing e-mail addresses

Create a simple invoice template in Word

Move data to another workbook without copy and paste

Seven keyboard shortcuts to help make your PowerPoint slide shows glitch-free

Quickly access the Office folders you use most often

Free up screen space for reading Outlook mail

Need more screen space for reading Outlook mail? Hide the Navigation pane using this handy shortcut. Read more

How do I... Fill Word form fields with Access data?

When you need to bring your Access data into a Word form, a little VBA can expedite the task. Susan Harkins walks through an example to demonstrate the process. Read more

Office challenge: How can you discern an icon's keyboard shortcut?

Here's the solution to last week's challenge on positioning the cursor at the beginning of a Word document. This week, we're testing your general Office expertise: How do you display an icon's keyboard shortcut? Read more

A formula-less technique for parsing Excel data

Excel's Text to Columns feature parses data quickly and almost effortlessly. Read more

Use Word's AutoRecover option to avoid lost work

If users can't remember to save their work on a regular basis, get Word to do it for them. Read more

Office poll: What kind of Office training have you had?

Users pick up their Microsoft Office skills in a variety of ways -- from formal training to on-the-fly assistance from their favorite hallway guru. Take our poll and then see how other members have managed to learn the ins and outs of Office apps. Read more

Additional TechRepublic resources


Night-shift boredom on the help desk

Jeff Dray has worked some graveyard shifts on the help desk, when duties are lighter and boredom has a chance to set in. How do you cope when you need to stay alert but everyone you know is at home fast asleep? Read more

Video: Five email safety tips everyone should follow

Instant messaging, texting, and tweeting are all the rage, yet e-mail still dominates the communication landscape--at home, but especially in business. Unfortunately, many people, even IT pros, still ignore the basics of email security. Bill Detwiler goes over five basic email safety tips that everyone should follow. Read more

Best of Microsoft Office Suite


34 timesaving mouse tricks for Word users

Avoid e-mail mistakes with a single setting

Prevent Excel from turning fractions into dates

Build a quick training presentation using PowerPoint's Photo Album feature

Run your slide show on two monitors - one for you and one for your audience


Live Webinar: Speed ROI with Intel vPro Technology and Symantec Altiris

Realize significant ROI savings-and recoup your investment in as little as 10 months-by activating your PCs with these proven technology solutions.

Video: TR Out Loud - June 19, 2009


In the week before the TechRepublic Community Event, TROLOV tries to contain the excitement and carry on as usual, recapping the most popular discussions and highlighting the most active members on the boards.

TechRepublic newsletters


Get the latest community updates, product reviews, and need-to-know lists in the following TechRepublic newsletters.

Automatically sign up today:

Community Central

Product Spotlight

10 Things


How much do your peers earn?

Free 30-day Trial of Desktop Authority (ScriptLogic)

Free Test Drive: ActiveRoles Server (ScriptLogic)

Unrivaled Red Hat support now available from Novell (Novell)

Safeguard intellectual property and ensure compliance (Symantec)


10 ways to avoid viruses and spyware

To have a fighting chance against today's rampant security threats, end users have to be informed and proactive. Here are some practical guidelines they can follow to minimize the risk of infection and attack. Read more

Subscribe to the 10 Things RSS feed.

Get more from TechRepublic

Video: Five email safety tips everyone should follow

Palm Pre vs. iPhone 3G S: The choice I made and why

Familiarity can breed contempt among co-workers

Video: Five ways to control IT MOOSE spending

Featured training courses


Microsoft Exchange Server 2007

Managing and Maintaining a Microsoft Windows Server 2003 Environment

Planning, Deploying and Managing Microsoft Systems Center Configuration Manager 2007

Managing and Maintaining Server 2008

Configuring Microsoft Office Communications Server 2007

Browse all training courses

Presented by Global Knowledge

Ma.gnolia points to potential storms in the cloud

TechRepublic member dcolbert vents about his frustration and concern over the recent Ma.gnolia failure. Do you think the Ma.gnolia collapse provides an important lesson in the "cloud revolution"?

Buy Today, Only: $259.00
Buy now, only: $199

TechRepublic's best of site


32 online tools

The end is near for Windows XP, what are you going to do?

10 cool tools in Windows 7

Find and delete hidden Windows Vista and XP device drivers

Hunt down hard disk resource hogs

Send us your feedback here.

Sign up for more free newsletters from TechRepublic!
To manage your account settings or to remove yourself from all TechRepublic communications, please visit our Subscription Center.

The e-mail address for your subscription is
Unsubscribe from this e-mail | FAQ | Advertise | Privacy Policy


Copyright 2009 CBS Interactive, Inc. All rights reserved.
TechRepublic is a registered service mark of CBS Interactive, Inc.

CBS Interactive, Inc.
235 Second Street
San Francisco, CA 94105

No comments:

Post a Comment

Thanks for understanding that we need to prevent the nasties.

Terms of Use

Personal & Educational Use Only This blog consists mainly of FREE newsletters from computer web gurus that I receive. I thought you might like to see them all in one place than try to discover them on your own. A moderate amount of editing may be done to eliminate unrelated repetitious ads or unnecessary text which bloat the post. However I have given the authors full credit and will not remove their site links because you deserve to see where it comes from and they deserve to get credit for what they have written. Your use of this site is simply for educational purposes. For more computer-related help go to: CPEDLEY.COM for free software, advice and tips on low cost products which are very helpful. If you want to contact the editor, please go CPEDLEY.COM and check the Contact page for email address.