Hello everyone,
I have a problem using the option "columns to repeat at left".
I have a table that goes through multiple pages. I want to repeat columns A:D on all columns, as these are my "headers" for columns.
I go to Page Layout, Page Setup, Rows To Repeat : $A:$D.
This works fine, I can see the columns A:D repeat on every page.
My problems happens when I want to modify the content of the cells.
If I double click on the cell, I can modify the content with no problem.
Buf if I click on the cell, and modify the content via the Formula Bar, the whole screen becomes grey, and I have to close then re-open the worksheet to try again.
Anyone has an idea of what is happening to me ?
Thanks
I have a problem using the option "columns to repeat at left".
I have a table that goes through multiple pages. I want to repeat columns A:D on all columns, as these are my "headers" for columns.
I go to Page Layout, Page Setup, Rows To Repeat : $A:$D.
This works fine, I can see the columns A:D repeat on every page.
My problems happens when I want to modify the content of the cells.
If I double click on the cell, I can modify the content with no problem.
Buf if I click on the cell, and modify the content via the Formula Bar, the whole screen becomes grey, and I have to close then re-open the worksheet to try again.
Anyone has an idea of what is happening to me ?
Thanks
