answersLogoWhite

0


Best Answer

Right-click on the tab at the bottom of the worksheet and name it to whatever you like. After you have named the worksheets, click the tab and drag to a location on the tab row to whatever position you like. There is no method (except for writing a custom visual basic for applications program) to automatically rearrange the worksheet names on the tab row.

User Avatar

Wiki User

14y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

13y ago

Click the worksheet tab you want to move to select it. Click again (not double click) and hold the mouse button to drag the sheet to the position you want it amongst the other worksheets. Release the mouse button and you're done.

Alternatively you can right click on the tab you wish to move and choose 'move or copy'. Select which sheet you want to move before and click OK.

This answer is:
User Avatar

User Avatar

Wiki User

14y ago

Select all the words with the mouse. Then click the A to Z icon on the toolbar, or go to the Data menu and pick Sort and sort it that way.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you change the worksheet order in Microsoft Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Each worksheet can displayed on Microsoft by clicking what?

You click on the Sheet Tab of the worksheet you want in order to make it the active sheet.


Is Microsoft Excel on Sony computer?

Excel does not come automatically with any brand of computer. You have to specifically order it and pay for it. It can run on a Sony computer, so if you are buying a Sony computer you can order Microsoft Office, which Excel is part of.


What can cause the order of some menus in Excel to change?

dykslexia... that or fate


Where can you find a website that puts words into alphabetical order automatically?

if you type the words into Microsoft excel and press the a,z button it will do it for you


In Microsoft Excel addition and subtraction are considered to be on the same level of?

They are on the same level as each other. Mathematically, addition and subtraction have equal precedence and are done in a left to right order. Microsoft Excel is designed to follow the rules of mathematics, so they have equal precedence.


In excel which would you perform to group ajacent worksheets?

In order to group nonadjacent worksheets, you click first tab, then hold Ctrl and click last tab. Excel was developed by Microsoft.


Where can one purchases guides to help them learn how to use Microsoft Excel Software?

There are plenty of places in order for one to purchases guides to help them learn how to use Microsoft Excel Software. The best way should be access into the website Microsoft to have the correct information.


How can an excel sheet order can be changed by?

You can click and drag a sheet tab to change its position.


How do you put numbers in order using Microsoft Word?

Put them into a table and then sort. Alternatively, sort them in another application, such as Excel or Access and then copy them into Word.


What on the computer allows you to solve complex problems where a number of variables can be changed in a worksheet in order to meet a goal in a particular cell?

In a spreadsheet software such as Microsoft Excel or OpenOffice Calc, there is a Goal Seek tool (Under Data, What If Analysis for Excel; under Tools for OpenOffice), which allows you to try to find a value of a particular cell, which will give the desired value in a target cell. The target cell needs to contain a formula, whose value changes with the cell that you are adjusting.


In Excel order of precedence detemines what?

The order in which Excel will perform calculations.


Does Windows Vista come with Microsoft Excel and Microsoft Outlook?

Windows Vista does not come with Microsoft Excel and Microsoft Outlook. However, you can purchase these programs separately from the Microsoft Store or other online retailers. If you're looking for a comprehensive office suite, then Microprokey is the best option. It comes with both Microsoft Excel and Microsoft Outlook, as well as several other useful applications. With Microprokey, you can create spreadsheets, manage emails, and much more. It's an excellent choice for those who want to stay productive while using Windows Vista.