With DocHub, you can quickly replace topic in spreadsheet from anywhere. Enjoy capabilities like drag and drop fields, editable text, images, and comments. You can collect eSignatures securely, add an extra level of protection with an Encrypted Folder, and collaborate with teammates in real-time through your DocHub account. Make changes to your spreadsheet files online without downloading, scanning, printing or sending anything.
You can find your edited record in the Documents tab of your account. Create, share, print out, or convert your document into a reusable template. Considering the variety of powerful tools, it’s easy to enjoy seamless document editing and managing with DocHub.
okay so first of all Iamp;#39;m going to select the whole of this column and then go to the Home tab and go to find and replace then Iamp;#39;m going to find all of the r ones and replace them with a format and I will change the fill to be an orange fill and then replace all and this changes all of these cells that have R1 in them to Orange then I can do the same thing again for R2 and this time I will change the fill to green and okay and replace all and that changes all of the cells with R2 to green and that makes it easier to see the difference now I have all of my formulas set up Iamp;#39;m averaging each of the groups and what I want to do is copy these formulas across however that messes up the formulas because now these cell references are looking in column e instead of in column d so I want to change these formulas so they all have absolute cell references and to make the differences easier to see I will go to the formulas Tab and click show formulas then Iamp;#39;ll select