Forum Discussion
Resizing a table in Excel without losing format
I have a table in an Excel worksheet with data which is 776 rows long. From row 777 and on I continued writing data but it is not included in the table. Now when I want to filter the data it only fil...
You want resizing a table in Excel without losing format.
The table size is not restricted to 776 rows it can be further increased upto last row i.e. 1048576 of excel sheet.
Now you can choose either of the option to increase the size of your table.
Option A
- Go to last column & last row of your table – you will reach to the last cell
- Press TAB key, it will come the first cell of next row & your table will automatically increase by one row.
- If you want to increase more, then press TAB key till you reach last cell and press TAB key again your table will automatically increase by one row.
- Repeat step 4 for further increasing the size of table
Option B
- Go to last column & last row of table – this will be the last cell
- In the bottom right of last cell you will see a blue colour corner like thing (shape) - image attached.
- Put mouse on it & drag down to increase the table size upto row number you want.