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

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Hot-Shot:

    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

6ya6ya
  • 2 Answers

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

Hi,
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.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

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...

Tip

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


Windows

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

Alt+Tab
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.

Alt+F4
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.

Ctrl+Drag
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.

Shift+Delete
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

F1
Opens a help task pane

F1 + Ctrl
Opens or closes the help window
F2
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

F4
To redo the last command

F4 + Ctrl
To close the workbook window

F4 + Alt
To close the excel program

F5
Opens the Goto dialog box

F5 + Ctrl
brings back to the first level of workbook

F6
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

F7
To open spelling correction window

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

F8
To activate / deactivate extended mode

F9
Will calculate all the worksheets in all open workbooks

F9 + Shift
Will calculate the active worksheet

F9 + Ctrl
To Minimise the workbook window

F10
Will select the menu bar

F10 + Ctrl
To open minimised window

F11
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

F12
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

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


MAIL RECPEINT AS ATTECHMENT OPTION NOT VISIBLE IN MY OFFICE 2003 PROFESSIONAL

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

2 Answers

EXCEL


It is very useful to learn excel shortcut realy i thank you

Sep 26, 2007 | Microsoft Office Standard for PC

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

Related Topics:

156 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

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

Answer questions

Manuals & User Guides

Loading...