Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Grayed Out Columns
I have a sheet that was generated by the "export" function of a VB program.
I do not have access to that program's code. My worksheet ends at column N. There are no columns to the right, which is all grayed out. I selected the entire sheet and chose "Unhide" to no avail. The sheet is not protected. Is there a way to reveal the remaining columns? The one workaround I have is inserting columns before "N" and then moving it back into place. I'm just wondering if there's a right way to do it. Thanks in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Grayed Out Columns
I have seen spreadsheets that were generated by reporting software
(payroll, I believe) that only had the number of columns that the software was exporting - if that's the case, then they are not hidden at all. This may be a worksheet that has been limited in width during the export; it would still have a capacity of a standard spreadsheet, but would require that more columns be added (as you've done). You could write a macro that added more columns if you needed a certain number. Does it always stop with N? What software is generating the document? On Jan 16, 1:52 pm, Dorci wrote: I have a sheet that was generated by the "export" function of a VB program. I do not have access to that program's code. My worksheet ends at column N. There are no columns to the right, which is all grayed out. I selected the entire sheet and chose "Unhide" to no avail. The sheet is not protected. Is there a way to reveal the remaining columns? The one workaround I have is inserting columns before "N" and then moving it back into place. I'm just wondering if there's a right way to do it. Thanks in advance. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Grayed Out Columns
Edit|goto
type: o1:iv1 then Format|column|unhide or format|column|Width and make it non-zero Dorci wrote: I have a sheet that was generated by the "export" function of a VB program. I do not have access to that program's code. My worksheet ends at column N. There are no columns to the right, which is all grayed out. I selected the entire sheet and chose "Unhide" to no avail. The sheet is not protected. Is there a way to reveal the remaining columns? The one workaround I have is inserting columns before "N" and then moving it back into place. I'm just wondering if there's a right way to do it. Thanks in advance. -- Dave Peterson |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Grayed Out Columns
Cool! The "format|column|Width and make it non-zero" worked! Thanks for all
of your responses. "Dave Peterson" wrote: Edit|goto type: o1:iv1 then Format|column|unhide or format|column|Width and make it non-zero Dorci wrote: I have a sheet that was generated by the "export" function of a VB program. I do not have access to that program's code. My worksheet ends at column N. There are no columns to the right, which is all grayed out. I selected the entire sheet and chose "Unhide" to no avail. The sheet is not protected. Is there a way to reveal the remaining columns? The one workaround I have is inserting columns before "N" and then moving it back into place. I'm just wondering if there's a right way to do it. Thanks in advance. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grayed Out Columns | Excel Discussion (Misc queries) | |||
Toolbars are grayed out | Excel Discussion (Misc queries) | |||
I cannot see some columns and some menu items are grayed out | Excel Discussion (Misc queries) | |||
Columns are cut off and grayed out (can't move any farther) | Excel Discussion (Misc queries) | |||
grayed out | Excel Discussion (Misc queries) |