Excel Hack

Serial number in Excel shortcut

If you are managing a large amount of data in Excel, you may want to add serial numbers to your data. Adding serial numbers to rows will make your data more visible. Adding serial numbers manually can take a lot of time. However, with the handy shortcut we will show you, you can easily add serial numbers by simply specifying the number in a dialog box.

Serial number shortcut

Access Key: Alt + H + F + I + S


Serial number the rows using the fill series

This is a shortcut for serial numbering a row using the fill series.

Total Time: 2 minutes

Select a cell

Select a cell

Select the cells to which you want to add serial numbers.

Enter numbers in cells

Enter 1

Enter 1 in the cell.

The Series dialog box will appear

The series dialog box appears

Press Ctrl + Enter, then press Alt + H + F + I + S to display the series dialog box.Press Alt + C to select a column, then press O to enter a stop value. This time, as an example, enter 6.

Serial number displayed

Serial number is displayed

Press Enter to display the serial number.