then select a larger number of rows
Say 3000
so A2 to AF3000
BUT you could select just the columns A to AF
But its very inefficient and may slow the spreadsheet down depending on what else is being calculated
if you do choose A:AF
then you need to change the formulas to use row 1 and not 2
so $E2 becomes $E1 and all other cells with a 2 change to a 1
ok, any issue please come back, perhaps use XL2BB to post a sample - see signature or put on a share , like onedrive or dropbox, i tend not to got to unknown random shares
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.