Formatting Worksheets
✓
Selecting cell ranges and adjusting column widths and row heights
✓ Formatting cell ranges as tables
✓
Assigning number formats
✓
Making alignment, font, border, and pattern changes
✓
Using the Format Painter to quickly copy formatting
✓ Formatting cell ranges with Cell Styles
✓
Applying conditional formatting
Keys
Enter
= Moves the cell pointer down one cell
in the selection (moves one cell to the right when the selection consists of a
single row)
Shift+Enter
= Moves the cell pointer up one cell in the
selection (moves one cell to the left when the selection consists of a single
row)
Tab
= Moves the cell pointer one cell to the
right in the selection (moves one cell down when the selection consists of a
single column)
Shift+Tab =
Moves the cell pointer one
cell to the left in the selection (moves one cell up when the selection
consists of a single column)
Ctrl+period
(.) = Moves the cell pointer from corner to corner
of the cell selection.
Saving the
Data
One of the most important tasks you ever
perform when building your spreadsheet is saving your work! Excel offers three
different ways to invoke the Save command:
✦
Select the Save button on the Quick Access toolbar (the one with the disk
icon).
✦
Press Ctrl+S or F12.
Planning
your workbook
✦
Does the layout of the spreadsheet require the use of data tables
✦
Do these data tables and lists need to be laid out on a single worksheet or can
they be placed in the same relative position on multiple worksheets of the
workbook (like pages of a book)?
✦
Do the data tables in the spreadsheet use the same type of formulas?
✦
Do some of the columns in the data lists in the spreadsheet get their input
from formula calculation or do they get their input from other lists (called
lookup tables) in the workbook?
✦ Will any of the data in the spreadsheet be
graphed, and will these charts appear in the same worksheet (referred to as
embedded charts), or will they appear on separate worksheets in the workbook
(called chart sheets)?
✦
Does any of the data in the spreadsheet come from worksheets in separate
workbook files?
✦ How often will the data in the spreadsheet be
updated or added to?
✦ How much data will the spreadsheet ultimately
hold?
✦
Will the data in the spreadsheet be shared primarily in printed or online form?
✦
Enter the title of the data table in the first cell, which forms the left and
top edges of the table.
✦ Enter the row of column headings in the row
below this cell, starting in the same column as the cell with the title of the
table.
✦ Enter the row headings down the first column
of the table, starting in the first row that will contain data. (Doing this
leaves a blank cell where the column of row headings intersects the row of column
headings.)
✦
Construct the first formula that sums columns of (still empty) cell entries in
the last row of the table, and then copy that formula across all the rest of
the table columns.
✦
Construct the first formula that sums the rows of (still empty) cell entries in
the last column of the table, and then copy that formula down the rest of the
table rows.
✦
Format the cells to hold the table values and then enter them in their cells,
or enter the values to be calculated and then format their cells. (This is
really your choice.)
For formula tab
(File➪ Options➪ Formulas or Alt+FTF)
are divided into Calculation Options, Working with Formulas, Error Checking, and Error Checking Rules.
open a file
Press Ctrl+O to open a file for editing and the Save As screen.
save a new workbook.
When you press Ctrl+S or select the Save button on the Quick Access
toolbar to save a new workbook.
Calculate
Now (F9).
Calculate
Sheet (Shift+F9).
Close the excel file
Close it right away by pressing Ctrl+W,
choosing File➪ Close, or pressing Alt+FC
Save the file
Click
the Save button on the Quick Access toolbar (the one with the disk icon), or choose
File➪ Save
from
the File menu button, or press Ctrl+S
Pinning Excel to the Windows 7 Start menu If you use Excel all the time, you may want to make its program option a permanent part of the Windows 7 Start menu.
To do this, pin the program option to the Start menu:
1. Start Excel from the Windows Start menu.
To launch Excel, use the appropriate method for your version of Windows, as I outline earlier in this chapter. After launching Excel, Windows adds Microsoft Office 2010 to the recently used portion on the left side of the Windows Start menu.
2. Click the Start menu and then right-click Microsoft Office Excel 2013 to open its shortcut menu.
3. Choose Pin to Start Menu from the shortcut menu. After pinning Excel in this manner, the Microsoft Office Excel 2013 option always appears in the upper section of the left column of the Start menu. You can now launch Excel simply by clicking the Start button and then clicking this option.
1.#REMEMBER#
Don’t forget the Ctrl+Page Down and Ctrl+Page Up shortcut keys for selecting the next and previous sheets, respectively, in your workbook.
You can also click the Next Sheet and Previous Sheet button marked by the ellipsis (…).
The Next Sheet button is the one with the ellipsis on the right side of the sheet tabs immediately left of the New Sheet button.
The Previous Sheet button is the one with ellipsis on the left side of the sheet tabs to the immediate left of the first visible sheet tab. If your workbook contains too many sheets for all their tabs to be displayed at the bottom of the Worksheet area, use the Sheet tab scroll buttons to bring new tabs into view (so that you can then click them to activate them).
You click the Next Scroll button (the one with the triangle pointing right) to scroll the next hidden sheet tab into view on the right and the Previous Scroll button (the one with the triangle pointing left) to scroll the next hidden sheet into view on the left.
You Ctrl+click the Next Scroll button to scroll
the last sheet into view and Ctrl+click the Previous Scroll button to scroll
the first sheet into view.
When quitting of Microsoft excel.
Press Alt+FX or
Alt+F4 on your physical or Touch keyboard.
Select the Close
button (the one with the x) in the upper-right corner of the Excel program window.
Click the Excel
program button (the green one with the x on a partially opened book to the
immediate left of the Save button on the Quick Access toolbar) followed by the
Close option on its drop-down menu.
The options in the When Creating New Workbooks section of the popular tab of the Excel Options dialog box include only these four combo
1. Use This as the
Default Font.
2. Font Size.
3. Default View for New
Sheets.
4. Include This Many
Sheets.
4.#REMEMBER#
Don’t
forget about the shortcut keys:
Ctrl+B for toggling on and off bold in the
cell selection,
Ctrl+I for toggling on and off italics, and
Ctrl+U for toggling on and off underlining
for quickly adding or removing these attributes from the entries in the cell
selection.
