How do I unhide all cells?



How do I unhide all cells?..

Answer / Krishna Kumar Singh

To unhide all hidden cells in Excel, go to the 'Formulas' tab on the ribbon at the top of the screen. Click on 'Function Library', then choose 'Name Manager'. In the Name Manager dialog box, select the 'Filter' dropdown menu at the top and choose 'Show Hidden Names'. After that, click 'Close'. Then, go to 'View' tab and uncheck 'Hidden Cells' and 'Hidden Rows'.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

How do you keep a cell value constant in excel?

1 Answers  


How do I get rid of unwanted text in excel?

1 Answers  


I have a list of 3215 product names on a spreadsheet. Each resides in a single cell. I need to put each name in quotes. The names are all in one column?

1 Answers  


What is a scenario model?

1 Answers  


What are functions how functions are used in excel?

1 Answers  


Can you do a vlookup with two conditions?

1 Answers  


What is excel introduction?

1 Answers  


How do you truncate in excel?

1 Answers  


What are spreadsheets mainly used for?

1 Answers  


What do brackets mean in excel?

1 Answers  


How do you use countifs in excel?

1 Answers  


What does the red triangle indicate at the top right hand corner of the cell?

1 Answers  


Categories