elite Tech Tips

Consolidating Excel Worksheets

noreply@blogger.com (The elite Program) — Tue, 27 Apr 2010 12:00:00 +0000

Need to combine data from multiple Excel worksheets into one? For example, say you want to keep track of your company’s expenses and revenue. To do this you create two separate Excel worksheets, one for expenses and one for revenue. Later on, however, you want to be able to view the totals for both worksheets side-by-side. How do you do this? By using certain techniques in Excel you can combine data from multiple worksheets into one so that it is easier to see the bigger picture. Learn how by reading this brief article.

Movies and PowerPoint: A Troubled Duo

noreply@blogger.com (The elite Program) — Tue, 20 Apr 2010 13:00:00 +0000

Ever added a movie to your PowerPoint presentation only to have it not play during the presentation? If you have or simply want to avoid ever having this problem, read this article from Microsoft. They detail possible reasons for the problem and various ways to solve them.

Get to Know the Elon Technology Wiki

noreply@blogger.com (The elite Program) — Tue, 13 Apr 2010 12:00:00 +0000

Need fast and reliable technology help? Your source for official technology information, the Elon Technology Wiki, includes important announcements, how-to information, and support features specific to Elon. Visit the Wiki and search for official technology information, updated by Elon’s Technology Department, in the Technology space, or search and even add your own information in the Technology Public space. Simply search for the information you need in the navigation box and voila, a list of possible answers appears!

Microsoft Office 2010

noreply@blogger.com (The elite Program) — Mon, 05 Apr 2010 15:00:00 +0000

Check out what Microsoft’s exciting new software may offer you! Be one of the first to get an insider’s view of Microsoft Office 2010’s new features and capabilities by reading a free e-book or watching a short video.

Excel's Average Function

noreply@blogger.com (The elite Program) — Tue, 30 Mar 2010 14:00:00 +0000

Have a list of data in Excel that you need to find the average of? Does your data combine both numerical and text values? If it does, then using the average function won’t accurately calculate the average for you. Read this TechRepbulic blog to find out what you can do instead.

10 PowerPoint Tips

noreply@blogger.com (The elite Program) — Tue, 16 Mar 2010 14:12:00 +0000

Ever wondered how to time a PowerPoint presentation perfectly or how to annotate one as you presented? Read this TechRepublic blog on 10 ways to spice up and slim down your PowerPoint.

Best Practices: Microsoft Outlook

noreply@blogger.com (The elite Program) — Tue, 09 Mar 2010 14:08:00 +0000

Microsoft Outlook is a software tool designed to help you manage your emails, calendars and to-do items efficiently and effectively. In fact, the amount of what it can do may be overwhelming and intimidating. To help you better understand how Outlook can help you manage your life through emails and schedules, the Microsoft Corporation has compiled a document on what it regards the easiest and most effective ways to utilize Outlook. Follow this link and download either a Word or PDF version of the document.

Wish You Knew It?

noreply@blogger.com (The elite Program) — Wed, 03 Mar 2010 13:56:00 +0000

Ever find yourself spending precious time trying to remember how to format an excel sheet or save an iMovie project? The Elon Technology Wiki, a resource that compiles those answers and hundreds more, can save you time! Visit the wiki at www.elon.edu/wiki [keyword search: software support]. Here we have sorted through the official Adobe, Microsoft, Apple, Google and other multimedia software support pages for you, compiling links to video and step-by-step tutorials, including both basic and advanced techniques.

Cisco IP Voicemail Tips

noreply@blogger.com (The elite Program) — Tue, 24 Nov 2009 22:02:00 +0000

It is always nice for callers who have to leave a Voice Mail to know that they are leaving the message for the right person. Personalizing your Cisco IP Phone Voice Mail is fast and easy, and can help reassure these callers.

To set up your voice mail:

Press the Message button on the right hand side of the keyboard.
Enter the default password 12345 followed by the # key.
Follow the instructions given to record your personal greeting and create your new password.

Now, with the Holiday Season approaching quickly knowing how to set up an alternative greeting is important. This is also easy to do and can be helpful for callers.

To set up your temporary (or alternate) greeting

Dial 4790 from on campus or (336) 278-4790 from off campus.
Login using extension and password if on campus; off campus do * then extension and password.
Press 4 to reach setup options.
Press 1 for Greetings.
Press 3 and choose alternate greeting.
Follow instructions to record your alternate greetings.
Press 2 to turn on alternate greeting and set expiration day and time.

For more information on the IP Phone Voice Mail system be sure to visit the Desktop Phones page on the technology wiki.

Cisco IP Phone Tips

noreply@blogger.com (The elite Program) — Tue, 17 Nov 2009 17:55:00 +0000

Many of the phones located in offices around campus are Cisco IP Phones. Here are some phone tips to help you use all the features that are available on this phone:

Placing a Call - You can place a call with your telephone by:

1. Lift the handset from the rest and dial the number.

2. Press a line button and dial the number.

3. Press the New Call soft key and dial the number.

4. Press the Redial soft key. If the number was just dialed, you will be connected.

5. To use the speakerphone, press SPEAKER and dial the number.

Answering a Call - You can answer a call by:

1. Lift the handset from the earpiece rest.

2. Press the Answer soft key or the SPEAKER button.

Ending a Call-To end a call:

1. Put the handset on the earpiece rest.

2. Press the SPEAKER button.

Transferring a caller to another number

Press transfer
Dial extension
Note who you are transferring and why
Press transfer again to transfer caller, then hang up

Transferring a caller directly to someone's voicemail

Press transfer
Dial * and extension
Press transfer quickly again, then hang up

Forwarding a phone extension directly to voicemail (all calls to the extension will go into voicemail)

Press CFwdALL button on phone
Dial * and your extension
To end call forwarding directly to voicemail , press CFwdALL button

For more information on placing calls be sure to visit the Desktop Phones page on the technology wiki.

Stayed tuned for tips on the Cisco IP Phone Voice Mail!

correct common errors in excel formulas

noreply@blogger.com (The elite Program) — Tue, 03 Nov 2009 18:04:00 +0000

Did you know that you can implement certain rules to check for errors in formulas when using Microsoft Excel? These rules can help you find common mistakes when using formulas and these rules can be turned on or off individually.

Errors can be marked and corrected in two ways: one error at a time or immediately when they occur on the worksheet as you work. Either way, a triangle appears in the top-left corner of the cell when an error is found.

Errors that cannot return a result (such as dividing a number by zero) require attention and display an error value in the cell. Other errors can be less serious, such as a formula that appears to be inconsistent with adjacent formulas. The formula returns a correct result, but the error advises you that you should examine the formula.

You can resolve an error by using the options that appear or you can ignore the error by clicking Ignore Error. If you ignore an error in a particular cell, the error in that cell does not appear in further error checks. However, you can reset all previously ignored errors so that they appear again.

To find out more about checking common errors in excel and how to turn these rules on or visit Microsoft Office Online.

Format Painter

noreply@blogger.com (The elite Program) — Tue, 27 Oct 2009 17:29:00 +0000

One of the most helpful toolbar buttons in Office programs is the Format Painter. This button offers a quick way to copy formatting from one item to another.

Using Format Painter saves you time and effort. Instead of having to manually apply the font, font effects, centered paragraph alignment, and other formatting to each new section heading, you can quickly copy all of the formatting attributes by using one toolbar button.

To copy formatting:

1. Do one of the following:
To copy both paragraph attributes (such as alignment, indentation, and so on) and character attributes (such as font and font effects), select the text whose formatting you want to copy plus the paragraph mark that follows the text.
To copy only character attributes, select the text without selecting the paragraph mark.

2. On the Standard toolbar, click Format Painter.

3. Select the text you want to apply the formatting to.
The text takes on the new formatting.

If you want to apply the same formatting to more than one item, select the formatting you want, double-click Format Painter, and then select each word, phrase, or paragraph you want to apply formatting to. When you're finished, press ESC.

For more information about the Format Painter visit Microsoft Office Online.

Office Clipboard

noreply@blogger.com (The elite Program) — Tue, 13 Oct 2009 16:18:00 +0000

The Microsoft Office Clipboard allows you to copy up to 24 multiple text and graphical items from Office documents or other programs and paste them into another Office document. Whether you need to copy text from a website, e-mail message or a graphic, office Clipboard can help you arranged the copied items the way that you want in the document.

Word

1. Open the file that you want to copy items from.

2. Select the first item that you want to copy.

3. On the Home tab, in the Clipboard group, click Copy.

Keyboard shortcut To copy an item, press CTRL+C.

4. Continue copying items from the same or other files until you have collected all of the items that you want. The Office Clipboard can hold up to 24 items. If you copy a twenty-fifth item, the first item on the Office Clipboard is deleted.

If you open the Clipboard task pane in one Office program, the Clipboard task pane does not automatically appear when you switch to another Office program. However, you can continue to copy items from other programs. If the Show Status near Taskbar When Copying option is selected (to verify, click Options in the Clipboard task pane), a message is displayed above the status area to indicate that an item has been added to the Office Clipboard.

As items are added to the Office Clipboard, an entry is displayed in the Clipboard task pane. The newest entry is always added to the top. Each entry includes an icon representing the source Office program and a portion of copied text or a thumbnail of a copied graphic.

Paste items

You can paste items from the Office Clipboard individually or all at the same time.

1. Click where you want the items to be pasted. You can paste collected items into any Office program.

2. Do one of the following:

§ To paste items one at a time, in the Clipboard task pane, double-click each item that you want to paste.

§ To paste all the items that you copied, in the Clipboard task pane, click Paste All.

Note The Paste Special command is available from the Clipboard group but is not integrated into the Office Clipboard task pane functionality.

Delete items from the Office Clipboard

You can delete items from the Office Clipboard individually or all at the same time.

In the Clipboard task pane, do one of the following:

To clear one item, click the arrow next to the item that you want to delete, and then click Delete.

To clear all items, click Clear All.

For more information on how to use the Office Clipboard in other Microsoft Programs visit Microsoft Office Online.

spell check

noreply@blogger.com (The elite Program) — Wed, 07 Oct 2009 14:56:00 +0000

Have you ever been typing a document in a foreign language and wished you had spell check to review your work? Well, with the help of three simple steps in Microsoft Word 2007 you can!

1. Select the text that is in the language you want to set

2. In Word 2007, on the Review tab, click the Set Language command.

3. Select the language that the text is in, select Detect language automatically, and then click ok.

By setting the language of the text, you tell the spelling checker which dictionary language to use to check your spelling.

When you check the spelling and grammar of text in a language you are using the proofing tools for that language. You can be sure the language’s proofing tool is installed on your computer if the Spelling & Grammar icon appears to the left of the language in the Language dialog box.

For more information on checking spelling and grammar in another language listen to the tutorial from Microsoft Office Online.

excel worksheets

noreply@blogger.com (The elite Program) — Tue, 29 Sep 2009 16:00:00 +0000

Do you dread working in Excel in fear of having a workbook with multiple sheets? Don’t you just hate when you get to the point where you cannot see all the tabs in one view. Wouldn’t it be great if there was a way to see all the sheets and be able to click on the one you want! Well, you’re in luck…there is a way!

All you need to do is right-click the tabs navigation buttons and a floating list of all the worksheets in the workbook will appear.

Also, two keyboard shortcuts when working with worksheets in Excel:

CTRL+PageUp- activates the previous sheet in your workbook

CTRL+PageDown- activates the next sheet

For more information visit Microsoft Office Online to view the Hidden Gems in Excel 2007 page.

Virtual PRIVATE NETWORK (VPN)

noreply@blogger.com (The elite Program) — Tue, 22 Sep 2009 16:13:00 +0000

Have you ever been off campus and needed to access resources such as the library databases or your network storage? Were you not able to connect to them? Well, you’re in luck for the next time you are off-campus! Campus Technology offers a tool that will give you access.

Since the library databases and network storage are secure services, they are accessible from either on-campus or by using the Virtual Private Network (VPN) client if you are off-campus. To use the VPN client users will need to:

1. Configure the software on their computer

2. Use their Elon email username and password for authentication

For more information visit the Technology wiki [keyword: Remote access and VPN].

Conditioning your list

noreply@blogger.com (The elite Program) — Tue, 15 Sep 2009 17:02:00 +0000

Do you often find yourself using Excel spreadsheets to organize or keep track of something? Do you find your list is boring, unorganized, or hard to follow? Well, Microsoft Excel 2007 provides users with great conditional formatting rules, allowing automatic display of nicely formatted icon sets to improve the quality of your spreadsheets.

Want to make your list drastically change like this?

For step by step directions on how to improve your Excel lists, visit this Microsoft Office website and scroll down to the “Condition your List” section. Other Tech Tips on this page include managing multiple worksheets and grouping dates in a PivotTable.

Ricoh Docsend

noreply@blogger.com (The elite Program) — Tue, 08 Sep 2009 16:29:00 +0000

Have you ever needed to convert paper documents into an electronic format? Did you dread the amount of time it would take to scan each document? Did you know that Elon has DocSend units around campus that can help you convert documents to an electronic format and that allow you to scan in a snap?

Well, the DocSend allows you to:

Capture-and-delivery system that effortlessly converts hard copies to digital files for instant delivery or storage
Scan to E-mail recipients (including yourself), network storage, jump drive, or to print.
Supports both black and white and color scanning with resolutions up to 600 dpi.
Ability to convert a file to a Word document, image file (jpg or tiff), or a PDF.
Make edits and annotations at the unit.

Want to use this machine? Students can access this machine on the first floor of Belk Library in the copy room. To view a list of other various offices and locations around campus with the DocSend visit the Installation page in the wiki.

For more information on how to use the DocSend you can also visit following sites in the wiki:

Quick Start Guide

Ricoh Copier, Printer, and DocSend

Outlook Command Tips

noreply@blogger.com (The elite Program) — Tue, 12 May 2009 22:53:00 +0000

Hello everybody and welcome to another installment of elite’s Tech Tips! Summer is approaching and everyone is headed in different directions; however, we all will continue to check our e-mail. Check out some of these command tips that can help you when using Microsoft Outlook.

To compose a new message- press CTRL+SHIFT+M

To jot a quick note- press CTROL+SHIFT+N

To create a new contact- press CTRL+SHIFT+C

To go to Mail view- press CTRL+1

To go to Calendar view- press CTRL+2

To go to Contacts view- press CTRL+3

To go to the Tasks list- press CTRL+4

To go to Notes view- press CTRL +5

To reply to a current e-mail message- press CTRL+R

To forward the current e-mail message- press CTRL+F.

To delete the current e-mail message- press CTRL+D.

To reply to everyone who received the selected message- press CTRL+SHIFT+R.

To select all the items in a folder, click one of the items and press CTRL+A.

To send an open message- press ALT+S.

To quickly check spelling in an open item- press F7.

To quickly switch to your Inbox- press CTRL+SHIFT+I.

To quickly switch to your Outbox- press CTRL+SHIFT+O.

To quickly switch to viewing by weeks in Calendar, click in Calendar and press ALT+HYPHEN.

To quickly mark a message as read- press CTRL+Q.

To quickly move between the schedule area and Task Pad view in Calendar- press CTRL+TAB.

To quickly create a new Journal entry- press CTRL+SHIFT+J.

Before you depart from Elon for the summer make sure to try out some of these command tips in Outlook! We wish you all a relaxing and safe summer, and we look forward to successfully continuing to serve our customers in the fall. In the mean time, if you wish to contact the elite Program over the summer, call us at ext. 5000 or email us at elite@elon.edu.

Until the fall!

The elite Program

Nudging and Grouping elements in Publisher

noreply@blogger.com (The elite Program) — Wed, 29 Apr 2009 14:49:00 +0000

This week we are going to continue with our publisher tips with “nudging” and the importance of grouping together elements of your design.

“Nudging” items in Publisher

Are you trying to get that picture or text box in the exact right spot but are going cross-eyed trying to place it in the exact right place? There is a way to be more precise than simply dragging and dropping, and it’s called “nudging.” Nudging an object will make it move only one pixel in the desired direction, so you can get your object in the exact right spot. To nudge an object, hold down the Alt key and press an Arrow button in the direction you want it to move. This can also be done by clicking Arrange in the top ribbon and then highlighting Nudge. You will see the options for the directions that you can nudge the object.

Grouping Elements
After you have a section of your layout positioned very precisely it might be a good idea to select all the items (hold down the shift key and click on each one) and then group them together using Arrange then Group Objects, by holding down Ctrl and Shift and then pressing G, or by just clicking the image that appears (see picture to right) beneath your grouped items. You will notice that when you do this, the boxes around the individual items that you have selected will disappear, leaving only one large box around all of the grouped items. Grouping objects will lock them together in their relative positions. This is especially useful if you will need to duplicate this configuration somewhere else in your layout; copy and paste the group to another page and you will have perfect consistency throughout your layout.

That’s all for now! Until next week,
The elite Program

The Pack and Go Wizard

noreply@blogger.com (The elite Program) — Thu, 23 Apr 2009 14:55:00 +0000

Hello everybody, and welcome to another installment of elite’s Tech Tips. When reviewing the past year’s blog posts, there seems to be a lack of Microsoft Publisher hints and tips. So, without further ado, here is a huge hint for Microsoft Publisher that will save you a lot of grief when you need to send your publication to a printer or to another computer.

The “Pack and Go” Wizard

When you create a Publication in Publisher, you may find you want to take the publication to another computer for more processing and/or for printing. Be careful, though, because not all computers have the same font packages and art galleries that you used. If it doesn’t, your publication may look much different than your original concept by the time it hits the printer.

In order to prevent this, you can use the “Pack and Go” wizard to pack your files and include both the fonts and the graphics you used with your files. This will allow you to be sure your publication will look the same as it did on your computer where it was created. To use the Pack and Go wizard, select the File menu, then choose Pack and Go, and then select Take to Another Computer. Follow the Pack and Go Wizard each step to go through the packing process.

It will first ask you to save your file before completing the Pack and Go wizard. Click Ok to do so. Then click Next. Now, choose what destination you want to save your finished product to by choosing one of your options. To save it on to your desktop, click Browse and choose the folder from there. From this window you can either choose Finish to export all of your files or Next to choose more specifically what from your publication you want to save. For most cases, clicking Finish should be fine. Your computer has now made a compressed (.zip) folder containing all of the necessary files to make your publication free to be viewed on any computer.

That’s all for now! Until next week,

The elite Program

Locking Rows and Columns in Excel

noreply@blogger.com (The elite Program) — Tue, 14 Apr 2009 18:04:00 +0000

In Microsoft Excel, users often use the top row or first column to create headers for their document, labeling what the data is in the corresponding cells. Have you ever done this only to be frustrated to not be able to see them when you scroll down? Wouldn’t it be nice to be able to see certain rows or columns in your document, regardless of where you are on the page?

Well guess what?

Locking Excel Rows and Columns

You can view two areas of a worksheet and lock rows or columns in one area by splitting or freezing panes (A pane is a portion of the document window bounded by and separated from other portions by vertical or horizontal bars.). When you split panes, you'll be able to scroll in both areas of the worksheet, while rows or columns in the non-scrolled area remain visible. This is comparable to the split screen in Microsoft Word.

When you freeze panes, you select specific rows or columns that remain visible when scrolling in the worksheet. For example, you would freeze panes to keep row and column labels visible as you scroll.

To split viewing panes, do the following:

To lock rows, select the row below where you want the split to appear. To lock columns, select the column to the right of where you want the split to appear. To lock both rows and columns, click the cell below and to the right of where you want the split to appear.
On the Window menu, click Split.
To remove the split, click Remove Split on the Window menu.

To lock the rows by freezing the panes, do the following:

Select the rows and/or columns that you want to be frozen at the top of the page.
On the Window menu, click Freeze Panes.
To unlock rows, click Unfreeze Panes on the Window menu.

Now you can see which columns and rows you’re referring to without having to scroll up and down.

That’s all for now! Until next week,
The elite Program

Entering Repetitive Data in Excel, Quiet Time in Outlook

noreply@blogger.com (The elite Program) — Wed, 08 Apr 2009 15:01:00 +0000

Entering Repetitive Data in Excel

If you need to type repetitive data such as some numbers or dates into a worksheet, you can use the AutoFill feature in Excel to help you. Here's an exercise you can try to practice entering repetitive data quickly.

First, quickly fill a group of cells with the names of the calendar months:

Start Excel. A new, blank workbook appears.
In cell A1, type January and then press ENTER.
Click anywhere inside cell A1, and rest the mouse pointer on the square at the lower right-hand corner of cell A1. The mouse pointer changes into a plus sign (+).
Press and hold the right (alternate) mouse button, drag the mouse pointer to cell A12, and release the right (alternate) mouse button. A menu appears.
Click Fill Months. The names of the months February, March, and so on appear in cells A2 through A12.

Next, quickly fill in several cells with the same value:

In cell B1, type 1999 and press ENTER.
Click anywhere inside of cell B1 and rest the mouse pointer on the square at the lower right-hand corner of cell B1. The mouse pointer changes into a plus sign (+).
Press and hold the right (alternate) mouse button, drag the mouse pointer to cell B12, and release the right (alternate) mouse button. A menu appears.
Click Copy Cells. The value 1999 appears in cells B2 though B12.

Finally, quickly fill in several cells with a range of numbers:

In cell C1, type 10000.
Click anywhere inside of cell C1 and rest the mouse pointer on the square at the lower right-hand corner of cell C1. The mouse pointer changes into a plus sign (+).
Press and hold the right (alternate) mouse button, drag the mouse pointer to cell C12, and release the right (alternate) mouse button. A menu appears.
Click Series.
In the Step value box, type 125 and click OK. The Series dialog box disappears, the value 10125 appears in cell C2, and the number increases by 125 in each cell in column C up to an ending value of 11375 in cell C12.

Here is another tip to help you get your miscellaneous work done like reading e-mails and various other small tasks that always gets pushed back for those bigger projects.

Avoid Constant Interruptions for Quiet Work Time
How many interruptions do you get every day? It's nearly impossible to complete anything when you allow constant interruptions from the phone, people stopping by your office, and instant messaging.

In Microsoft Office Outlook, you can book yourself a recurring appointment for an hour a day to process e-mail, and mark the time as Busy. During this time, don't answer the phone or permit interruptions, and work only on dealing with your Inbox.

At first, keeping these appointments will take discipline. But over time, it will become a habit. And after you get to zero e-mail in your Inbox, you'll see the value of this one hour a day and stick to it.

Tasks in Microsoft Outlook and the Help Button

noreply@blogger.com (The elite Program) — Tue, 17 Mar 2009 17:47:00 +0000

Tasks in Microsoft Outlook
One of the most useful yet most overlooked feature in Microsoft Outlook is the Task Pane. In the task pane of Outlook, you can have your “To Do” list right there on your computer screen. You can put whatever you want on there, from finishing that report to feeding the cat. And it’s very simple to use!

In the bottom right corner of the screen in the “Mail” or “Contacts” view, there is a little window that says “Type a new task.” Whenever you remember something (or get assigned something) that you need to get done, just type it into where it says Type a new task. A little flag reminder will show up next to what you typed in as the task name. Whenever you get that task done, click on the flag and the task will disappear.

There is also a little box next to the flag, and this is where you can categorize your tasks. Just like in your e-mail and on your calendar, you can categorize your tasks by color to remind you what type of task it is. For example, you can have a color for work and one color for work to be done outside of your job, like doing taxes or cleaning the attic.

By default, tasks appear in your calendar on the date when they are due. You might prefer to have them appear on the date when you should begin to work on them instead. There are several different ways to view your tasks, including “By Start Date” and “By Category.” To change the order in which your tasks appear, click where it says Arranged By: Due Date, and a dialog box will open that shows all of the different options for viewing your tasks.

Getting Help

If all of these tips still aren’t helping you, don’t forget that you have your own tech tutor right at your fingertips! As a reminder of how easy it is to access Help in Office, just look for the question mark at the top of each program’s window or the “Help” menu in the ribbon. Click on the question mark to get the latest online assistance. Help is contextual, so wherever you are, it will give information on that topic. Don’t dismiss this tool, it is very, very useful.

That’s all for now! Until next week,

The elite Program

Transposing Data Columns to Rows in Excel

noreply@blogger.com (The elite Program) — Tue, 10 Mar 2009 16:14:00 +0000

Transposing Data Columns to Rows in Excel

Here’s a scenario: You have an Excel spreadsheet full of data, hundreds of data points all in a column. There’s only one problem: they’re in different columns, and you need them in different rows. No, you don’t have to re-type the whole thing! Here is a quick and easy way to transpose data from columns to rows.

On the worksheet, do the following:

To rearrange data from columns to rows, select the cells in the columns that contain the data.
To rearrange data from rows to columns, select the cells in the rows that contain the data.

On the Home tab, in the Clipboard group, click Copy, or just click Ctrl + C.

Note: You can only use the Copy command to rearrange the data. To complete this procedure successfully, do not use the Cut command.

On the worksheet, select the first cell of the destination rows or columns into which you want to rearrange the copied data.

Note: Copy area(s) and paste area(s) cannot overlap. Make sure that you select a cell in a paste area that falls outside of the area from which you copied the data.

On the Home tab, in the Clipboard group, click the arrow below Paste, and then click Transpose.
After the data is transposed successfully, you can delete the data in the copy area.

Quick Note: If the cells that you transpose contain formulas, the formulas are transposed and cell references to data in transposed cells are automatically adjusted. To make sure that formulas continue to refer correctly to data in non-transposed cells, use absolute references in the formulas before you transpose them.

No more headaches just because you want your Excel data displayed differently. With a couple clicks of the mouse you can transpose data from rows to columns, and now you know how to do it.

That’s all for now! Until next week,
The elite Program