Home

Excell 2016

%3CLINGO-SUB%20id%3D%22lingo-sub-478112%22%20slang%3D%22en-US%22%3EExcell%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-478112%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20finding%20this%20very%20frustrating%2C%20I%20open%20Excel%2C%20New%20workbook%2C%20no%20protection%2C%20no%20sharing.%3C%2FP%3E%3CP%3EI%20start%20making%20my%20sheet%20with%20every%20second%20row%20elongated%20vertically%20to%20the%20height%20of%20two%20cells%2C%20no%20problem.%20Then%20Horizontally%20I%20want%20to%20merge%20certain%20cells%20into%20one%20bigger%20one.%20The%20first%20row%20I%20merge%204%20cells%20into%20one%20big%20one%2C%20when%20I%20try%20to%20do%20the%20same%20thing%20on%20another%20row%20nothing%20happens.%3C%2FP%3E%3CP%3EI%20have%20tried%20%22Merge%20%26amp%3B%20Centre%22%20%22Merge%20Across%22%20%26amp%3B%20just%20%22Merge%20Cells%22%20but%20after%20the%20first%20row%20nothing%20happens.%20I%20need%20to%20print%20the%20grid%20lines%20and%20the%20boxes%20of%20differing%20sizes.%3C%2FP%3E%3CP%3EI%20am%20only%20a%20basic%20user%20of%20excel%2C%20although%20I%20can%20do%20much%20more%20in%20word.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-478112%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-478143%22%20slang%3D%22en-US%22%3ERe%3A%20Excell%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-478143%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F324556%22%20target%3D%22_blank%22%3E%40Micro_Merv%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20just%20replicated%20your%20query%20and%20found%20the%20easiest%20option%20after%20creating%20the%20first%20row%2C%20whereby%20you%20have%20your%20row%20height%20and%20column%20widths%20configured%20as%20you%20want%20them.%20%26nbsp%3BI%20merged%20four%20cells%20horizontally%20then%20copied%20that%20merged%20cell%20into%20what%20would%20be%20the%20first%20cell%20of%20unmerged%20cells%20in%20the%20required%20rows.%20%26nbsp%3BThis%20then%20transformed%20four%20adjoining%20cells%20into%20one%20merged%20cell.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EApologies%20if%20you%20have%20tried%20this%20already.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F324557%22%20target%3D%22_blank%22%3E%40DickScrongle%3C%2FA%3E.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-478178%22%20slang%3D%22en-US%22%3ERe%3A%20Excell%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-478178%22%20slang%3D%22en-US%22%3E%3CP%3EYes%20!%20That%20worked%20to%20some%20extent%2C%20but%20only%20when%20you%20want%20to%20create%20the%20same%20size%20box%2C%20as%20mine%20are%20different%20on%20various%20lines%20it%20then%20does%20not%20work.%3C%2FP%3E%3CP%3EBut%20!%20here%20is%20the%20anomaly%20I%20then%20merged%20the%20other%20boxes%20I%20wanted%20to%20make%20and%20it%20worked.%3C%2FP%3E%3CP%3EWhat%20I%20really%20need%20is%20it%20to%20work%20every%20time%2C%20and%20it%20seems%20at%20the%20moment%20it%20is%20hit%20and%20miss.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-478202%22%20slang%3D%22en-US%22%3ERe%3A%20Excell%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-478202%22%20slang%3D%22en-US%22%3ETried%20this%20a%20second%20time%20from%20scratch%20and%20I%20can't%20merge%20anything%20right%20from%20the%20off%3C%2FLINGO-BODY%3E
Micro_Merv
New Contributor

I am finding this very frustrating, I open Excel, New workbook, no protection, no sharing.

I start making my sheet with every second row elongated vertically to the height of two cells, no problem. Then Horizontally I want to merge certain cells into one bigger one. The first row I merge 4 cells into one big one, when I try to do the same thing on another row nothing happens.

I have tried "Merge & Centre" "Merge Across" & just "Merge Cells" but after the first row nothing happens. I need to print the grid lines and the boxes of differing sizes.

I am only a basic user of excel, although I can do much more in word.

3 Replies

Hello @Micro_Merv

 

I have just replicated your query and found the easiest option after creating the first row, whereby you have your row height and column widths configured as you want them.  I merged four cells horizontally then copied that merged cell into what would be the first cell of unmerged cells in the required rows.  This then transformed four adjoining cells into one merged cell.

 

Apologies if you have tried this already.

 

@DickScrongle. 

Yes ! That worked to some extent, but only when you want to create the same size box, as mine are different on various lines it then does not work.

But ! here is the anomaly I then merged the other boxes I wanted to make and it worked.

What I really need is it to work every time, and it seems at the moment it is hit and miss.

Tried this a second time from scratch and I can't merge anything right from the off
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies