{"id":3781,"date":"2018-12-12T20:21:24","date_gmt":"2018-12-12T20:21:24","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=3781"},"modified":"2024-03-30T11:12:15","modified_gmt":"2024-03-30T11:12:15","slug":"sheet-formula","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/formulas\/sheet-formula\/","title":{"rendered":"Sheet Formula in Excel"},"content":{"rendered":"\n
SHEET and SHEETS are two new functions that appeared in Excel 2013 and are also present in Excel 2019 and Excel 365.<\/p>\n\n\n\n
The SHEET<\/strong> function returns the index of the selected sheet. It starts counting from 1.<\/p>\n\n\n\n The SHEETS<\/strong> function returns the number of sheets in the reference.<\/p>\n\n\n\n The SHEET function returns the index of a sheet. Take a look at the following example.<\/p>\n\n\n\nGet the Sheet index<\/h2>\n\n\n\n