How to open excel sheet in different window? - Microsoft Windows XP Professional

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 [email protected] with screenshots.

On the file menu, go to > Window > Split
You can only split the window once. You can drag/slide the window divider

If you want more than one pane, you can choose "new window" to open another, and another view of the same sheet. You can then use >Tools>Options to select different view options for each of these windows (i.e show grids or not).

Hi enelrah_mel0,

You can create a function called SpellNumber using the Visual Basic Editor in the Microsoft Excel to spell the number.

1. Please Open Microsoft Excel. Then press Alt + F11 to open the Visual Basic Editor.
2. Then, click "Insert" option above the Visual Basic Editor window and select "Module".
3. Then, in the Book1 Module1 (Code) window, paste the below code there. (pasted in the next post separately for your convenience)
   
4. Then, press Alt+Q to close the Visual Basic Editor window.
5. After that, please type the formula " =SpellNumber( * )" in the Excel Sheet and press the Enter Key.
6. Then, save the Excel Sheet.
   

eg: =SpellNumber(A1)

Where A1 is the first cell in the excel sheet.


Good Luck!

Please post back the result and let me know if you require further assistance.

Thanks for using Fixya.

A) Open document > Select edit menu > choose select all > then choose copy from edit menu.
Open new document > edit menu> paste.
Select tools menu> choose options> window opens with options. Select form different tabs the edit tab> make sure that al desired boxes are selected.
Select save tab>choose and mark box>ask about properties
accept or Apply options and close.
Save new document different name. When saving it should ask if you want to save properties> choose not save. Maybe it asks if you want to modify properties> choose yes> select box archive amongst read only, hidden or archive.
If this does not work.
B)There are many 3rd party utilities which claim to reset forgotten word password:
The program that I recommend is the Excel Password Recovery 5.0 It recovers/removes the "Password to Open" and "Password to Edit" for you to view and edit the document freely.
http://www.recoverlostpassword.com/products/excelpasswordrecovery.html

Do you have a CD OR Installation files of office? If yes then run the setup and repair your office installation.

how to remove the excel file security pass word


solution explain tel plz

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

try downloading excel viewer ,,,,on other machine

Try these links you could find out

http://www.vbaexpress.com/kb/getarticle.php?kb_id=706
http://www.computing.net/programming/wwwboard/forum/5902.html