Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Spokeshave
 
Posts: n/a
Default How do I unhide rows 1 through 28 on an Excel worksheet?

On an Excel worksheet I have hidden rows 1 through 28.

To unhide the Help file tells me to highlight the rows either side of the
hidden rowsand click, 'Unhide'. This is not possible as I have hidden row 1.

Can anybody advise me, please?
  #2   Report Post  
Max
 
Posts: n/a
Default

Just click on/select any col header, say col A's header
(this selects the entire column)

then click Format Row Unhide

Similarly, if you have hidden col A,
just select any row header, then
Format Column Unhide
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Spokeshave" wrote in message
...
On an Excel worksheet I have hidden rows 1 through 28.

To unhide the Help file tells me to highlight the rows either side of the
hidden rowsand click, 'Unhide'. This is not possible as I have hidden row

1.

Can anybody advise me, please?



  #3   Report Post  
Cgbilliar
 
Posts: n/a
Default

To unhide rows 1 through 28 left click mouse on blank space above 29 and
hightlight down to 29 right click your mouse then click on unhide.
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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
How do I add rows to a completed worksheet? [email protected] Excel Worksheet Functions 5 January 6th 05 07:45 PM
Why cannot I unhide the hidden rows ? Jim Edwards Excel Discussion (Misc queries) 2 December 4th 04 04:38 PM
How do I limit the number of rows in an Excel worksheet. laforge27 Excel Worksheet Functions 1 November 4th 04 01:42 AM
Display selected rows from one worksheet to another Brian Excel Worksheet Functions 5 October 29th 04 12:26 PM


All times are GMT +1. The time now is 09:47 AM.

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

About Us

"It's about Microsoft Excel"