A spreadsheet I created a couple years ago, had lines I inserted into the
worksheet, segmenting it into 5 sections. The lines were red in color. They
have dissappeared? and I cannot view them or insert them again. I have done
nothing, have no viruses but the lines have dissappeared.
Does anyone have any idea where the lines went or why they do not appear any
longer. I use MS Office 2003.
If you did not save the worksheet then the lines are gone.
Are all of the line numbers running sequentially or are any missing
-if some are missing you may have hidden rows, or
you may have a filtered list (drop down arrows at top)
You may be looking in the wrong worksheet or the wrong workbook,
the wrong directory, or have restored from an earlier backup.
In any case Excel does not keep track of what you do..
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm
quot;SCPU173quot; gt; wrote in message ...
gt; A spreadsheet I created a couple years ago, had lines I inserted into the
gt; worksheet, segmenting it into 5 sections. The lines were red in color. They
gt; have dissappeared? and I cannot view them or insert them again. I have done
gt; nothing, have no viruses but the lines have dissappeared.
gt;
gt; Does anyone have any idea where the lines went or why they do not appear any
gt; longer. I use MS Office 2003.
- Oct 18 Sat 2008 20:47
Lines inserted into Excel Spreadsheet NO Longer Visible
close
全站熱搜
留言列表
發表留言