Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page hidden rows hidden rows
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 01-18-2012, 12:09 AM
gsrikanth gsrikanth is offline hidden rows Windows XP hidden rows Office XP
Competent Performer
hidden rows 		 
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default hidden rows
in the column 1/2 is there i keeping filter to that column, i selecting 1/2 in the column



how to get 1/2 value top two rows
that was hidden

each time i use to double cilck on row number

it can generate automatically
Reply With Quote
  #2  
Old 01-18-2012, 02:45 PM
tupham tupham is offline hidden rows Windows XP hidden rows Office 2007
Advanced Beginner
  
Join Date: Aug 2008
Posts: 57
tupham is on a distinguished road
Default
Click on the button at the very top left corner of your worksheet - see attachment. Then right click and click Unhide. This should display all hidden rows and columns.
Attached Files
File Type: pdf junk.pdf (112.1 KB, 11 views)
Reply With Quote
  #3  
Old 01-18-2012, 09:50 PM
gsrikanth gsrikanth is offline hidden rows Windows XP hidden rows Office XP
Competent Performer
hidden rows 		 
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default
Quote:
Originally Posted by tupham View Post
Click on the button at the very top left corner of your worksheet - see attachment. Then right click and click Unhide. This should display all hidden rows and columns.
boo1.xls attachment now you do
Attached Files
File Type: xlsx Book1.xlsx (8.4 KB, 9 views)
Reply With Quote
  #4  
Old 01-18-2012, 10:12 PM
tupham tupham is offline hidden rows Windows XP hidden rows Office 2007
Advanced Beginner
  
Join Date: Aug 2008
Posts: 57
tupham is on a distinguished road
Default
My suggestion doesn't work because the rows are hidden by a filter. You need to click on the filter and select Clear Filter to see the rows.
Reply With Quote
  #5  
Old 01-18-2012, 11:57 PM
gsrikanth gsrikanth is offline hidden rows Windows XP hidden rows Office XP
Competent Performer
hidden rows 		 
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default
Quote:
Originally Posted by tupham View Post
My suggestion doesn't work because the rows are hidden by a filter. You need to click on the filter and select Clear Filter to see the rows.
hidden row but one i need to view
Reply With Quote
  #6  
Old 01-19-2012, 02:40 PM
tupham tupham is offline hidden rows Windows XP hidden rows Office 2007
Advanced Beginner
  
Join Date: Aug 2008
Posts: 57
tupham is on a distinguished road
Default
Quote:
Originally Posted by gsrikanth View Post
hidden row but one i need to view
I'm sorry but I don't understand what you are asking for.
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
hidden rows merging rows and creating sub-rows gib65 Excel 2 12-09-2011 02:09 PM
hidden rows Hidden tables? dluhop Word Tables 1 09-04-2011 02:41 AM
hidden rows Hidden style applied over already-hidden text. christie Word 1 08-17-2011 09:10 AM
Hidden address nicolapiva Outlook 2 11-16-2010 12:12 AM
hidden rows Hidden Info in Document freschij Word 1 06-11-2010 12:35 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:46 PM.

Contact Us - Privacy Statement - Top

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