How to maintain formula while using Merge and Centre command

		Microsoft Office Forums > Microsoft Excel > Excel
How to maintain formula while using Merge and Centre command

FAQ

Thread Tools

Display Modes

04-11-2016, 07:02 PM

Aditya M

Windows 7 32bit How to maintain formula while using Merge and Centre command

Office 2010 32bit

Novice

Join Date: Mar 2016

Posts: 5

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.

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:16 AM.