Moving cells in the Excel table is not allowed!
yvanlaigle
Posted messages
4
Status
Membre
-
yvanlaigle Posted messages 4 Status Membre -
yvanlaigle Posted messages 4 Status Membre -
Hello,
I have a problem that might be interesting to raise.
I created a table in Excel (by selecting my cells beforehand) with "insert", "table".
This allows me, when I right-click on the margins ABCD.. or 1234.., to "insert a row" and automatically copy all the formulas present in the row above, thus having a clean table without bad surprises (formula modifications or gaps).
In short, it's great.
Then, while doing my stuff, I wanted to change the order of my table (move an entire row a few lines higher).
So I cut in the margin 123.., then "insert cut cells".
But an error message appears: "Moving cells within the table is not allowed."
As a result, I constantly have to click "create", "convert to range" to be able to cut/paste or copy/paste.
Therefore, I ask for your help to shed light on solutions that would save time without having to convert to range all the time (and also to provide simplicity for the operators who need to use my table).
Hoping for a response to my issue,
Best regards,
I have a problem that might be interesting to raise.
I created a table in Excel (by selecting my cells beforehand) with "insert", "table".
This allows me, when I right-click on the margins ABCD.. or 1234.., to "insert a row" and automatically copy all the formulas present in the row above, thus having a clean table without bad surprises (formula modifications or gaps).
In short, it's great.
Then, while doing my stuff, I wanted to change the order of my table (move an entire row a few lines higher).
So I cut in the margin 123.., then "insert cut cells".
But an error message appears: "Moving cells within the table is not allowed."
As a result, I constantly have to click "create", "convert to range" to be able to cut/paste or copy/paste.
Therefore, I ask for your help to shed light on solutions that would save time without having to convert to range all the time (and also to provide simplicity for the operators who need to use my table).
Hoping for a response to my issue,
Best regards,