A4 Accounting

Adding Values to Values

Let’s say you have an input cell that someone enters multiple values into eg

=10+5+34

You may have many such cells.

Now let’s say you want to add 20 to all these cells but keep the original values that have been entered in those cells.

Paste Special to the rescue.

1. Enter 20 in a blank cell and then copy the cell
2. Select the cells you want to amend – you can hold the Ctrl key down to select  multiple cells with the mouse
3. Open the Paste Special dialog
4. Click the options Values and Add – as per image below – then click OK – done!

The resulting formula will be something like

=(10+5+34)+20


Related Posts

					
			

				Drop Down Selection update
			
					
			

				Excel Has Ordinals
			
					
			

				Restarting Excel and Windows
			
					
			

				Open Power Query Shortcut
			
					
			

				VBA Window Split