This process also reduces the size of large excel

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

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.

Ask a homework question - tutors are online