Forum Discussion
Mantener el formato de tabla en cuanto a tamaño y posición del texto al ingresar nuevos datos
Estimados, tengo una tabla que contiene una base de datos y requiero que al ingresar nuevos datos estos mantengan su formato.
Los que se encuentran en verde son nuevos datos y no se mantiene el formato de las celdas según el alto y ancho de la tabla.
Quedo atento, gracias!
I hope in advance that I understood the problem correctly.
You want to have the same column width and row height in the desired area (or worksheet) ...
Without knowing the Ecel version and the operating system it is difficult to propose a solution.
Recommend reading this link in advance ... for next time 🙂
Welcome to your Excel discussion space!At the same time, I will try to give you a few suggestions for a solution.
One possibility would be to hide the rows and columns of the grid lines, then they cannot be changed.
Fade out or stain white with cell formatting.
Show or hide gridlines on a worksheetOr via VBA if this is possible in your office.
Option Explicit Sub row_column() Rows("1:30").RowHeight = 12 Columns("A:Z").ColumnWidth = 15 End SubExample file inserted.
Hope I could help you with these information / file.
NikolinoDE
I know I don't know anything (Socrates)
1 Reply
- NikolinoDEPlatinum Contributor
I hope in advance that I understood the problem correctly.
You want to have the same column width and row height in the desired area (or worksheet) ...
Without knowing the Ecel version and the operating system it is difficult to propose a solution.
Recommend reading this link in advance ... for next time 🙂
Welcome to your Excel discussion space!At the same time, I will try to give you a few suggestions for a solution.
One possibility would be to hide the rows and columns of the grid lines, then they cannot be changed.
Fade out or stain white with cell formatting.
Show or hide gridlines on a worksheetOr via VBA if this is possible in your office.
Option Explicit Sub row_column() Rows("1:30").RowHeight = 12 Columns("A:Z").ColumnWidth = 15 End SubExample file inserted.
Hope I could help you with these information / file.
NikolinoDE
I know I don't know anything (Socrates)