Microsoft Office Tutorials and References
In Depth Information
Printing a Worksheet
If you have a column of data that is arranged in a predictable fashion, you can extract data
from it by using any of the following three functions:
=LEFT(text,num_chars) grabs a specific number of characters from the left side of a text
value. If cell A1 contains the string LMSA10042, the formula =LEFT(A1,3) returns LMS. The
RIGHT function has a similar syntax, taking characters from the end of the specified text.
Use the MID function to return a specific number of characters starting from a specific
position. In the previous example, =MID(A1,3,4) takes four characters, starting from the third
character in the string: SA10.
In some cases you have to combine multiple functions to accomplish a goal. Here’s how
you can find the location of a specific string in a cell and then extract all or part of that
string. For this example, we want to search for the string "SA10". We can use either of
two functions. FIND and SEARCH perform similar jobs, with one difference: FIND is
casesensitive and SEARCH is not. To search for the position in a string of text where SA10
begins, use =SEARCH("SA10",A1). The result is 3 in our example. Now combine that with
the MID function and you can extract 6 characters from the point where that string begins:
The LEN function returns the length of a text string. In our previous example, we can use
=LEN(A1) to determine the length of the text in cell A1, which is 9 characters.
Printing a Worksheet
Most Excel workbooks are designed to be viewed, edited, and shared on a screen rather
than on printed pages. When you do need to add an Excel chart or table to a report, you’ll
get best results by copying and pasting it into a Word document, where you have a full
range of tools for setting up pages and margins to match the paper size in your printer.
But there are times when you indeed want to print a worksheet (or even an entire
workbook) so that you can study it ofline or share it with others in a meeting. For those
occasions, you need to do some extra work before clicking the Print button to ensure that your
free-lowing worksheet doesn’t break at awkward locations.
Adjusting Print Settings
The print features in Excel 2010 are radically different from those in earlier versions, thanks
to Backstage view. If you upgraded from Excel 2003, you’ll also find a new Page Layout
view (introduced in Excel 2007) that allows you to edit your workbook in a view that mimics
the printed page, complete with headers, footers, and margins. If you’re planning to print
just part of a worksheet, start by selecting that portion; then click File and click Print to gain
access to print settings and a live preview pane, as shown in Figure 14-4.