Microsoft Excel for PC - Page 10 - Answered Questions & Fixed issues
I can't open SYLK file
are you trying to open a txt file or a comma-separated variable (CSV) file and i bet the chances of the file name having a capital "I: or "D" are good huh.
To open your file in Excel, open the file in a text editor, and then insert an apostrophe at the beginning of the first line of text.
How to Insert an Apostrophe
To add an apostrophe to the beginning of the first line of text in your file, follow these steps:
1. Open the text file in a text editor, such as Notepad. Click before the first character in the first line of text. Press the APOSTROPHE key on your keyboard (').
2. On the File menu, click Save. Quit the text editor. You can now open the file in Excel.
hope this helps , next time tells us the version of your excel and what operating system you are running.
Mel
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.
MS EXCEL
Click on the space above the first row header and on the left of the first column header. All cells on the sheet are selected now. Ctrl 1 to open the format cells dialog. On the protection tab uncheck locked.
After you do this select the cell you want to lock. Ctrl 1 to open the format cells dialog. On the protection tab check locked.
My product key on the sticker on my relatively new
you will need to call mircosoft excel there should be a toll free number on or in the box.
Tell them your number is invalid when you type it in
They will either fix your number or give you a different number.
I have had this happen a lot on several differant programs
if you can not find the number in the box you can call 18005551212 toll free and ask for their toll free number,if they have one than they will give it to you
Good Luck
Circular reference working how to open excel file
Clicking cancel will invalidate the formulae, circular references refer to the dependant and precedent cells using each other.
Track/ Audit depending on your Excel version to show which formulae is incorrect - or options view, tick show formaulae and remove them.
Formula for cell that is not blank
You can use IF and ISBLANK. Put this formula on Sheet 1 D1:
=IF(ISBLANK(Sheet3!AM2),"x","")
You can replace "x" by any other value you need.
Continueous Printing
The best way is to write a small code in a macro. Basically you change the number in the datavalidation popup and print it automatically. If you want I can write you the code, but i will need the worksheet. Write me to
[email protected]
Hello,
There are two ways to solve it, with a macro and without.
In either way, the concept is to determine the difference between rows, if it is more than 1 hour, then you have detected the missing row.
With a formula, you can tell excel to put true if it is the case and correct it manually.
For a macro, basically you detect the same thing and then insert a line with all the appropiate information. I can write the code for you, but i would prefer to have the sheet. You can send me the information to my mail
[email protected]
Not finding what you are looking for?