Accidentally lost rows 1, 2, 3 in Excel, what should I do?

If you lost rows 1, 2, 3 in Excel, you are not alone, many people have the same problem as you. This TipsMake article will show you how to get it back. 

Sometimes when using Excel, you will encounter a situation where the line is hidden and you don't know how to open it. Don't worry too much, this article will help you know the reasons to (avoid) and how to fix when rows 1, 2, 3 are lost in Excel . In addition, not only rows 1,2,3, you can apply the methods in the article to retrieve all hidden rows quickly and effectively. 

Accidentally lost rows 1, 2, 3 in Excel, what should I do? Picture 1

Why are rows 1,2,3 missing in Excel?

Losing lines 1,2,3 in Excel is a common error due to cases such as: 

  1. Line size is too small
  2. Advanced Filter is being applied
  3. Freezing or freezing 1 row or 1 column

This is also one of the reasons why Excel hides column A and cannot be unhide .

Accidentally lost rows 1, 2, 3 in Excel, what should I do? Picture 3

Fix missing lines 1, 2, 3 in Excel

Based on each cause of lost rows 1, 2, 3 in Excel 2010, 2013, 2015, 2018, you can apply to get back the lost rows. 

Fix error due to hidden lines

Sometimes when you accidentally forget to hide, you can use this method. Applies to cases where line errors are hidden. 

Select the line around the lost line > right click and select ' Unhide ' (show). So you can quickly display lost lines. 

Accidentally lost rows 1, 2, 3 in Excel, what should I do? Picture 5

Fix Excel error where the first line is hidden and cannot be unhide

In case the row is hidden and you cannot use Unhide, it may be because the row size is too small.

Here you use the following tips to fix the error. 

Move the mouse cursor to the intersection of the row and column so that a 2-way arrow appears. Then double-click the left mouse button twice. 

This method also applies to cases where lines are hidden.

Accidentally lost rows 1, 2, 3 in Excel, what should I do? Picture 7

This method is extremely fast and effective for all Excel files with hidden first lines. At the same time, the same applies to the case where Excel has hidden column A and cannot be unhide. 

How to open hidden lines in Excel via filter function

This method applies advanced data filtering methods in Excel. Proceed as follows: 

  1. Select the Data tab > Sort & Filter > Advanced , after this step a table will appear. 
  2. Select the item to delete data in the Criteria range section > and click OK
    1. Criteria range : Conditions to filter (including title and conditions corresponding to that title). When deleted, the original data will appear. 

At this point, fixing the error of missing lines 1, 2, 3 in Excel has been successful. 

How to fix errors when turning off the Freeze Plane function

To turn off the Freeze Panes function in Excel and fix the error of not being able to display the column again, you can follow these steps:

  1. Open the Excel file you're working on > Select the ' View ' tab on the menu bar.
  2. In the ' Windows ' group, check that ' Freeze Panes ' is selected. If so, click on it to turn off this function!
  3. After turning off the Freeze Panes function , you can try unhide again as instructed above. 
  4. If the row is still not visible, you can try other methods such as using the keyboard shortcut Ctrl + Shift + 0 (zero) or using VBA to unhide the column. 

(*) VBA method instructions: 

  1. Press the key combination Alt + F11
  2. In the VBA Editor, select ' Insert ' and select ' Module ' from the menu. A new VBA code window will appear.

Accidentally lost rows 1, 2, 3 in Excel, what should I do? Picture 9

  1. Copy or enter this code. 

Sub UnhideRows()

    Rows('1:3').EntireRow.Hidden = False

End Sub

  1. Press the F5 key combination or click the ' Run ' button on the toolbar to run the VBA code. 

After running this VBA code, lines 1, 2, 3 will be reopened and displayed in your Excel spreadsheet.

Note: Before running the VBA code, make sure you have saved your Excel file to avoid unwanted data loss.

Wishing you success with these methods to fix missing lines 1, 2, 3 in Excel.

4 ★ | 1 Vote

May be interested

  • How to delete rows and columns in Excel with mouse or keyHow to delete rows and columns in Excel with mouse or key
    excel is an important and indispensable tool in the work process. however, editing data or deleting rows and columns in excel can be quite complicated for some new users. therefore, to help make work more efficient, we will introduce to readers how to delete rows and columns in excel using the mouse or keys in detail in the article below.
  • MS Excel 2007 - Lesson 10: Modify columns, rows and cellsMS Excel 2007 - Lesson 10: Modify columns, rows and cells
    when you open a new blank workbook in excel 2007, cells, columns, and rows are set to default sizes. you can change the size of each cell, column and row, as well as insert new columns, rows and cells if needed.
  • How to handle cells, columns, rows in a spreadsheet in ExcelHow to handle cells, columns, rows in a spreadsheet in Excel
    the following article will guide you in detail how to handle cells, columns, rows in spreadsheets in excel. 1. change the width of columns, rows and cells in excel. 1.1 resize a row or a column: - hold down the left mouse button for the vertical part of the column and drag the cycle
  • Instructions on 2 simple ways to delete conditional rows in ExcelInstructions on 2 simple ways to delete conditional rows in Excel
    if you want to delete conditional rows in excel, you will have to spend a lot of time selecting and deleting in the data table. that's why this article will show you 2 ways to delete conditional rows in excel very quickly.
  • How to temporarily hide rows and columns in Excel 2013How to temporarily hide rows and columns in Excel 2013
    excel 2013 has a feature that allows temporary users to hide one or more rows / columns in an excel spreadsheet. this feature is very useful in case you only want to print a part of the spreadsheet but do not want to delete other excess rows and columns.
  • How to add rows and columns in ExcelHow to add rows and columns in Excel
    how to add rows and columns in excel. the article shows you 3 ways to add rows (rows) or add columns in excel.
  • Instructions for coloring alternating rows and columns in ExcelInstructions for coloring alternating rows and columns in Excel
    alternating colors in excel is a useful technique to make your spreadsheet more visual. learn how to use conditional formatting in excel 2007 to 2016 to easily distinguish rows and columns.
  • How to Unhide Rows in ExcelHow to Unhide Rows in Excel
    this wikihow teaches you how to force one or more hidden rows in a microsoft excel spreadsheet to display. open the excel document. double-click the excel document that you want to use to open it in excel.
  • How to fix column and header rows in Excel 2016How to fix column and header rows in Excel 2016
    how to fix columns and headlines in excel 2016. with an excel table with a large number of columns and rows, fixing columns and headlines is a necessary job, you can easily check. investigate and process data without confusion and waste n
  • Excel - Convert columns to rows in ExcelExcel - Convert columns to rows in Excel
    if you have an excel file and enter data in the wrong row or column or vice versa, what will you do? would you delete it and re-enter it? that takes up a lot of your time. let's see how taimienphi.vn guides you on how to convert columns into rows in excel.