excel in the whole unit out to replace?
I have a table set out the number of units is 10,000
now need to replace the entire set of data to support the unit
how to do?
Prawns that are available to help
under
Baixie
replacement:10,000
replaced by:supporting the first unit selected and then replaced by 10,000 to replace this branch out Copy the data to a new table column A, column B click in the first line, type “= A1 * 10000”, carriage returns, the cursor at the point in the lower right corner and into a cross by left at the end to pull down, and then copied back to the B list If other forms of the original column did not “10,000”, with a direct line to find replacement in the editing — find, looking for a column in the importation of 10,000, in the field to replace the importation of support.Replace All be it.And then the blank space to write 10000
copy of the selected cell
all-out
right
Paste
increase
Leave a Reply
You must be logged in to post a comment.