|
|
#1
04-11-2016, 07:02 PM
|
|||
|
|||
How to maintain formula while using Merge and Centre command
Hello,
I have applied alternate row highlight formula that is =MOD(ROW(),2) but when I use merge and centre vertically that is column wise I am unable to maintain alternate row colors that is white and the color that I have chosen. I get consecutive white or consecutive rows of color that I have chosen.please guide. 
|
|
#2
04-11-2016, 11:25 PM
|
||||
|
||||
|
That is one of the reasons why one should use merging ONLY for cosmetic purposes.
If merged cells contain formula or are referenced by one, they are nothing but trouble. Merging should be avoided
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| centre text | otuatail | Word | 2 | 10-08-2014 06:35 AM |
| how do i get the letter in the centre | rich_cirillo | Word | 3 | 03-09-2014 06:25 PM |
| IF mail merge formula | aaiden | Mail Merge | 3 | 06-05-2013 03:36 PM |
 How to align page to left side instead of centre
|
ghumdinger | Word | 2 | 08-18-2011 10:15 AM |
|
Centre alignment of first two lines
|
billy589 | PowerPoint | 1 | 09-27-2010 05:57 AM |
Windows 7 32bit 
Office 2010 32bit
Linear Mode
