Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-24-2018, 06:04 AM
LindaS LindaS is offline Hide table rows Mac OS X Hide table rows Office 2001 for Mac
Novice
Hide table rows
 
Join Date: May 2018
Location: Toronto
Posts: 6
LindaS is on a distinguished road
Default Hide table rows


Can I hide table rows in a source document? I have a table with 200 rows and only work with 25 of the rows in 6 months. Thanks.
Reply With Quote
  #2  
Old 05-24-2018, 03:38 PM
macropod's Avatar
macropod macropod is offline Hide table rows Windows 7 64bit Hide table rows Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You can format the font of the rows you want to hide as hidden, then click on the ¶ symbol on the Document tab to hide the document's formatting marks.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-24-2018, 08:21 PM
LindaS LindaS is offline Hide table rows Mac OS X Hide table rows Office 2001 for Mac
Novice
Hide table rows
 
Join Date: May 2018
Location: Toronto
Posts: 6
LindaS is on a distinguished road
Default

Thanks. It works exactly as you described and I did not know that I could do that. However, what I want is for the rows to be hidden (like in Excel), so I don't have to scroll through 200 rows to get to where I want to edit. I guess if I have to, I can copy the whole table into Excel and use it there.
Reply With Quote
  #4  
Old 05-24-2018, 09:15 PM
macropod's Avatar
macropod macropod is offline Hide table rows Windows 7 64bit Hide table rows Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Word tables don't offer the same functionality as an Excel workbook, but formatting the entire row as hidden does hide the entire row. As for going to a particular row, pressing Shift-F5 when you open a document (or after making an edit) should return you to the location of the last edit.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 05-24-2018, 09:30 PM
LindaS LindaS is offline Hide table rows Mac OS X Hide table rows Office 2001 for Mac
Novice
Hide table rows
 
Join Date: May 2018
Location: Toronto
Posts: 6
LindaS is on a distinguished road
Default

I formatted the entire row as hidden and it removed (or hid) the contents of the cells but left the rows. I am using Word 2016 for mac. Maybe that's why. Word does act differently on a mac. Thanks for the tip about going to the last changed row. I didn't know that either and it will solve my problem.
Reply With Quote
  #6  
Old 05-24-2018, 10:13 PM
macropod's Avatar
macropod macropod is offline Hide table rows Windows 7 64bit Hide table rows Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by LindaS View Post
I formatted the entire row as hidden and it removed (or hid) the contents of the cells but left the rows.
Did you include the row's 'end-of-row' marker?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 05-24-2018, 10:14 PM
LindaS LindaS is offline Hide table rows Mac OS X Hide table rows Office 2001 for Mac
Novice
Hide table rows
 
Join Date: May 2018
Location: Toronto
Posts: 6
LindaS is on a distinguished road
Default

I don't know what that means. Also, I tried the shift F5 trick and it didn't work. Again it's probably the mac thing.
Reply With Quote
  #8  
Old 05-24-2018, 10:18 PM
macropod's Avatar
macropod macropod is offline Hide table rows Windows 7 64bit Hide table rows Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

With Word's formatting display on, you'll see a '¤' symbol in each cell and at the end of each row. That is the table's end-of-cell marker & end-of-row marker. You need to ensure the one at the end of each row is also formatted appropriately.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 05-24-2018, 10:27 PM
LindaS LindaS is offline Hide table rows Mac OS X Hide table rows Office 2001 for Mac
Novice
Hide table rows
 
Join Date: May 2018
Location: Toronto
Posts: 6
LindaS is on a distinguished road
Default

I selected everything in both columns in the first 3 rows of my test table, including all markers. I formatted them as hidden and turned off the paragraph markers. The contents disappear but not the rows.
Reply With Quote
  #10  
Old 05-24-2018, 10:32 PM
LindaS LindaS is offline Hide table rows Mac OS X Hide table rows Office 2001 for Mac
Novice
Hide table rows
 
Join Date: May 2018
Location: Toronto
Posts: 6
LindaS is on a distinguished road
Default

OK... it works now. I missed the end of row markers.
Thanks for your patience and help.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide table rows How to hide rows that have no data but has formula in cells? LearnerExcel Excel Programming 8 02-13-2018 06:31 AM
Hide table rows Hide / unhide Rows NullVBA Excel Programming 4 12-09-2015 05:10 AM
Hide rows with checkbox gebobs Excel 3 03-24-2015 12:05 PM
Hide Rows YounesB3 Excel 2 10-29-2012 05:40 AM
Temporarily show/hide selected table rows glricht Word Tables 0 12-29-2009 05:40 AM

Other Forums: Access Forums

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