View Single Post
 
Old 06-24-2020, 11:48 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

An example with Defined Table - Serie number is added automatically whenewer a new row is added. When any rows are deleted from table, Serie numbering is corrected automatically so numbers are alwais continuous.

To add rows into table, you
a) press Tab key with righmost field in last row active;
b) type info into any cell immediately below last row of Table, assured Table column doesn't contain formula;
c) insert a full row anywhere in Table's datarange;
d) select any cell of Table, and from Design menu click on Resize button. Enlarge the number of Table rows.
Attached Files
File Type: xlsx SerieNo.xlsx (9.2 KB, 6 views)
Reply With Quote