View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Randy L Randy L is offline
external usenet poster
 
Posts: 27
Default ON OPENING EXCEL

When you say hidden, do you mean that you have to navigate to
Format|Column|Unhide or do you mean you have to navigate by scrolling back to
column A using the scrollbar?

I interpret it as you are having to scroll back to column A to enter data.
When you save your spreadsheet, it will save in the last view you were
looking. If you are entering data in column T and you save it, when you open
the file, your view will be the last cell that you saved data. When you are
complete with your file and ready to save it, just click on A1, or whatever
cell you want to open to the next time, and then save your work.

If you have to use the menu to actually unhide the column, I have no idea
what is causing that.

"Ruth" wrote:

I have an annoying problem with excel.
I use excel to record deliveries to ourselves.
My first column is date of delivery.
Sometimes when I open excel it shows column B onwards with column A hidden
and I have to navigate to make the column show. This is all very well but
when I am busy I forget and just enter info in the columns shown. Even when
I enter at the end of the line it goes back to column B. So the situation I
get is that I end up with a load of lines without a date in them.
Is there any way I can set Excel to open to show all Columns on opening so
that I don't miss to put any info in?