copy formulas over merged cells

  • Thread starter Thread starter Narendra Boga
  • Start date Start date
N

Narendra Boga

Hi all,

I have a excel sheet consisting large date with 129 tables and each table
has same pro-forma consisting nearly 150 rows and 22 coumns. And, each table
need common formulas. Between the tables, some merged cells are
there(headings). I wrote a formula in certain cell in table1. I need to
copy that formula in all 129 tables. The columns are same in all tables. If
I copy formula and drag to second table, the merged cells are also selecting.
Please help me to copy the formula in all tables without paste in merged
cells.
 
Hi,

One thing you might try is to unmerge the cells and use center across
selection instead - that is found under Format, Cells, Alignment tab,
Horizontal...
 
Shane,

Thanks very much for this tip. This is something I've overlooked for years.
Will certainly help eliminate the "pasting to merged cells" dilemma.

Cheers
Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sharing workbooks limitations - Merged Cells 12
Formula from a single cell to a merged cell 4
VBA set thick borders around non empty cells in range 0
Need to add text to all cells in excel or merge the text in two ce 1
Automatically color merged cells 1
Merging cells in Pivot tables 1
merging and adding cells 1
Formulas in Merged cells 2

Back
Top