How to create a Table in Excel
- Open to Your Workbook > Select range of Rows and Columns > Click “Ctrl + T” or “Ctrl + L“ ; (T-Table, L-List)
To Select All the rows and Column with input values Press “Ctrl + Shift + Down arrow + Left arrow“
You also get many Table Formatting Options (see last image)
2. Or Go to “Insert” tab > “Tables” group > Click on “Table” button > Click “OK” after verifying range
https://excelbasics.fun/how-to-protect-worksheet-in-excel/(opens in a new tab)
https://excelbasics.fun/how-to-remove-duplicates-in-excel/(opens in a new tab)