| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unhiding columns
This sounds basic but I am stuck.
It used to be so easy in Office XP to unhide columns - Just select across and click unhide. In Excel 2007 when I select across the hidden columns , the unhide button remains 'grey' (inactive). How do I unhide? - I am however able to manually drag the column header and increase the column width of the hidden columns, but would like a more direct way |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unhiding columns
I don't use XL2007, but the trouble might be that the sheet might be Protected.
Vaya con Dios, Chuck, CABGx3 "Anuj" wrote: This sounds basic but I am stuck. It used to be so easy in Office XP to unhide columns - Just select across and click unhide. In Excel 2007 when I select across the hidden columns , the unhide button remains 'grey' (inactive). How do I unhide? - I am however able to manually drag the column header and increase the column width of the hidden columns, but would like a more direct way |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unhiding columns
Thanks .. but no the sheet is not protected- Moreover I am able to hide,
split, freeze - do whatever else I want to except unhide "CLR" wrote: I don't use XL2007, but the trouble might be that the sheet might be Protected. Vaya con Dios, Chuck, CABGx3 "Anuj" wrote: This sounds basic but I am stuck. It used to be so easy in Office XP to unhide columns - Just select across and click unhide. In Excel 2007 when I select across the hidden columns , the unhide button remains 'grey' (inactive). How do I unhide? - I am however able to manually drag the column header and increase the column width of the hidden columns, but would like a more direct way |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unhiding columns
Try Format Columns Unhide...............or maybe the column is not hidden
at all but only set to a very narrow column width........ Vaya con Dios, Chuck, CABGx3 "Anuj" wrote: Thanks .. but no the sheet is not protected- Moreover I am able to hide, split, freeze - do whatever else I want to except unhide "CLR" wrote: I don't use XL2007, but the trouble might be that the sheet might be Protected. Vaya con Dios, Chuck, CABGx3 "Anuj" wrote: This sounds basic but I am stuck. It used to be so easy in Office XP to unhide columns - Just select across and click unhide. In Excel 2007 when I select across the hidden columns , the unhide button remains 'grey' (inactive). How do I unhide? - I am however able to manually drag the column header and increase the column width of the hidden columns, but would like a more direct way |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unhiding columns
Try Format Columns Unhide...........or maybe the column is not really
hidden at all, but only set to a very narrow column width....... Vaya con Dios, Chuck, CABGx3 "Anuj" wrote: Thanks .. but no the sheet is not protected- Moreover I am able to hide, split, freeze - do whatever else I want to except unhide "CLR" wrote: I don't use XL2007, but the trouble might be that the sheet might be Protected. Vaya con Dios, Chuck, CABGx3 "Anuj" wrote: This sounds basic but I am stuck. It used to be so easy in Office XP to unhide columns - Just select across and click unhide. In Excel 2007 when I select across the hidden columns , the unhide button remains 'grey' (inactive). How do I unhide? - I am however able to manually drag the column header and increase the column width of the hidden columns, but would like a more direct way |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unhiding columns
Hi
Hiding and Unhiding columns can be achieved in the same way as XL2003. Mark the range of columnsright clickHide Mark the columns either side of the hidden columnsright clickUnhide If you want to go the route of FormatcolumnsUnhide, then in XL2007 Home tabCells groupFormatHide & Unhidechoose Rows or Columns -- Regards Roger Govier "Anuj" wrote in message ... This sounds basic but I am stuck. It used to be so easy in Office XP to unhide columns - Just select across and click unhide. In Excel 2007 when I select across the hidden columns , the unhide button remains 'grey' (inactive). How do I unhide? - I am however able to manually drag the column header and increase the column width of the hidden columns, but would like a more direct way |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unhiding columns
Thanks once again Roger ... .... Gosh ! that was stupid of me .... I was looking under the View tab .. which has Hide and Unhide .. But I now realize that this is for the entire workbook. Guess one will take some more time to get familiar with XL2007 totally. Incidentally the contextual right click after selecting multiple columns in XL2007 does not seem to have Hide/Unhide option (XL 2003 had that). Happy days are here again Cheers Anuj "Roger Govier" wrote: Hi Hiding and Unhiding columns can be achieved in the same way as XL2003. Mark the range of columnsright clickHide Mark the columns either side of the hidden columnsright clickUnhide If you want to go the route of FormatcolumnsUnhide, then in XL2007 Home tabCells groupFormatHide & Unhidechoose Rows or Columns -- Regards Roger Govier "Anuj" wrote in message ... This sounds basic but I am stuck. It used to be so easy in Office XP to unhide columns - Just select across and click unhide. In Excel 2007 when I select across the hidden columns , the unhide button remains 'grey' (inactive). How do I unhide? - I am however able to manually drag the column header and increase the column width of the hidden columns, but would like a more direct way |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unhiding columns
Incidentally the contextual right click after selecting multiple columns in XL2007 does not seem to have Hide/Unhide option (XL 2003 had that). Are you sure? It does for me. They are the last 2 items in the list Hide and Unhide -- Regards Roger Govier "Anuj" wrote in message ... Thanks once again Roger ... ... Gosh ! that was stupid of me .... I was looking under the View tab .. which has Hide and Unhide .. But I now realize that this is for the entire workbook. Guess one will take some more time to get familiar with XL2007 totally. Incidentally the contextual right click after selecting multiple columns in XL2007 does not seem to have Hide/Unhide option (XL 2003 had that). Happy days are here again Cheers Anuj "Roger Govier" wrote: Hi Hiding and Unhiding columns can be achieved in the same way as XL2003. Mark the range of columnsright clickHide Mark the columns either side of the hidden columnsright clickUnhide If you want to go the route of FormatcolumnsUnhide, then in XL2007 Home tabCells groupFormatHide & Unhidechoose Rows or Columns -- Regards Roger Govier "Anuj" wrote in message ... This sounds basic but I am stuck. It used to be so easy in Office XP to unhide columns - Just select across and click unhide. In Excel 2007 when I select across the hidden columns , the unhide button remains 'grey' (inactive). How do I unhide? - I am however able to manually drag the column header and increase the column width of the hidden columns, but would like a more direct way |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hiding/Unhiding Columns | Excel Worksheet Functions | |||
| Hiding/Unhiding Columns | Excel Worksheet Functions | |||
| Unhiding Columns in Error | Excel Discussion (Misc queries) | |||
| Unhiding Columns | Excel Discussion (Misc queries) | |||
| Unhiding columns | Excel Worksheet Functions | |||
Linear Mode
