LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 145
Default .csv Format, Hidden Columns, 2007

I had to get someone to give me a copy of 2003 and found that yes, the hidden
columns are included.

I've noticed other posts that recommend a way to eliminate the hidden
columns when copying/pasting, but not when doing a Save As .csv. Here are
the recommendations for copy/paste (below). Anything similar for Save As?

Two stages

Edit, Goto, Special, Current Region

Edit, Goto, Special, Visible

Then copy and paste as normal.




"David Biddulph" wrote:

Are you sure? With my Excel 2003, the hidden columns *are* included in the
csv.
--
David Biddulph

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.




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Column Da Tammy Excel Discussion (Misc queries) 3 April 2nd 09 11:40 PM
Copy and Paste with hidden columns remaining hidden Pendelfin Excel Discussion (Misc queries) 2 February 26th 09 11:35 AM
2007: xlsm format holds how many columns? Zahra Excel Discussion (Misc queries) 4 February 6th 09 12:27 AM
Hidden rows columns won't stay hidden christie Excel Worksheet Functions 0 September 30th 08 05:44 PM
Hidden Columns No Longer Hidden after Copying Worksheet? EV Nelson Excel Discussion (Misc queries) 1 December 6th 06 05:10 PM


All times are GMT +1. The time now is 03:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"