Question about Computers & Internet

1 Answer

In excel i can see 2 sheet side by side by creating new window n arranging all. But i want see 2 sheets when i open the file. Plz find any sollution...

Posted by on

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    New Friend:

    An expert that has 1 follower.

    Mayor:

    An expert whose answer got voted for 2 times.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 5 Answers

Save the arrangement of those sheets by Clicking View->Save Workspace.Now in future, whenever u open the workspace file the arrangement of those will be unchanged.

Posted on Dec 30, 2013

Ad

5 Suggested Answers

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 Technician 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 repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Goodluck!

Posted on Jan 02, 2017

Ad
  • 214 Answers

SOURCE: Forgot password to open Excel sheet

If you mean that you can open the Workbook and read the Worksheet - then all you have to do is select all and paste it to another Worksheet. This will allow for changes of formulas etc.

If you mean the whole Workbook - then I dunno.

In future, either use the same password for everything (easy to remember) or Protect the work with nothing entered into the password field (leave this blank). This last will protect the work from people who try to guess your password, but will be easy for you to remember - eg every password is left blank.

If you must use unique passwords, then keep a record of them somewhere other than on your computer.

Sorry I can't help with the "Workbook" solution - but somebody else out ther may be able to do so.

Posted on Apr 25, 2008

  • 359 Answers

SOURCE: Copying data from one sheet to another if two fileds match

Nope, sorry, although I am truly an expert at Excel formulas, I do not understand what you are trying to end up with in the final cell. We can compare a specified field with two spreadsheets - use named ranges and index/match lookup formulas. But then where you really lose me is in reading "a generic field" to find a match, and then placing what "data from another field" into what "other sheet" - ? See the confusion?

Best way to compare 2 given parameters would be to use a nested if formula, with index/match combo. Here is a simple Excel example of how such a formula could be structured:

Sample Data (columnar arangement):
A1: Part B1: Code C1: Price D1: Find Part E1: Find Code
A2: x B2: 11 C2: 5.00 D2: y E2: 12
A3: x B3: 12 C3: 6.00 D3: y E3: 11
A4: y B4: 11 C4: 7.00 D4: x E4: 12
A5: y B5: 12 C5: 8.00 D5: x E5: 11

To retrieve the price for part y with code 12 and return the value to cell F2, type the following formula in cell F2:
=INDEX($C$2:$C$5,MATCH(D2,IF($B$2:$B$5=E2,$A$2:$A$5),0))

Press CTRL+SHIFT+ENTER to enter the formula as an array formula. The formula returns the value 8.00.

To take this one step further, with range names, this example will find one value at a specified location which matches a specific row header value and column header value. Let's say the range is home values (Range=HomeVal), Column A of HomeVal contains street addresses,"row headers" (Range=StAddress), and Row 1 contains dates of the various values that are in the body of the table, "column headers" (Range=Dates). To return the specific value from the range HomeVal to another sheet, where A1=address specified and A2=date specified:
=INDEX(HomeVal,(MATCH($A$1,StAddress,0)),(MATCH($A$2,Dates,0)))

Then make sure to press CTRL+SHIFT+ENTER to enter the formula as an array formula - if you only hit enter, these types of formulas will not work properly.

Please post back if you need further help, with more details, otherwise thank you for using and rating FixYa!

Posted on Jul 08, 2008

SOURCE: excel locks file when using data connection to other sheet.

excel formula

Posted on Oct 19, 2008

patemi
  • 366 Answers

SOURCE: my excel sheet is not opening

assuming you have Excel sw on your PC.
Assuming you are running XP.
Assuming you can start your Excel and Open any excel file using File/Open within excel.

You must associate Excel file with Excel program in your Windows Explorer.
Fastest way is Browse to any excel file with your Windows explorer (NOT IE)
Right click and select Open with...
Browse to find your Excel MSOffice program
Select Use always to use this program
OK

Posted on Dec 28, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

2 Answers

How do you copy and paste one excel spreadsheet to another making sure the headers are lined up correctly.


right-click the sheet you want to copy, select "copy to", then either select the position within the current document, select annother document (needs to be open in the same excel instance) or select "new document". check the box "copy" to copy, leave unchecked to move.

Jan 01, 2016 | Microsoft Excel Computers & Internet

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 ali_zulfikar@yahoo.com with screenshots.

Jul 16, 2014 | Microsoft Excel for PC

2 Answers

What is exel sheet extension in office 2010 ?


Excel Workbook

.xlsx

The default Excel file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Workbook

.xlsm

Uses the same basic XML format as the Excel Workbook, but can store VBA macro code. Users saving an Excel workbook that has VBA code or Excel 4.0 macro sheets (.xlm files in Excel 4.0) are prompted to use this file format.

Excel Template

.xltx

The default file format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Template

.xltm

Can contain a VBAProject part or Excel 4.0 macro sheets (.xlm files in Excel 4.0). Workbooks created from this template inherit the VBAProject part or Excel 4.0 macro sheets that exist in the template.

Excel Add-In

.xlam

A supplemental program that runs additional code. Excel add-ins use the Open XML file format to store data, and they support using VBA projects and Excel 4.0 macro sheets.

Feb 21, 2011 | Computers & Internet

3 Answers

Export the data from excel to tally


  1. make a sale entry in tally
  2. Export the voucher from tally in xml format (this is to give u how the xml looks)
  3. Open the excel file where all the data is ther.
  4. open a word file, so that we can prepare the xml for mutiple vouchers. For this we will use Mail Merge facility
  5. in the XML which we did in step two, copy the data from "<TALLYMESSAGE xmlns:UDF="TallyUDF">" till the </TALLYMESSAGE>
  6. Now open the word file, go to mail merger, select the fields which needs to be changed, that is the Debtors and the amount (for normal sale entries) which should change for every sale voucher.
  7. create the mail merge.
  8. copy the data what you got in word file to a note pad and name it as sample.
  9. open again the step 2 - copy data from " <ENVELOPE> to <REQUESTDATA>" and paste in the begining of the notepad sample
  10. go the end of the notepad sample and copy the data from first file -"step 2" from " </REQUESTDATA> to </ENVELOPE>" and save the file
  11. Open tally
  12. go to import vocuhers
  13. specify the path of the notepad sample and yes ur data got imported.

Apr 21, 2010 | Microsoft Windows XP Professional

1 Answer

Setup multiple spreadsheet pages


Do you mean to display multiple sheets at the same time? Please check out the solution provided below (this applies to Excel 2003)

1.) To view multiple sheets in the active workbook, click New Window on the Window menu. Switch to the new window, and then click a sheet you want to view. Repeat for each sheet you want to view.

2.) On the Window menu, click Arrange.

3.) Under Arrange, click the option you want.

To view sheets in only the active workbook, select the Windows of active workbook check box.

Apr 12, 2010 | Microsoft Excel for PC

1 Answer

My tally version is Tally 9 Release 1.0, my problum is, how to export my tally data in to excel format. in my tally export option only three option's where occuring that are as follows 1. ASCII 2. HTML and...


whenever you are going to export any tally report into excel then press alt+e then press backspace and the will blink on the status of ascii,html,and xml options popup then choose ascii then choose condensed or deatailed then press enter.then close tally.after closing tally open excel, click file then open then choose c drive where the tally folder is installed then choose all files you see that a notepad is being created then click on it then choose colon semicolon with next and next procedure then it will automatically arrange in excel sheet.

Feb 24, 2010 | Tally T2245 Matrix Printer

1 Answer

Link in excel 2007


right click on any cell then select hyperlink option from the list then a dialog box will appear infront of you
in left hand side pane there is option place in this document click on that then in right hand side pane select sheet 2 or sheet 3 whichever you want...
or if you want to open any other file so use existing file...option

Jul 01, 2009 | Computers & Internet

4 Answers

How to use vlookup in openoffice using different sheets


=VLOOKUP(A2;Sheet1.$A$3:D27;2;0)

The cell I created this formula in was Sheet 3 Cell C9 - to show the different sheets
A2 is the cell I want to look up
Sheet1.A3:D27 is the range of cells that contains the data I want to return, The first column relates directly to cell C9 is Sheet 3. I locked the first cell in my range as I wanted to apply the same formula across other cells hence the $
2 is the number of the column that has the data I want to return, I had a choice in this formula of 4 columns
0 is the value to complete the formula

Feb 11, 2009 | Microsoft Excel for PC

2 Answers

Excel oquestion


how to remove the excel file security pass word


solution explain tel plz

Feb 09, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Creating a report


I assume you are using excel? to get the new sheet auto update try this formula =sheet1!C5 into the new cell in new sheet (eg. sheet2) whenever you update sheet one cell C5 it will automatically appear in new sheet...

Aug 29, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

37 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

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

Answer questions

Manuals & User Guides

Loading...