Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 18th 10, 06:53 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: May 2010
Posts: 1
Default How to unhide column?

I hid column E, did some other work on the spreadsheet, now cannot unhide
column E

  #2   Report Post  
Old May 18th 10, 07:09 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2009
Posts: 833
Default How to unhide column?

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   Report Post  
Old May 18th 10, 08:21 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,907
Default How to unhide column?

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   Report Post  
Old May 19th 10, 01:48 PM
Senior Member
 
First recorded activity by ExcelBanter: Sep 2008
Location: Hyderabad
Posts: 237
Thumbs up

Quote:
Originally Posted by Lois Corp Secy View Post
I hid column E, did some other work on the spreadsheet, now cannot unhide
column E

column width:

select column D,E,F and right click give column widtha as 10.

all the best
__________________
Thanks
Bala
  #5   Report Post  
Old June 30th 17, 08:16 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2017
Posts: 1
Default How to unhide column?

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   Report Post  
Old January 6th 21, 11:23 AM
Junior Member
 
First recorded activity by ExcelBanter: Dec 2020
Posts: 25
Default How to Unhide colum in Excel

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 04:31 PM


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HELP Unhide Column A Donna Excel Discussion (Misc queries) 4 January 27th 10 08:07 PM
Unhide Column WOLLAM Excel Discussion (Misc queries) 5 January 11th 10 07:39 PM
Unhide column - why doesn't click unhide column work? H Stevens Excel Discussion (Misc queries) 1 November 15th 07 01:36 AM
unhide column A Nanodream Excel Discussion (Misc queries) 3 June 14th 06 09:51 AM
How do I unhide a column when format/column/unhide won't work lincolnblaze Excel Worksheet Functions 1 December 14th 05 04:38 AM


All times are GMT +1. The time now is 01:29 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017