How To Make First Row Constant In Excel

Excel How To Keep One Cell Constant In Formula

How To Make First Row Constant In Excel. Just put the $ sign in front of your desired constant cell. Like $a6 if you wish to just change the number 6.

Excel How To Keep One Cell Constant In Formula
Excel How To Keep One Cell Constant In Formula

Web enable the workbook you want to keep 1st row visible across whole workbook, and select cell a2, and click kutools plus >. Just put the $ sign in front of your desired constant cell. Like $a6 if you wish to just change the number 6.

Just put the $ sign in front of your desired constant cell. Like $a6 if you wish to just change the number 6. Web enable the workbook you want to keep 1st row visible across whole workbook, and select cell a2, and click kutools plus >. Just put the $ sign in front of your desired constant cell.