ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Lines inserted into Excel Spreadsheet NO Longer Visible (https://www.excelbanter.com/excel-discussion-misc-queries/76703-lines-inserted-into-excel-spreadsheet-no-longer-visible.html)

SCPU173

Lines inserted into Excel Spreadsheet NO Longer Visible
 
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.

David McRitchie

Lines inserted into Excel Spreadsheet NO Longer Visible
 
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: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"SCPU173" wrote in message ...
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.





All times are GMT +1. The time now is 08:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com