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

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 12:22 PM.