Excel

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3170585%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EExcel%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3170585%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHello%2C%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20am%20hoping%20you%20can%20assist%20me%20with%20adding%20cells%20to%20my%20spreadsheet.%20I%20am%20trying%20to%20add%20columns%20and%20have%20the%20formatting%20transfer%20over%20the%20new%20column%20but%20the%20small%20squares%20keeps%20slitting.%20How%20can%20I%20add%20a%20column%20and%20not%20have%20the%20split%20in%20each%20box%20and%20also%20to%20transfer%20the%20format%20over%20the%20new%20column.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EThan%20k%20you%2C%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EElba%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3170585%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Visitor

Hello, 

 

I am hoping you can assist me with adding cells to my spreadsheet. I am trying to add columns and have the formatting transfer over the new column but the small squares keeps slitting. How can I add a column and not have the split in each box and also to transfer the format over the new column.

 

Than k you,

 

Elba

1 Reply

Hi @elba1970 

 

I do not understand what you mean with "split in each box" and "slitting small squares".

But you could transfer the format from one column to another like this:

1. Select / highlight the column which has the current format that you want to transfer

2. From the Home-Menu, click on the Format Painter icon (the little paint brush on the left side)

3. Then select the new column where you would like to have the format