Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Column numbering
Why do the row numbers seen on the left hand side of a worksheet jump?
In my case they are from 1,2,3, etc to 18 then it goes to 1262, 1263 etc ? This seems to upset the facility of dragging formulas down the page when required. How do you get this back to "normal" Thanks in advance Bob --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.792 / Virus Database: 536 - Release Date: 09/11/2004 |
#2
|
|||
|
|||
Hi
you probably have hidden / grouped some rows. Are the row numbers coloured in blue? -- Regards Frank Kabel Frankfurt, Germany "Nospam" schrieb im Newsbeitrag ... Why do the row numbers seen on the left hand side of a worksheet jump? In my case they are from 1,2,3, etc to 18 then it goes to 1262, 1263 etc ? This seems to upset the facility of dragging formulas down the page when required. How do you get this back to "normal" Thanks in advance Bob --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.792 / Virus Database: 536 - Release Date: 09/11/2004 |
#3
|
|||
|
|||
try in two ways if columns are hidden 1. edit-select all - right click mouse-unhide if column width is zero 2. edit - select all, format-coulmnwidth enter 9 and click ok -- anilsolipuram ------------------------------------------------------------------------ anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271 View this thread: http://www.excelforum.com/showthread...hreadid=277575 |
#4
|
|||
|
|||
If you have drop down arrows at the top of the columns then you
have filtering. I would expect the blue coloring was introduced with Excel 97 or Excel 2000, but you would see the selected rows row number in blue and the arrow in blue if selections for that column are being filtered. To restore all cells to view. Data, Filter, Show All To eliminate filter altogether Data, Filter, turn off auto filer, or turn off advanced filter When you learn something new also learn how to turn it off, unfortunately that is usually not described as well as how to do something. To learn more about Filtering see Debra Dalgleish's pages at http://www.contextures.com --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Frank Kabel" wrote in message ... Hi you probably have hidden / grouped some rows. Are the row numbers coloured in blue? -- Regards Frank Kabel Frankfurt, Germany "Nospam" schrieb im Newsbeitrag ... Why do the row numbers seen on the left hand side of a worksheet jump? In my case they are from 1,2,3, etc to 18 then it goes to 1262, 1263 etc ? This seems to upset the facility of dragging formulas down the page when required. How do you get this back to "normal" Thanks in advance Bob --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.792 / Virus Database: 536 - Release Date: 09/11/2004 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what formula do i put for column m = column k minus column l in e. | Excel Discussion (Misc queries) | |||
Change the width of a single column in a column chart | Charts and Charting in Excel | |||
how to fit my column unmoved eventhough i scroll down? | New Users to Excel | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
How to calculate the data in excel 2002 including only the last 9. | Excel Worksheet Functions |