I have a spreadsheet that was saved as a text file from HTML and opened with
excel.  I then use Text to Columns to parse the information into cells.  
However, some lines include a leading non-printing character that screws up
the Text to Columns by moving everything on that line ...

I have created a database which I want to widely distribute, I however want
to prevent any changes to it and importantly to prevent anyone being able to
copy cells into another workbook. I can lock the sheet, create a password to
prevent it being opened or modified (apart from ...

Sometimes the sheet tabs don't show.  I've tried resizing the window, and
sometimes they are there, sometimes not.  I was working on this workbook and
it had tabs.  when I saved and reopened, the tab wasn't visible and I can't
go to other sheets in the workbook.

vlookup is not finding reference numbers from one worksheet to another in
same excel file. I have tried copying formats from lookup column to reference
column in data worksheet. I have made lookup range absolute by using $
prefixes

Okay...I am trying to create a SUMIF statement where the criteria is not
blank. I can't figure out how.  I have tried "<>""".  Is there a NOTBLANK
function like BLANK?  This would be, for example, the formula I would use on
a report sheet in a workbook where I list the daily ...

我是用office 2007 Excel, 不知道按到鍵盤上甚麼地方,我的Excel工作表上欄位原本應為英文字母ABC...,
但卻變成了數字1,2,3....  ,儲存格原本位址應為A1, A2 ...卻變成了R1C1, R2C1....請問有人知道要怎麼改回來嗎??  
這樣我好多事情都不能做....  謝謝!!!

Does anyone have any suggestions on how to determine the value with condition?
Under A column, there is a list of types.
Under B column, there is a list of numbers.
For example

I am using Office 2007 with XP, up until a few days ago everything was fine.
Now I can not use the right mouse button click function in Excel (it works
fine in the other programs). I have also tried another mouse & the touch pad
on the laptop, but the result is the same

How can I check spelling of unlocked cells when I have sheet protection on.

The Find & Replace won't recongnise a code when scanned from the product, but
recognised if it is typed in manually. Please help

I have inherited a worksheet constructed by someone else and need to load
dates in a column of cells.  Unfortunately when a date of "3/17/2008" is
entered into the cell range it displays January 1, 1900.  If the cell range
is formated to "Date Format" it continues to display ...

What are the steps to creating a combination chart?

I need a formula similar to MODE function but instead of numbers only it's
alphanumeric(combination of letters and numbers or sometimes letters only).
The output should be the most frequently reccuring data.

now, this is weird. I did all what you said, (clear print area, select print
area, page break preview etc) but still - it wants to print 22 pages as soon
as I set the "columns to repeat" - when I delete it, it prints 4 pages, only
(how it should be).

Whenever I encounter financial functions, I get totally petrified because I
don't know which function to use for which value.  Is there an easy way to
determine which functions go with which value?  For example, what is the
difference between pmt, ipmt, ppmt?  Also, what do i use ...