Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I hid column E, did some other work on the spreadsheet, now cannot unhide
column E |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
EXCEL 2007
Clcick on D to highlight that column and, keeping the left mouse button depressed, drag to column F so that both columns are highlighted. Right click / Unhide If my comments have helped please hit Yes. Thanks. "Lois Corp Secy" wrote: I hid column E, did some other work on the spreadsheet, now cannot unhide column E |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Select D and F and right-clickunhide.
If that doesn't work mayber E has been set to 0 or very tiny width. In Namebox type E1 and Enter. FormatColumnWidth. Poke in a number like 10 Gord Dibben MS Excel MVP On Tue, 18 May 2010 10:53:01 -0700, Lois Corp Secy <Lois Corp wrote: I hid column E, did some other work on the spreadsheet, now cannot unhide column E |
#4
![]() |
|||
|
|||
![]() Quote:
column width: select column D,E,F and right click give column widtha as 10. all the best
__________________
Thanks Bala |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
On Tuesday, May 18, 2010 at 10:53:01 AM UTC-7, Corp Lois Corp Secy wrote:
I hid column E, did some other work on the spreadsheet, now cannot unhide column E there's an arrow on whatever column you have now visible pointing < at the top bar (where columns are listed alphabetically). just click either < or , and the columns will 'come back'. |
#6
![]() |
|||
|
|||
![]()
To select the first hidden row or column on the worksheet, do one of the following:
In the Name Box next to the formula bar, type A1, and then press ENTER. On the Home tab, in the Editing group, click Find & Select, and then click Go To. In the Reference box, type A1, and then click OK. On the Home tab, in the Cells group, click Format. Do one of the following: Under Visibility, click Hide & Unhide, and then click Unhide Rows or Unhide Columns. Under Cell Size, click Row Height or Column Width, and then in the Row Height or Column Width box, type the value that you want to use for the row height or column width. I hope this is helpful! Admin CloudDesktopOnline Last edited by Tim Paine : January 6th 21 at 03:31 PM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HELP Unhide Column A | Excel Discussion (Misc queries) | |||
Unhide Column | Excel Discussion (Misc queries) | |||
Unhide column - why doesn't click unhide column work? | Excel Discussion (Misc queries) | |||
unhide column A | Excel Discussion (Misc queries) | |||
How do I unhide a column when format/column/unhide won't work | Excel Worksheet Functions |