tags:

views:

28

answers:

1
Q: 

how to unhide numbers on the first column in the excel sheet

I have an excel sheet where the first column seems to be a running integer (excel sheet defined and not a user defined serial number), but sometimes it seems to miss a number or a bunch of numbers.

Why would this happen and how to avoid this? Note: We do excessive copying of rows and delete rows once in a while, but not sure why the running index is not being maintained by the excel sheet

A: 

It maybe as simple as hidden rows in your sheet. If so, then select the whole sheet (ctrl A) and then format->rows->unhide...

Hameed  2010-08-11 03:43:11
did try that, but it didn't seem to help
 2010-08-11 03:48:20
Perhaps the function used for running integer only writes values to the cells hence deleting a row doesn't recalculate the integers of subsequent rows. See if it the cells only have values or is there a function like =a1+1....
Hameed  2010-08-11 04:31:20
As I mentioned earlier, the successive column which I am using is a user defined serial number which has the above formula. Not sure why this is affecting the first column which is excel defined
 2010-08-11 04:55:50
Can you take a screenshot of few rows of only those two columns? I am not sure if I am following now... I thought there were only one column affected :s
Hameed  2010-08-11 06:03:23

related questions

Top ten ordering in Excel based on complex team rules
Exposing .net methods as Excel functions?
Hiding data points in Excel line charts
Options for PivotTables in Excel
How do I create a status dialog box in Excel
Killing Excel.EXE on server
Modifying a spreadsheet using a VB macro
Count a list of cells with the same background color
Is there anything wrong with this query?
Excel VBA: Alternative IDE
Insert current date in Excel template at creation
Excel: list ranges targeted by INDIRECT formulas
What is the best way to package and distribute an Excel application.
Using Interop with C#, Excel Save changing original. How to negate this?
Using VLOOKUP in an array formula on Google Spreadsheets
How do I save a datagrid to excel in vb.net?
Alternating coloring groups of rows in Excel
How do you prevent leading zeros from being stripped when importing an excel doc using c#
How do I find the Excel column name that corresponds to a given integer?
Accessing Excel data source running SSIS package on 64 bit server
.NET - Excel ListObject autosizing on databind
Reading Excel files from C#
Does anyone have .Net Excel IO component benchmarks?
Refresh Excel VBA Function Results
What is a good web-based Grid that accepts Excel clipboard data?