View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lauranator Lauranator is offline
external usenet poster
 
Posts: 4
Default Problems with Specific Worksheet

Hello,
I have an Excel file that has multiple worksheets. One of the worksheets
(not the others) has two problems that I cannot resolve.

1) In Page Layout view, when I click on one cell, it automatically also
selects the cell to the right of it. So basically clicking on one cell
selects those two cells. Very annoying, esp for copy/paste tasks.

2) When I attempt to freeze the top row, this option isn't available to me..
the option to do this in the ribbon is greyed out. I can do this no problem
in other worksheets, just not this particular one.

Any suggestions as to what is causing these problems and how to resolve?
I really hope I don't have to delete the worksheet and start over as that
would involve ALOT of work.

--
Thank You
--Laura - MS Office 2007 Professional user on Windows XP - SP3