Latest Lists

experts of microsoft Excel , how to sum 5 in an large price list?

I have an price list for some articles , i need to sum +5 on all the prices , how can i do it ? Thanks

Public Comments

1. +5 what? Dollars? Percent? For 5%, select an unused cell and enter: 1.05 Reselect the cell, right click, and select 'Copy'. Highlight the entire price list column and right click anywhere inside the highlighted cells. Select 'Paste Special', select the 'Multiply' optionbutton, and click OK. For adding 5 to all values, use the same process, but enter 5 in the unused cell and Paste Special - 'Add'.