Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() I'm currently working with a lot of comma separated value (.CSV) files. Whenever these files are opened in Excel (2000), since all size information is not present, each cell is given the same tiny size. What I need is either 1. An option that says "automatically fit cell sizes to contents upon file opening", or 2. A method of fitting cell sizes to contents that is quicker and less tedious than double-clicking at the top of each column (since there are 40 or so columns in each spreadsheet). Before you ask, no I can't just save the files in .XLS format, they need to stay as .CSV files for compatibility with other software. Do either of my options exist? Thanks in advance for your response, Richie. -- cornelius1729 ------------------------------------------------------------------------ cornelius1729's Profile: http://www.excelforum.com/member.php...o&userid=36749 View this thread: http://www.excelforum.com/showthread...hreadid=564690 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Hi To autofit any column I usually but this code in: Open your excel spreadsheet. Go to Tools Macros Visual Basic Editor (or you can just press Alt + F11) On the left side is the Project Explorer. You should see something with the name VBAProject (Name of your excel file) Click it if it is not expanded already, and double click on Sheet1 (or the name of your worksheet). Put the code in the box that pops up. Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False ActiveSheet.UsedRange.Select Selection.Columns.AutoFit Application.EnableEvents = False Range("a1").Select Application.EnableEvents = True End Sub -- jetted ------------------------------------------------------------------------ jetted's Profile: http://www.excelforum.com/member.php...o&userid=17532 View this thread: http://www.excelforum.com/showthread...hreadid=564690 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Thanks jetted, The code works great, though it needed to be a personal macro, rather than one for that worksheet, so I can use it on all the spreadsheets. Richie. -- cornelius1729 ------------------------------------------------------------------------ cornelius1729's Profile: http://www.excelforum.com/member.php...o&userid=36749 View this thread: http://www.excelforum.com/showthread...hreadid=564690 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I wouldn't bother with a macro.
I'd import the data Select all the cells (click on that grey box to the left of the column headers and above the row headers) and then adjust all the columns at once by double clicking on any of those column separator lines. Ctrl-A (a few times, depending on your version of excel) is another way to select all the cells. cornelius1729 wrote: I'm currently working with a lot of comma separated value (.CSV) files. Whenever these files are opened in Excel (2000), since all size information is not present, each cell is given the same tiny size. What I need is either 1. An option that says "automatically fit cell sizes to contents upon file opening", or 2. A method of fitting cell sizes to contents that is quicker and less tedious than double-clicking at the top of each column (since there are 40 or so columns in each spreadsheet). Before you ask, no I can't just save the files in .XLS format, they need to stay as .CSV files for compatibility with other software. Do either of my options exist? Thanks in advance for your response, Richie. -- cornelius1729 ------------------------------------------------------------------------ cornelius1729's Profile: http://www.excelforum.com/member.php...o&userid=36749 View this thread: http://www.excelforum.com/showthread...hreadid=564690 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Getting contents of a cell when cell reference is in the sheet | Excel Discussion (Misc queries) | |||
How do I clear the contents of one cell from another cell? | Excel Worksheet Functions | |||
How do I get Excel to automatically enter the contents of a cell . | Excel Discussion (Misc queries) | |||
How do I automatically rename a sheet with the contents of a cell. | Excel Discussion (Misc queries) |