-
Add color to worksheet
tabs
-
Create multiple lines
within a cell
-
Resize the Formula Bar
-
Format text within a cell
-
Format cell content as
text
-
Enter telephone numbers,
social security numbers, and zip codes
-
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 and AutoFill
options
-
Reverse the AutoFill
action
-
Automatically fill down a
column
-
Save a worksheet as a PDF
file
-
Create a linear series
-
Filter records for unique
values
-
Remove duplicates
-
Add a picture as a sheet
background
-
Insert a picture to
appear as a watermark
-
AutoSum multiple columns
or rows
-
View the range finder
-
Paste link a picture of
cell(s)
-
Specify where to move the
cell pointer
-
Insert a worksheet using
a keyboard shortcut
-
Insert & delete using a
keystroke
-
Move to a different sheet
-
Select adjacent,
nonadjacent, and all sheets
-
Customize the Quick
Access toolbar
-
Select the same range on
several sheets
-
Work with multiple sheets
at the same time
-
Select cells with special
criteria
-
Fill across worksheets
-
Create a hyperlink to
another workbook
-
Display/hide formulas in
cells
-
Insert cut or copied
cells
-
Paste from clipboard
using Enter
-
Delete and clear cells
-
Move data without
replacing
-
Transpose rows and
columns
-
AutoFit 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 cell(s) and move to
named cell(s)
-
Create names using
existing titles
-
Paste all range names in
a workbook
-
Filter by selection
-
Insert the path,
filename, and sheet name in a cell
-
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 workbook
-
Protect and unprotect
worksheets
-
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
-
Customize the Ribbon
