LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
ck ck is offline
external usenet poster
 
Posts: 52
Default Insert Row and keep merged cells formatting

I have a spreadsheet with several merged cells in a row. When I insert a new
row, it copies all the formatting of the row above or below into the new row
except that of the merged cells, e.g. the merged cell is once again broken
down into 2 cells. Is there a way that the merged cells can automatically be
copied over to the new row when I insert a row without having to use format
painter, etc.?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting with merged cells Willco3 Excel Discussion (Misc queries) 1 January 30th 08 06:45 PM
Conditional Formatting of Merged Cells Fishman4 Excel Worksheet Functions 7 February 15th 07 12:14 AM
Conditional Formatting Merged Cells Yvonne Excel Worksheet Functions 0 August 28th 06 07:36 PM
Formatting merged cells to have lines. lsu-i-like Excel Discussion (Misc queries) 1 November 17th 05 03:29 PM
Insert Row and Maintain Merged Cells TEAM Excel Discussion (Misc queries) 4 October 14th 05 07:43 PM


All times are GMT +1. The time now is 08:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"