Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
Some columns went missing...
Perhaps their column widths have been set to zero..........
Vaya con Dios, Chuck, CABGx3 "xosder" wrote in message ... 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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging two columns and keeping the data from both | Excel Worksheet Functions | |||
Adding columns w/new formulas BUT keeping subtotals | Excel Discussion (Misc queries) | |||
Inserting and Tracking Missing Sequence | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) |