-
Book Overview & Buying
-
Table Of Contents
Data Smart
By :
It's often in your best interest not to have a formula lying around like you see in Column E in Figure 1.4. If you were using the RAND() formula to generate a random value, for example, it changes each time the spreadsheet auto-recalculates, which while awesome, can also be extremely annoying. The solution is to copy and paste these cells back to the sheet as flat values.
To convert formulas to values only, simply copy a column filled with formulas (grab column E) and paste it back using the Paste Special option (found on the Home tab under the Paste option on Windows and under the Edit menu on Mac). In the Paste Special window, choose to paste as values (see Figure 1.7). Note also that Paste Special allows you to transpose the data from vertical to horizontal and vice versa when pasting. You'll be using that a fair bit in the chapters to come.
Figure 1.7 The Paste Special window in Excel 2011
Change the font size
Change margin width
Change background colour