2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Column Da
I tried with Excel 2003 and 2007 both... both saved the hidden column too.
Workaround...
F5-Special-Select Visible cells only
Copy and paste to another sheet and save that sheet as CSV
"Tammy" wrote:
In 2003 Excel, I could hide columns in a worksheet, save the worksheet as a
.csv and the hidden columns/data did not convert to the .csv file (which is
what I want). In 2007 Excel, I have hidden columns and save the worksheet as
a .csv and the hidden columns/data get converted over, too. Is there
something I can do about this? I don't want the data from the hidden columns
converting to the .csv.
|