Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-04-2021, 03:14 PM
zillah zillah is offline Excel how to measure couple of merged cells Windows 7 64bit Excel how to measure couple of merged cells Office 2010 64bit
Advanced Beginner
Excel how to measure couple of merged cells
 
Join Date: Nov 2009
Posts: 34
zillah is on a distinguished road
Default Excel how to measure couple of merged cells

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
Reply With Quote
  #2  
Old 01-05-2021, 12:54 AM
Purfleet Purfleet is offline Excel how to measure couple of merged cells Windows 10 Excel how to measure couple of merged cells Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

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

can you upload a workbook example?
Reply With Quote
  #3  
Old 01-05-2021, 03:21 AM
zillah zillah is offline Excel how to measure couple of merged cells Windows 7 64bit Excel how to measure couple of merged cells Office 2010 64bit
Advanced Beginner
Excel how to measure couple of merged cells
 
Join Date: Nov 2009
Posts: 34
zillah is on a distinguished road
Default

Please check attached file
Thx
Attached Files
File Type: xls PDU legend.xls (27.5 KB, 18 views)
Reply With Quote
  #4  
Old 01-22-2021, 05:57 PM
Artik Artik is offline Excel how to measure couple of merged cells Windows 10 Excel how to measure couple of merged cells Office 2019
Novice
 
Join Date: Jun 2019
Location: Poland
Posts: 4
Artik is on a distinguished road
Default

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

Artik
Reply With Quote
  #5  
Old 01-22-2021, 06:13 PM
zillah zillah is offline Excel how to measure couple of merged cells Windows 7 64bit Excel how to measure couple of merged cells Office 2010 64bit
Advanced Beginner
Excel how to measure couple of merged cells
 
Join Date: Nov 2009
Posts: 34
zillah is on a distinguished road
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel how to measure couple of merged cells Table Row with merged cells andi_bln Word VBA 3 10-15-2020 01:22 AM
Excel how to measure couple of merged cells 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
Excel how to measure couple of merged cells 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:06 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft