Unformatted text preview: pop-up menu, shown
here, select the “Paste Values” option and click OK.
At this point Excel will replace the formula or
function with the results of the formula or function.
The “Concatenate” function is gone, the resulting
Paste Special - Values
string is no longer dependent upon the parent cells.
So changing cell A17, the word “dogs” to “house”
will not change this string any farther. However, the
text string in cell B1 is still dynamic or “live” and it
will with the text change.
“Paste Special” is a handy function for
workbooks and worksheets that are going to be
distributed to individuals who like to “play” with
your extensive formulas and functions. By selecting
the entire sheet, copying, and pasting the data back through “Paste Special > Values” the data will be
static and not dependent upon the source cells. This process also reduces the size of large Excel
worksheets significantly making them easier to attach for transmission and distribution. This feature or
function also helps when the values within the worksheet are built on values contained within other
workbooks that the recipient may not have access to.
The “Concatenate” data file was copied as the “Paste Special” data file so you can practice “Paste
Special” on its numerous dynamic or “live” formulas. Try “Paste Special” on an “intermediate” formula –
one that is called upon by another “Concatenate” function such as those formulas where part numbers are
assembled and watch the results of the costing formulas when the parts grid is changed. Today And Now
Excel has two functions that will assist you in inserting current dates and times. By utilizing the function
“=TODAY( )” Excel will present the date in the current default value for the worksheet. On January 1,
2008, this function would return 01/01/08 if that was the default of the worksheet and no other formatting
had been applied to the cell. If the cell had been formatted to MMM D, YYYY format under “Custom”
through the Format > Cell path the function would return Jan 1...
View Full Document
This note was uploaded on 09/19/2010 for the course ACCT 220 taught by Professor Ullmann during the Fall '10 term at University of Nebraska Kearney.
- Fall '10