Change Cell Values without using Formulas
Have you ever needed to change all the values on your spreadsheets, for example; increase all your prices by 10% and then sat there adding extra columns to carry out the task with formulas and then copying all the results and remove the formulas and extra columns. Well there is a much easier way to perform this task using copy and paste special. Watch the video to see how.
Excel Tip: Duplicating Data in a cell
Here are a couple of very neat shortcuts for duplicating data, formula or function in a cell.
Video by David Ludlow – One Day Computer Courses