LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 130
Default 1 and 2 prior to beginning of Row headers

What is this? I'm working on a spreadsheet that is having sort problems,
only to notice there are 2 columns labeled 1 and 2 before the row headers
start...
It reminds me of Access tables with relationships? I've never seen this
before in excel? There are + and - signs in the columns - seems to collapse
and expand some of the rows of data...
What is causing it? What is the purpose? Can anyone give a some more info.
The sort works fine when I copy and paste the data into a fresh sheet that
does not have those columns. Looks like the rows that are marked, were being
ignored by the sort. I'm almost thinking they are there by accident - maybe
when updating from 2003 to 2007.
Thanks for any help you can send my way!!!!
Cindy

 
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
15th of prior month Deb Excel Worksheet Functions 3 February 6th 07 09:48 PM
Overwriting prior formula Mark Excel Worksheet Functions 3 August 15th 06 03:03 PM
dates, 1 month prior wfactor Excel Worksheet Functions 5 June 19th 06 08:23 AM
Prior Month Howard Excel Discussion (Misc queries) 6 November 2nd 05 03:06 PM
Dates prior to 1900 Kenn Tews Excel Worksheet Functions 0 November 22nd 04 02:49 AM


All times are GMT +1. The time now is 11:14 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"