ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Problems with Specific Worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/246114-problems-specific-worksheet.html)

Lauranator

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


All times are GMT +1. The time now is 03:10 AM.

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