• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

UNHIDE / HIDE TOP ROWS BASED ON DATA VALIDATION FILE

J

jams

New Member
Dear All,


can please help how to find unhide tops rows applied by data validation option. I could not find the rows which was hidden 1:36.
 
Hi ,


What happens when you do this ?


Click on the top left hand corner of your worksheet , to the left of the column titles , and above the row titles.


Now click on Home -> Format -> Hide & Unhide -> Unhide Rows


Narayan
 
Jams


Firstly, Welcome to the Chandoo.org forums.


Select all the cells with Ctrl A, Ctrl A or select the area to the upper left of where A1 is

Then right click any Row label and Unhide
 
Thank u very much to all of u 4 ur express response, I tried all the way as responded below, but could not succeed when I use Ctrl+A and right click at top right side hide/unhide option is deactivated looks to be rows headers are locked.


please advise.


Regards

Jams
 
Jams


Can you go to the View Ribbon


If Unhide or Unfreeze panes an option

Try those
 
You must log in or register to reply here.
Back
Top