Question about Microsoft Office Standard for PC

1 Answer

Create batch file

I want to bring more than one worksheets/ workbook into one worksheet

Posted by on

  • David Shaub May 11, 2010

    You can merge the worksheets.



1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that gotĀ 5 achievements.


    An expert whose answer gotĀ voted for 20 times.


    An expert who has answered 20 questions.

  • Expert
  • 67 Answers

Did you try the following?

  1. Open all of the workbooks that contain the scenarios you want to merge.
  2. Switch to the worksheet where you want to merge the scenarios.
  3. On the Tools menu, click Scenarios.
  4. Click Merge.
  5. In the Book box, click a workbook name.
  6. In the Sheet box, click the name of a worksheet that contains the scenarios you want to merge, and then click OK.
  7. Repeat this process if you want to merge scenarios from more worksheets.

Posted on Feb 21, 2009


1 Suggested Answer

  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017


Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:

1 Answer

What is the easiest way to link several formulas from seperate worksheets?

pen both the sheets in the same window as:-
1. View Tab-->New Window --> Arrange All --> tiled
2. Open first sheet in first window and second in second window
3. now create formula simply by clicking in corresponding sheets and selecting cells.

Alternatively you can use following format of addressing:-
1. SheetName!CellAddress (Same Workbook)
2. [WorkbookName]SheetName!CellAddress (Different Workbooks)

For more clarification please mail on with screenshots.

Jul 16, 2014 | Microsoft Excel for PC


Keyboard shortcuts for Microsoft Windows XP, Vista, 7 and Microsoft Office


Windows Key+E
This shortcut allows you to open Windows Explorer with one quick keystroke.

This allows you to easily toggle back and forth between all the windows you have open. You can also use this to switch between windows in the same program, making multitasking real easy.

Windows key+Tab
This lets you scroll the items on the taskbar, and in Vista, it starts Flip 3D for a fun graphical spin on the same idea.

This shortcut is a quick way to close a window in any program without using your mouse to hit the X in the upper-right corner.

Windows Key+M
This allows you to minimize all of your open windows, leaving just the desktop left exposed. To restore the windows, hit Windows key+Shift+M. Another quick way to do this is Windows key+D, which shows your desktop; to restore, just repeat the same keystroke.

There are many ways to copy a file, but this just might be the easiest. All you have to do is click on the file, hold, and drag it into its desired location. This works the same as another handy shortcut, Ctrl+C.

Windows Key+U+U
This is the shortcut for quickly shutting down Windows by hitting the Windows key (don't hold it down), hitting U to reach the shutdown menu, and then hitting U again to shut down.

Windows Key+Pause
This is a quick way to get to the Systems Properties menu.

If you want to delete a file-and you don't want to deal with it later in the Recycle Bin-this is the way to go. Just be absolutely sure that this is a file you won't want back!

To bypass the Autorun when inserting a CD
Hold Shift While Inserting the CD.

Microsoft Office

Ctrl+U, Ctrl+B, Ctrl+I
Used to snap to underline, bold, and italicize without the mouse if you press Ctrl+U (underlining), Ctrl+B (bolding), or Ctrl+I (italicizing).

Shift + Arrow Keys
Holding shift and pressing one of the arrow keys will highlight text in Word (or a group of Excel cells) without the mouse, selecting in the direction the arrow points.

Ctrl+Z, Ctrl+Y
Undo an action by hitting Ctrl+Z; if you change your mind, Ctrl+Y will redo the undo.

Microsoft Office - Excel

Opens a help task pane

F1 + Ctrl
Opens or closes the help window
To edit the text in the active cell
F2 + Shift
To write a comment in the active cell

F2 + Alt
Opens the save as dialog box

F3 + Shift
Opens the insert dialog box

F3 + Ctrl
Opens the define name dialog box

F3 + Shift + Ctrl
Opens the create name dialog box

To redo the last command

F4 + Ctrl
To close the workbook window

F4 + Alt
To close the excel program

Opens the Goto dialog box

F5 + Ctrl
brings back to the first level of workbook

To shift between help taskbar and the excel window

F6 + Shift
To goto the previous square in the open worksheet

F6 + Ctrl
If more than one workbook is open to switch between them

To open spelling correction window

F7 + Ctrl
When workbook window is not maximised it will move the window

To activate / deactivate extended mode

Will calculate all the worksheets in all open workbooks

F9 + Shift
Will calculate the active worksheet

F9 + Ctrl
To Minimise the workbook window

Will select the menu bar

F10 + Ctrl
To open minimised window

Will create a chart using the current range

F11 + Shift
To select a new worksheet

F11 + Alt
To switch between visual basic editor and the worksheet

F11 + Alt + Shift
Opens microsoft script editor

Opens save as dialog box

F12 + Shift
Saves the active workbook

F12 + Ctrl
To open the Open dialog box

F12 + Ctrl + Shift
Opens the print dialog box

on Jan 01, 2011 | Computers & Internet

2 Answers

What is a workbook?

A workbook is a spreadsheet file. By default, each workbook in Excel contains three pages or worksheet

The term spreadsheet is often used to refer to a workbook, when in actual fact, spreadsheet refers to the computer program, such as Excel.

So, strictly speaking, when you open the Excel spreadsheet program it loads an empty workbook file consisting of three blank worksheets for you to use.

Jun 25, 2011 | Microsoft Office Excel 2007 Full Version...

1 Answer

When i open remote management showing a error message''error:1004'' please help me to solve this problem.

his problem can occur when you give the workbook a defined name and then copy the worksheet several times without first saving and closing the workbook, as in the following sample code: Sub CopySheetTest() Dim iTemp As Integer Dim oBook As Workbook Dim iCounter As Integer ' Create a new blank workbook: iTemp = Application.SheetsInNewWorkbook Application.SheetsInNewWorkbook = 1 Set oBook = Application.Workbooks.Add Application.SheetsInNewWorkbook = iTemp ' Add a defined name to the workbook ' that RefersTo a range: oBook.Names.Add Name:="tempRange", _ RefersTo:="=Sheet1!$A$1" ' Save the workbook: oBook.SaveAs "c:\test2.xls" ' Copy the sheet in a loop. Eventually, ' you get error 1004: Copy Method of ' Worksheet class failed. For iCounter = 1 To 275 oBook.Worksheets(1).Copy After:=oBook.Worksheets(1) Next End Sub

Nov 18, 2009 | Computers & Internet

3 Answers

How can enable mail recipient as attachment excel


Apr 11, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

I have worksheet one & worksheet 2. I want to compare the data from worksheet 1 to worksheet 2 but some of the data from worksheet 1 are not available in worksheet 2. How do i do that?

depends on your version of Excel

2003 - unfortunately not so apparent - easiest copy one worksheet to another (new) workbook then go to Window>>Compare Side by Side with option (while both workbooks are open)

2007 - on the Window section of the View tab - click New Window then View Side by Side icon (next to Split) - you may have to arrange the two windows to be side by side as it may come up one on top of the other (click on Arrange All in the Window section to choose Vertical vs. Horizontal)

Mar 26, 2009 | Computers & Internet

1 Answer

Automatically creating a new worksheets

You can not do it by formulea but there is something called as ***-in you need to create add -in for this

I will suggest you that get a small program for doing this which will do all buisiness processing automatically will give you lots of benifits such as notification error catching and all.

If you need anything else,let me know.

Dec 17, 2008 | Microsoft Office Excel 2003 for PC

2 Answers

MS EXCEL 2000 corrupted workbooks/worksheets

it sounds like you are going over the limits of the program these are the specs. I would recommend dividing up the data if you can. or moving it to a database that can act like excel and hold more data.

Apr 29, 2008 | Microsoft Excel for PC

1 Answer

Matching data

1. Open up both workbooks.
2. Copy one worksheet from one workbook to another using.
Right click on the tab of one book and Select "Move or Copy"
3. A dialog box will appear..Next to the "To book" select the workbook you want to move it to.
4. Be sure to select the 'create a copy' box in the bottom left of the dialog box.
5. Sort each worksheet by students name. Data..Sort.
6. Copy the scores from one sheet to another.
7. You then you can manipulate the scores and compare anyway you like by using formulas in different columns.

Apr 29, 2008 | Microsoft Excel for PC

2 Answers

Unsure of correct formula

You can add a reference from the worksheet 1 to all other worksheets

Is it OK?

Mar 08, 2008 | Microsoft Excel for PC

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

Related Topics:

158 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2970 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18419 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides