Excel how to measure couple of merged cells

zillah · #1 01-04-2021, 03:14 PM

Hi

I am looking to create a label and I have been doing I merged couple of cells say I2-N2

How can I measure the length of the merged cell (horizontally and vertically ) to see if a label fit in a plastic pouch before printing it ?

Please see attached snapshot

Imgur: The magic of the Internet

Thx

Purfleet · #2 01-05-2021, 12:54 AM

My initital reaction would be to never, ever use merged cells

can you upload a workbook example?

zillah · #3 01-05-2021, 03:21 AM

Please check attached file
Thx

Artik · #4 01-22-2021, 05:57 PM

Draw a rectangle that will exactly cover the label area. On the "Format Shape" tab, you can see the dimensions of this rectangle.

Artik

zillah · #5 01-22-2021, 06:13 PM

Quote:

Draw a rectangle that will exactly cover the label area. On the "Format Shape" tab, you can see the dimensions of this rectangle.

Thx fr this tip

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Table Row with merged cells	andi_bln	Word VBA	3	10-15-2020 01:22 AM
Converting table to text (and back) with carriage returns in cells, split and merged cells	ndajko	Word	5	11-04-2019 07:53 AM
Borders on merged cells also appearing on unwanted adjacent cells	MrsC	Word Tables	2	08-19-2019 09:14 AM
Table will not allow sorting because "cells are merged". I can't find the merged cells.	wendyloooo	Word Tables	1	05-26-2015 01:19 PM
borders disappear from merged cells when pasting from excel	joba	Word	0	09-10-2012 11:35 AM