3
Use the control Worksheet_Change. See related links for a sample macro that will trigger a macro when the cell changes. Modify, as needed, to fit your specific situation.
how to create a excel sheet
There is no automatic forumla to copy and paste in excel, unless you write a custom macro. You could use a formula in sheet1 to show the value of a cell on sheet1, like this: In sheet1 put =sheet1!A1
Pfa the excel sheet
Are you talking about No. of rows in a Excel sheet? If Yes then you can see it yourself by following command: Ctrl+Down Arrow - display total no. of rows. Ctrl+Forward Arrow - display total no. of columns.
Draw a button on your sheet, by going to the View menu and picking Toobars and then the Forms toolbar and drawing your button. It will immediately ask you to connect a macro to it and then you can choose your macro. Then when the button is clicked the macro will run.
Add a sheet
You do not add more grid lines, they are present for all displayed cells. But, you can turn the grid lines on or off. In Excel 2007, go to the Page Layout tab in the Sheet Options and turn the grid lines on or off by checking or unchecking the box in front of View (under Grid Lines).
They are the same thing, excel is Microsoft's spreadsheet programme.
Calculating DSCR in Excel sheet
Select the sheet.
A spread sheet