Microsoft Office Forums

Go Back   Microsoft Office Forums > >

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, 9 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, 7 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

Thread Tools
Display Modes


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 08:55 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