If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Some columns went missing...
i can't view column's B through D on a spreadsheet of mine. it skips right
from column A to column F. I tried the 'unhide' function to see if they had been hidden (the spreadsheet is accessed and used by multiple people) but it appears that they have not - nothing becomes unhidden when i select the adjacent column then go to formatcolumnunhide. If the columns were deleted, the alphabet wouldn't be broken up like that, right? I have also tried freezing and unfreezing panes... everything. i can't find these colums. any help or advice on how to see them, or figure out where they went would be wonderful. thanks in advance. |
#2
|
|||
|
|||
Some columns went missing...
Try this.
Instead of clicking on the column header, go to the little grey box where the column headers and the row headers meet ( top left corner). Click on it so that it highlights the whole page and then right click on any column header and select unhide. HTH Michael M "xosder" wrote: i can't view column's B through D on a spreadsheet of mine. it skips right from column A to column F. I tried the 'unhide' function to see if they had been hidden (the spreadsheet is accessed and used by multiple people) but it appears that they have not - nothing becomes unhidden when i select the adjacent column then go to formatcolumnunhide. If the columns were deleted, the alphabet wouldn't be broken up like that, right? I have also tried freezing and unfreezing panes... everything. i can't find these colums. any help or advice on how to see them, or figure out where they went would be wonderful. thanks in advance. |
#3
|
|||
|
|||
Some columns went missing...
Perhaps their column widths have been set to zero..........
Vaya con Dios, Chuck, CABGx3 "xosder" wrote in message news i can't view column's B through D on a spreadsheet of mine. it skips right from column A to column F. I tried the 'unhide' function to see if they had been hidden (the spreadsheet is accessed and used by multiple people) but it appears that they have not - nothing becomes unhidden when i select the adjacent column then go to formatcolumnunhide. If the columns were deleted, the alphabet wouldn't be broken up like that, right? I have also tried freezing and unfreezing panes... everything. i can't find these colums. any help or advice on how to see them, or figure out where they went would be wonderful. thanks in advance. |
#4
|
|||
|
|||
Some columns went missing...
i did that, and it worked. Thank you very much!!!
"Michael M" wrote: Try this. Instead of clicking on the column header, go to the little grey box where the column headers and the row headers meet ( top left corner). Click on it so that it highlights the whole page and then right click on any column header and select unhide. HTH Michael M "xosder" wrote: i can't view column's B through D on a spreadsheet of mine. it skips right from column A to column F. I tried the 'unhide' function to see if they had been hidden (the spreadsheet is accessed and used by multiple people) but it appears that they have not - nothing becomes unhidden when i select the adjacent column then go to formatcolumnunhide. If the columns were deleted, the alphabet wouldn't be broken up like that, right? I have also tried freezing and unfreezing panes... everything. i can't find these colums. any help or advice on how to see them, or figure out where they went would be wonderful. thanks in advance. |
#5
|
|||
|
|||
Some columns went missing...
Could be that the columns' width has been set to a small number like 0.1
Select across A:E and FormatColumnWidth8.43 Gord Dibben MS Excel MVP On Mon, 14 Aug 2006 15:24:02 -0700, xosder wrote: i can't view column's B through D on a spreadsheet of mine. it skips right from column A to column F. I tried the 'unhide' function to see if they had been hidden (the spreadsheet is accessed and used by multiple people) but it appears that they have not - nothing becomes unhidden when i select the adjacent column then go to formatcolumnunhide. If the columns were deleted, the alphabet wouldn't be broken up like that, right? I have also tried freezing and unfreezing panes... everything. i can't find these colums. any help or advice on how to see them, or figure out where they went would be wonderful. thanks in advance. |
#6
|
|||
|
|||
Some columns went missing...
Thx Gord... I got my missing columns back from your advice.
"Gord Dibben" wrote: Could be that the columns' width has been set to a small number like 0.1 Select across A:E and FormatColumnWidth8.43 Gord Dibben MS Excel MVP On Mon, 14 Aug 2006 15:24:02 -0700, xosder wrote: i can't view column's B through D on a spreadsheet of mine. it skips right from column A to column F. I tried the 'unhide' function to see if they had been hidden (the spreadsheet is accessed and used by multiple people) but it appears that they have not - nothing becomes unhidden when i select the adjacent column then go to formatcolumnunhide. If the columns were deleted, the alphabet wouldn't be broken up like that, right? I have also tried freezing and unfreezing panes... everything. i can't find these colums. any help or advice on how to see them, or figure out where they went would be wonderful. thanks in advance. |
#7
|
|||
|
|||
Some columns went missing...
They have been mising since Aug 14, 2006?
I wish I had your patience. Gord On Tue, 8 Apr 2008 09:01:02 -0700, Robert wrote: Thx Gord... I got my missing columns back from your advice. "Gord Dibben" wrote: Could be that the columns' width has been set to a small number like 0.1 Select across A:E and FormatColumnWidth8.43 Gord Dibben MS Excel MVP On Mon, 14 Aug 2006 15:24:02 -0700, xosder wrote: i can't view column's B through D on a spreadsheet of mine. it skips right from column A to column F. I tried the 'unhide' function to see if they had been hidden (the spreadsheet is accessed and used by multiple people) but it appears that they have not - nothing becomes unhidden when i select the adjacent column then go to formatcolumnunhide. If the columns were deleted, the alphabet wouldn't be broken up like that, right? I have also tried freezing and unfreezing panes... everything. i can't find these colums. any help or advice on how to see them, or figure out where they went would be wonderful. thanks in advance. |
#8
|
|||
|
|||
Some columns went missing...
"xosder" wrote: i can't view column's B through D on a spreadsheet of mine. it skips right from column A to column F. I tried the 'unhide' function to see if they had been hidden (the spreadsheet is accessed and used by multiple people) but it appears that they have not - nothing becomes unhidden when i select the adjacent column then go to formatcolumnunhide. If the columns were deleted, the alphabet wouldn't be broken up like that, right? I have also tried freezing and unfreezing panes... everything. i can't find these colums. any help or advice on how to see them, or figure out where they went would be wonderful. thanks in advance. |
Thread Tools | |
Display Modes | |
|
|