ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how can I find A column when it's hiden? (https://www.excelbanter.com/excel-worksheet-functions/137114-how-can-i-find-column-when-its-hiden.html)

sophie

how can I find A column when it's hiden?
 
A and B column is hiden, I can't find it even use CANCEL HIDE, how can i find
it?

Gary''s Student

how can I find A column when it's hiden?
 
select the entire worksheet and:

Format COlumn Unhide
--
Gary's Student
gsnu200712


"sophie" wrote:

A and B column is hiden, I can't find it even use CANCEL HIDE, how can i find
it?


Beege

how can I find A column when it's hiden?
 
sophie wrote:
A and B column is hiden, I can't find it even use CANCEL HIDE, how can i find
it?


Sophie,

You can select the hidden column by ctrl-G, A:A, format/column/unhide if
you want to unhide only one column, or A:B for columns A and B.

Alternatively, the box next to the formula bar, (the Name Box) and type
in A:A or A:B to select the hidden columns, then format/column/unhide.

Beege


All times are GMT +1. The time now is 05:59 AM.

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