ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Lost columns (https://www.excelbanter.com/excel-discussion-misc-queries/135758-lost-columns.html)

Brian

Lost columns
 
I was working on an Excel database file for three days, did lots of
modifications and was about ready to finish. It was about 350 lines.
Suddenly I discovered that I lost two columns E & F. I didn't do anything
with those columns, never touched them, tried unhide in format, but couldn't
retrieve those columns. This is very serious. Three days of my hard labour
lost. Am I going to lose my trust in Excel? There's no help on this anywhere.
Please help. I have checked answers from others, about width zero or below
zero and how to correect. But it doesn't help. This requies help from
Microsoft itself. Are you reading this? Can you help?

dlw

Lost columns
 
If the columns go from D right to G, it REALLY sounds like they are hidden.
How exactly did you try to unhide them?

"Brian" wrote:

I was working on an Excel database file for three days, did lots of
modifications and was about ready to finish. It was about 350 lines.
Suddenly I discovered that I lost two columns E & F. I didn't do anything
with those columns, never touched them, tried unhide in format, but couldn't
retrieve those columns. This is very serious. Three days of my hard labour
lost. Am I going to lose my trust in Excel? There's no help on this anywhere.
Please help. I have checked answers from others, about width zero or below
zero and how to correect. But it doesn't help. This requies help from
Microsoft itself. Are you reading this? Can you help?


Brian

Lost columns
 
I highlighted columns C to H, selected formatcolumnsunhide. Nothing
happened.

Is there any other way? Thanks for your respnse.

"dlw" wrote:

If the columns go from D right to G, it REALLY sounds like they are hidden.
How exactly did you try to unhide them?

"Brian" wrote:

I was working on an Excel database file for three days, did lots of
modifications and was about ready to finish. It was about 350 lines.
Suddenly I discovered that I lost two columns E & F. I didn't do anything
with those columns, never touched them, tried unhide in format, but couldn't
retrieve those columns. This is very serious. Three days of my hard labour
lost. Am I going to lose my trust in Excel? There's no help on this anywhere.
Please help. I have checked answers from others, about width zero or below
zero and how to correect. But it doesn't help. This requies help from
Microsoft itself. Are you reading this? Can you help?


Sandy Mann

Lost columns
 
Coult it be that the columns are just very narrow? - Say a width of 0.01 or
something like that.

Try highlighting columns C:H and then setting the column width to 8.43

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Brian" wrote in message
...
I highlighted columns C to H, selected formatcolumnsunhide. Nothing
happened.

Is there any other way? Thanks for your respnse.

"dlw" wrote:

If the columns go from D right to G, it REALLY sounds like they are
hidden.
How exactly did you try to unhide them?

"Brian" wrote:

I was working on an Excel database file for three days, did lots of
modifications and was about ready to finish. It was about 350 lines.
Suddenly I discovered that I lost two columns E & F. I didn't do
anything
with those columns, never touched them, tried unhide in format, but
couldn't
retrieve those columns. This is very serious. Three days of my hard
labour
lost. Am I going to lose my trust in Excel? There's no help on this
anywhere.
Please help. I have checked answers from others, about width zero or
below
zero and how to correect. But it doesn't help. This requies help from
Microsoft itself. Are you reading this? Can you help?





All times are GMT +1. The time now is 06:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com