Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-01-2022, 06:07 PM
Colonel Biggs Colonel Biggs is offline Trying to reduce cells with two rows to one row Mac OS X Trying to reduce cells with two rows to one row Office 2016 for Mac
Advanced Beginner
Trying to reduce cells with two rows to one row
 
Join Date: Jul 2010
Posts: 54
Colonel Biggs is on a distinguished road
Default

Please excuse the delay; I injured my back shortly after making the post, which put me out for a few days.

My spreadsheet that I received had column titles in which two rows were shown to take up one cell. Or, the titles took up the entire cell, despite the cell having a height that amounted to two rows.

I finally came upon Format Cells/Alignment/Text Control: uncheck Merge Cells. This did the trick. I was back to being able to use each row to a cell.

Sorry for the confusion. But, I appreciate the responses.
Reply With Quote
  #2  
Old 08-02-2022, 05:30 AM
kilroyscarnival kilroyscarnival is offline Trying to reduce cells with two rows to one row Windows 10 Trying to reduce cells with two rows to one row Office 2021
Expert
 
Join Date: May 2019
Posts: 363
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

Quote:
Originally Posted by Colonel Biggs View Post
Please excuse the delay; I injured my back shortly after making the post, which put me out for a few days.

My spreadsheet that I received had column titles in which two rows were shown to take up one cell. Or, the titles took up the entire cell, despite the cell having a height that amounted to two rows.

I finally came upon Format Cells/Alignment/Text Control: uncheck Merge Cells. This did the trick. I was back to being able to use each row to a cell.

Sorry for the confusion. But, I appreciate the responses.
Ah, your problem was even more straightforward than I guessed. Funny thing is, shortly afterward, I found myself tackling a similar spreadsheet which has items on two rows instead of one. Glad you worked it out.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Trying to reduce cells with two rows to one row How to hide rows that have no data but has formula in cells? LearnerExcel Excel Programming 8 02-13-2018 06:31 AM
Split data in cells and duplicate rows ballpoint Excel Programming 6 02-07-2018 05:52 PM
Trying to reduce cells with two rows to one row Deleting rows based on the text in certain cells VBA ThisGuyJohn Excel Programming 5 02-03-2017 03:16 PM
VBA merging cells and counting Merged rows Snaybot Excel Programming 2 11-09-2015 03:56 AM
How to make rows or cells shift down automatically rfrontz Excel 1 04-16-2013 03:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:31 AM.


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