MSOfficeExcel 2007 Tutorial Editing 107 codes

  1. Home
  2. MSOfficeExcel 2007 Tutorial
  3. Editing
1 Access an FTP Site
2 Add a Signature Line
3 Add or Edit an AutoCorrect Entry
4 Add or Modify FTP Locations
5 Change an Excel Template
6 Change AutoFormat options
7 Change Display View Options
8 Change Edit Options
9 Change editing options
10 Change Office Clipboard options
11 Change Research Options
12 Change Smart Tag Options
13 Change Spelling Options for All Microsoft Programs
14 Change the default file location of the Open dialog box
15 Change the Hyperlink Cell Style
16 Change the number of recently opened files that appear on the Office menu
17 Change the text or graphic for a hyperlink
18 Check Spelling All at Once
19 Choose how to fill the selection
20 Clear Cell Contents, Formatting, and Comments
21 Close a Workbook
22 Copy and Paste Data to the Office Clipboard
23 Copy Data Using Drag-and-Drop
24 Copy Data Using the Clipboard
25 Copy or move a hyperlink
26 Create a Custom Fill
27 Create a custom ScreenTip for a hyperlink
28 Create a Link Between Worksheets or Workbooks
29 Create a Link to Another File
30 Create a Template
31 Create a Workbook with a Template
32 Creating a Hyperlink
33 Customize Advanced Properties
34 Delete a Cell
35 Edit Cell Contents
36 Edit cell contents using the formula bar
37 Enter a Date
38 Enter a Label Using AutoComplete
39 Enter a Number as a Label
40 Enter a Text Label
41 Enter a Time on a 12-hour clock
42 Entering Values on a Worksheet
43 Entering Values Quickly with AutoFill
44 Excel 2007 Save File Formats
45 Exit Excel
46 Fill with Contents of Adjacent Cells
47 Find and Modify the Exclusion Dictionary
48 Find Cell Contents
49 Find Cells with Conditional Formatting
50 Find Cells with the Same Conditional Format
51 Find or replace cell contents
52 Format a Number Using the Format Cells Dialog Box
53 Format Currency
54 Format Numbers
55 Format numbers in international currencies
56 Format Values as Currency
57 Format Values as Long Date
58 Format Values as Number
59 Go To a Specific Location
60 Insert a Cell
61 Insert a symbol or special character
62 Insert Information Using a Smart Tag
63 Keys For Navigating in a Worksheet
64 Lock or Unlock Worksheet Cells
65 Long Date Format
66 Make a selection from within a range
67 Move Data Using Drag-and-Drop
68 Move Data Using the Clipboard
69 Open a Recently Opened Workbook
70 Open a Template
71 Open a Workbook from the Excel Window
72 Paste Cells from Rows to Columns or Columns to Rows
73 Paste Data with Special Results
74 Percentage Format
75 PinUnpin a workbook
76 Quickly clear contents
77 Redo an Action
78 Remove a Hyperlink
79 Remove a numeric format or font attribute
80 Replace Cell Contents
81 Research a topic
82 Save a Workbook as a PDF Document
83 Save a Workbook as an XPS Document
84 Save a Workbook for Excel 2007
85 Save a Workbook with Another Format
86 Save an Excel 97-2003 Workbook
87 Scientific Format
88 Search for a value or data in a cell and replace it
89 Select a Contiguous Range
90 Select a Non-contiguous Range
91 Select an Entire Rows or Columns
92 Select Multisheet Ranges
93 Set Save Options
94 Short Date Format
95 Sign the Signature Line
96 Start a Blank Workbook Within Excel
97 Switch Between Views
98 To create a custom number format using the Format Cells Dialog Box
99 To disable AutoRecover for a specific workbook
100 To turn on the AutoComplete option
101 Turn On AutoCorrect
102 Undo an Action
103 Use a Custom Dictionary
104 Use AutoRecover
105 Use the Thesaurus
106 View and Edit Standard Workbook Properties
107 When you press Enter, the active cell moves down one cell To change the direction