LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default how do I expand collapsed rows in excel

I have a spreadsheet containing over 3000 lines of data. Looking through the
row numbers some rows are "missing". However, pointing the cursor over the
missing rows it is possible to expand out each row individually. So for
instance row 2110 is followed by row 3003. Using the cursor it is possible to
expand out row 3002 then to manually expand out row 3001 and so on down the
line. How can I do this manually. The Row Hide / Unhide command doesn't work.
Also all the row numbers along the left hand side of the spreadsheet are in
blue up to 3003 - from here on they are typed in the usual black/ Has anyone
seen this before?
 
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
The increase number of rows in Excel wise_man Excel Discussion (Misc queries) 12 January 17th 07 02:38 PM
Rows & Columns in Excel seadragon69 Excel Worksheet Functions 2 December 7th 05 05:54 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Can Excel "slide up" rows with content thru empty rows to condense portly44 Excel Worksheet Functions 2 April 1st 05 12:47 AM


All times are GMT +1. The time now is 07:18 PM.

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

About Us

"It's about Microsoft Excel"