Saved Bookmarks
| 1. |
Solve : CSV files in Excel? |
|
Answer» HELLO, I am opening a CSV file in Microsoft Excel using Microsoft 7 OS. As instructed by the file creator, I labeled the columns and then proceeded to widen the columns in order that the data was easier to read. When I CLOSE the program, I click on "file" "save as" "csv" and get this warning. (see attached screenshot). I've tried answering yes and no but after finally saving the file, I lose the changes I made to the column widths, etc. The new column labels are intact. How should I save this file in csv format without losing the changes I make? Also, I would like to scroll down toward the end of the page and still be able to see those column headings placed on the first row of my sheet. Thanks in advance David [recovering disk space, attachment deleted by admin]A "csv" file is, as the name implies, a file consisting of comma separated values. It is a plain text file. It contains just the values and the commas, and no EXTRA data about column widths, or other formatting. To do that you need to save the file as an Excel WORKSHEET. Use the "Save as TYPE" dropdown in the Excel file save dialog to select an Excel spreadsheet or worksheet format. To keep the headings visible while scrolling use the freeze pane feature. http://spreadsheets.about.com/od/excel101/ss/freeze_pane.htm Thanks, I was afraid of that. I use this file to run another app and the csv file data changes daily. This means I would have to update the csv file reformat and save as excel file each time I work with it.....urgggg. What about having the column headings viewable at all times in the saved excel file? ThanksQuote from: johnson094 on August 21, 2013, 11:37:26 AM What about having the column headings viewable at all times in the saved excel file? Read my post again. My bad....thanks for the help.Tip: To quickly adjust column widths, use the technique shown at http://office.microsoft.com/en-us/excel-help/change-the-column-width-and-row-height-HP001216383.aspx#BMchangecolwidth |
|