Hey all, I have a fairly large valuation worksheet, and I would like to repeat columns A&B on the left side of every page BUT page 20 (my setup is basically 10 'rows' of pages by 2 'columns' of pages).. Is there any way to do this?
This may not be what you are asking for, but it is still a neat trick. Copy the range then select the sheet tab you want to paste it into first. However instead of pasting the range into that sheet hold down the Ctrl button and select all the tabs of the sheets you would like to paste the range into. Now on the sheet that you have displayed paste or paste special into the cell of your choosing. The pasted range should be in every sheet now. To release the tabs just choose the tab of the sheet you copied from.
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.