ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to open the hidden cell ? (https://www.excelbanter.com/excel-discussion-misc-queries/125051-how-open-hidden-cell.html)

vh928

how to open the hidden cell ?
 
i see A, B, C, D, E, F then AV, AW.... on the top row

I know there are cells in between, but i can't view it..... how can I see
those cells ??

JLatham

how to open the hidden cell ?
 
Quick way: Click on any row number to highlight the entire row, then choose
Format | Columns | Unhide

To be more specific about it, you could highlight a cell in column F and
drag over to AV and then do same Format | Columns | Hide.

"vh928" wrote:

i see A, B, C, D, E, F then AV, AW.... on the top row

I know there are cells in between, but i can't view it..... how can I see
those cells ??


JLatham

how to open the hidden cell ?
 
Oops - left out an "Un" in the last part of that, as in Unhide. But I think
you probably got the idea?

"vh928" wrote:

i see A, B, C, D, E, F then AV, AW.... on the top row

I know there are cells in between, but i can't view it..... how can I see
those cells ??



All times are GMT +1. The time now is 10:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com