Forum Discussion

Claudio_Espinoza22's avatar
Claudio_Espinoza22
Copper Contributor
Dec 02, 2021
Solved

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!

  • Claudio_Espinoza22 

    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 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)

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor

    Claudio_Espinoza22 

    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 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)