ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   unhide all columns (https://www.excelbanter.com/excel-discussion-misc-queries/262363-unhide-all-columns.html)

unhide all columns

unhide all columns
 
the excel sheet shows H and then it goes to M
I need to show all the columns
they are not protected I just dont know how to show/unhide them

FSt1

unhide all columns
 
hi
it's always a good idea to state what version excel you have perticularly
now since the newer version of excel is so radically different.
high light column h and m. (h through m?)

03
on the meun barformatcolumnsunhide
07
home tabcells groupformathide and unhideunhide columns

regards
FSt1

"unhide all columns" wrote:

the excel sheet shows H and then it goes to M
I need to show all the columns
they are not protected I just dont know how to show/unhide them


unhide all columns[_2_]

unhide all columns
 
thanks for the reply
version is 2003

I tryed that but they are still not showing
There is no protection
I can send the sheet if that would help

"FSt1" wrote:

hi
it's always a good idea to state what version excel you have perticularly
now since the newer version of excel is so radically different.
high light column h and m. (h through m?)

03
on the meun barformatcolumnsunhide
07
home tabcells groupformathide and unhideunhide columns

regards
FSt1

"unhide all columns" wrote:

the excel sheet shows H and then it goes to M
I need to show all the columns
they are not protected I just dont know how to show/unhide them


unhide all columns[_2_]

unhide all columns
 
thanks that worked

"מיכאל (מיקי) אבידן" wrote:

In ALL(!) Excel versions do so:
Click and hold the mouse button while selection the two column headers H & M.
Now, Right click on one of them and then click "Unhide".
Micky


"unhide all columns" wrote:

the excel sheet shows H and then it goes to M
I need to show all the columns
they are not protected I just dont know how to show/unhide them



All times are GMT +1. The time now is 08:40 AM.

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