Microsoft Office Tutorials and References
In Depth Information
Rotating Text and Using the Fill Handle to Create a Series
Tap or click Excel 2013 in the search results to run Excel.
Tap or click the Blank workbook thumbnail on the Excel start screen to create a blank
workbook and display it in the Excel window.
If the Excel window is not maximized, tap or click the Maximize button on its title bar
to maximize the window.
To Enter the Worksheet Titles and Apply a Theme
The worksheet contains two titles, initially in cells A1 and A2. In the previous
chapters, titles were centered across the worksheet. With large worksheets that extend
beyond the size of a window, it is best to enter titles left-aligned, as shown in the sketch
of the worksheet in Figure 3 – 3a on page EX 133 because the worksheet prints with
the title on the rst page if the worksheet requires multiple pages. This allows the user
to nd more easily the worksheet title when necessary. The following steps enter the
worksheet titles and change the workbook theme to Slice.
Rotating Text in a
In Excel, you use the
Alignment sheet in the
Format Cells dialog box
(shown in Figure 3–5 on page
EX 136) to position data in a
cell by centering, left-aligning,
or right-aligning; indenting;
aligning at the top, bottom,
or center; and rotating. If you
enter 90 in the Degrees box
in the Orientation area, the
text will appear vertically and
read from bottom to top in
Select cell A1 and then type FroYoToGo as the worksheet title.
Select cell A2, type Six-Month Financial Projection as the worksheet
subtitle, and then press the ENTER key to enter the worksheet subtitle.
Apply the Slice theme to the workbook.
Rotating Text and Using the Fill Handle
to Create a Series
The data on the worksheet, including month names and the What-If Assumptions
section, now can be added to the worksheet.
What should you take into account when planning worksheet layout?
Excel allows you to apply many formatting changes to text and numbers to affect the visual impact. Rotated text often provides
a strong visual appeal. Rotated text also allows you to t more text into a smaller column width. When laying out a worksheet,
keep in mind the content you want to emphasize and the length of the cell entry titles relative to the numbers.
1 ENTER HEADINGS & DATA | 2 ENTER FORMULAS & FUNCTIONS | 3 CREATE SPARKLINE CHARTS
4 FORMAT WORKSHEET | 5 CREATE COLUMN CHART | 6 CHANGE VIEWS | 7 ASK WHAT - IF QUESTIONS
To Rotate Text in a Cell
The design of the worksheet calls specically for data for the six months of the selling season. Because
there always will be only six months of data in the worksheet, place the months across the top of the worksheet
as column headings rather than as row headings. Place in rows the categories of income and expenses, which are
more numerous than the number of months. This layout allows you to navigate the worksheet easily. A proper
layout ideally will create a worksheet that is longer than it is wide.