csv format

C

ctrimh

1.
I have a csv file and I see it on one computer with comma delimiter
and on the other I see it like a normal excell file. How can I chang
it to see it like a normal excel file?


2.
How are bookmarks used in excel
 
D

Dick Kusleika

1.
I have a csv file and I see it on one computer with comma delimiters
and on the other I see it like a normal excell file. How can I change
it to see it like a normal excel file?
Click to expand...

I think you have to change the file association. From a Windows Explorer
window, choose View>Folder Options. On the File Types tab, I have an entry
called Microsoft Excel Comma Separated which links CSV extensions to Excel.
Excel should do that automatically when it installs, but maybe someone
changed it.
2.
How are bookmarks used in excel?
Click to expand...

There are no bookmarks in Excel. Because the spreadsheets are a bunch of
cells, each cell address (e.g. A1) is a "bookmark" to that cell. Excel has
defined names (Insert>Name>Define) where you can name a cell (or range of
cells) with another name.
 
Top