Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert page break & merge text in 2 rows
Hello, I'm an absolute beginner and have 2 things I would like to do on a
worksheet: 1. Insert page break when certain text is found 2. Merge text in 2 rows into the upper row, then delete the lower row (i.e. text part 1 is in row 10 and text part 2 is in row 11, would like to concatenate the 2 rows and have the text display in row 10, then remove row 11) Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert page break & merge text in 2 rows
Hi ka2cil
Click on View / Page Break Select the two rows Click on Format / Cells then the allignment tab and then check the Merge Cells check box and click OK -- DownThePaint Where points are scored and games are won! "ka2cil" wrote: Hello, I'm an absolute beginner and have 2 things I would like to do on a worksheet: 1. Insert page break when certain text is found 2. Merge text in 2 rows into the upper row, then delete the lower row (i.e. text part 1 is in row 10 and text part 2 is in row 11, would like to concatenate the 2 rows and have the text display in row 10, then remove row 11) Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert page break & merge text in 2 rows
Oops, I guess I failed to state that I would like to do this programmatically
b/c I need to loop thru the spreadsheet and repeat the commands depending if I find a certain words/phrase on the spreadsheet. Interesting to get a response from a fellow bball fan :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to insert page break after every 10 rows? | Excel Discussion (Misc queries) | |||
insert page break | Excel Programming | |||
Automatically insert page break every 6 rows in excel doc | Excel Discussion (Misc queries) | |||
Insert Page Break | Excel Discussion (Misc queries) | |||
Copy Rows and insert these rows before a page break | Excel Programming |