-
Add color to
worksheet tabs
-
Create multiple
lines within a cell
-
Resize the formula
bar
-
Format cell
content as text
-
Enter telephone
numbers, social security numbers, zip codes, and dates
-
Use a custom
format to enter dates
-
Use a ScreenTip
to display cell contents
-
Fill cell(s) the
width of a column
-
Fill nonadjacent
cells with the same entry
-
Use the pick list
to enter text in a cell
-
Add an AutoCorrect
entry
-
Use AutoFill &
AutoFill options button
-
Reverse the
AutoFill action
-
Automatically fill
down a column
-
Create a linear
series & remove duplicates
-
Filter records for
unique values
-
Remove duplicates
-
Add a picture as a
sheet background
-
Insert a picture
to appear as a watermark
-
AutoSum multiple
rows and columns
-
View the range
finder
-
Paste link a
picture of cell(s)
-
Select a large
range
-
Specify where to
move the cell pointer
-
Insert a worksheet
using a shortcut
-
Insert and delete
using a keystroke
-
Move to a
different sheet & select all sheets
-
Select adjacent
and nonadjacent sheets
-
Customize the
Quick Access toolbar
-
Print multiple
worksheets with consecutive page numbers
-
Select the same
range on several sheets
-
Work with multiple
sheets
-
Select cells with
special criteria
-
Fill across
worksheets
-
Create a hyperlink
to another workbook
-
Display/hide
formulas in cells
-
Insert cut or
copied cells
-
Delete and clear
cells
-
Move data without
replacing
-
Transpose rows and
columns
-
Autofit multiple
columns or rows
-
Autofit all
columns or rows
-
Color cells with a
custom pattern
-
Copy formats
multiple times
-
Add a double
underline
-
Rotate cell
contents
-
Jump to or select
to the last filled cell
-
Name cells and
move to named cells
-
Create names using
existing titles
-
Insert a range
name from a list
-
Paste all range
names in a workbook
-
Filter by
selection
-
Insert the path,
filename, & sheet name
-
Customize the
Status Bar
-
Search for a
function
-
Select cells with
a quick keystroke
-
Specify entry of
numbers only
-
Select cells where
data validation is used
-
Create a quick
chart on a separate sheet
-
Drag and drop
cells between sheets
-
Protect &
unprotect all or part of a worksheet
-
Open multiple
workbooks simultaneously
-
Compare two
workbooks side by side
-
Copy sheets
between workbooks
-
Pin a file to the
recently used file list
-
Save multiple
files in a workspace
-
Hide and unhide a
workbook
-
Use page break
preview
-
Show/hide screen
elements
