Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-26-2015, 07:57 AM
Suzy Suzy is offline Merged cells - automatically expanding? Windows 8 Merged cells - automatically expanding? Office 2010 64bit
Novice
Merged cells - automatically expanding?
 
Join Date: Aug 2015
Posts: 1
Suzy is on a distinguished road
Default Merged cells - automatically expanding?

I have a spreadsheet with a lot of merged cells. When entering information into those cells, they do not expand even though I've formatted them to wrap. Is there a way to format them so they automatically expand like a single cell does?
Reply With Quote
  #2  
Old 08-26-2015, 09:39 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Merged cells - automatically expanding? Windows 7 64bit Merged cells - automatically expanding? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,779
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi
I"'m afraid merged cells are the worst item form Excel.
Perhaps unmerge, and try "center across selection" after selecting some contiguous cells
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Merged cells - automatically expanding? 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
how to split merged data into vertical saperate cells cheekugreat Excel 5 10-11-2014 05:53 AM
Accidentally merged cells? Fraser Excel 2 02-16-2014 10:15 PM
Merged cells - automatically expanding? Differences in borders at page break in merged cells Sudlav Word Tables 2 05-23-2013 11:50 PM
Merged cells - automatically expanding? Set range for merged Word table cells? tinfanide Word VBA 1 02-06-2012 05:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:22 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