Dec 02 2021 05:36 AM
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!
Dec 02 2021 07:12 AM - edited Dec 02 2021 07:15 AM
SolutionI 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 worksheet
Or 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 Sub
Example file inserted.
Hope I could help you with these information / file.
NikolinoDE
I know I don't know anything (Socrates)
Dec 02 2021 07:12 AM - edited Dec 02 2021 07:15 AM
SolutionI 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 worksheet
Or 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 Sub
Example file inserted.
Hope I could help you with these information / file.
NikolinoDE
I know I don't know anything (Socrates)