New... Opens a new
Excel Workbook. |
Undo Takes
back the last thing you did. You may click it or type Ctrl+Z repeatedly
to turn back time to before you make a mistake.Repeat or Redo Repeats the last action reverses an undo. Cut The selected cell(s) will disappear after you paste them. Selected text disappears and is stored temporarily in the Clipboard. Copy The contents of selected cell(s) will be copied to a new location when you paste them. Selected text is copied into the Clipboard. Paste Previously cut or copied cells are pasted into the newly selected location. Cut or copied text, images, etc. are copied from the Clipboard into the newly selected location. NOTE: Pasted formulas change to calculate the cells in the new position relative to where you paste them. Paste Special... Lets you paste the values calculated by formulas, instead of the formulas themselves, along with other very useful options. Paste as Hyperlink Will maintain a link that, when clicked, takes you to the original location of whatever you pasted. Fill Lets you fill selected cells with the contents of the first cell in the range (in white). See below for Fill Series... Clear Removes formatting (e.g. bold), contents, comments (see Insert Comment) or all of the above. Note that the little "Del" key clears contents but not formats or comments. Delete... Removes the selected cell(s) from your Worksheet entirely. You may be asked how you wish to move the surrounding cells to fill in the empty "hole." Delete Sheet Permanently removes the current sheet from existence. Move or Copy Sheet... Lets you move or copy the current Worksheet within the current Workbook or to a new Workbook. Be sure to check the Create a Copy box if you don't want to remove the sheet from its current location. Find... Locates a given text string within your selection. Replace... Locates and replaces a given text string in your selection with another specified string (or with nothing at all). Go To... Takes you to a cell specified by column and row, or specified by name (see Insert Name). Links... Lets you edit links to items referenced by Paste Special... Paste Link. Object Lets you edit a selected object (e.g. a drawing or picture). |
Normal View
displays all cells, printing or not.Page Break Preview Displays only the cells that will be printed. You may set page breaks in this views (displayed as blue lines) by dragging them. Toolbars Lets you select which toolbars are visible across the top of your Excel window (i.e. the rows of buttons). Formula Bar Sets whether or not you wish to display the Formula Bar, which displays the formula (if any) or unformatted contents of the currently selected cell. Status Bar Sets whether or not you wish to display the Status Bar, shown across the bottom of the Excel window. Header and Footer... Allows you to edit the Header, which appears across the top of each printed page, and/or the Footer, which appears across the bottom. Comments Allows you to see all the comments that have been inserted into the current Worksheet (see Insert Comment). Custom Views... Allows you to save or restore how your worksheet is displayed within the program (does not affect printed format). Report Manager... Combines a sequence of sheets, views, and scenarios to create a report that you can print. Full Screen Maximizes the viewable area of your worksheet by filling up the entire screen and hiding everything except the menu bar. Zoom... Allows you to zoom in and out of your document (i.e. to magnify or shrink the worksheet display - does not affect printed format). |
Cells... Inserts new
cells into your worksheet, prompting you to ask how you would like to
move the surrounding cells out of the way. |
Cells... Allows you to specify all aspects of formatting for the selected cell(s). Click here for more info. Row Height... - you specify a numeric value for the height of the selected row(s). AutoFit - Excel adjusts the height of the selected row(s) based on contents. Hide/Unhide - controls whether or not a row is visible on your screen. Hidden rows are not printed or displayed. |
Column Width...
- you specify a numeric value for the width
of the selected column(s). AutoFit - Excel adjusts the width of
the selected column(s) based on contents. Hide/Unhide - controls
whether or not a column is visible on your screen. Hidden columns are
not printed or displayed. |
Sheet Lets you rename, hide/unhide or add a background for the current sheet. AutoFormat... (see below) Conditional Formatting...
If a cell value is between specified limits, or if a formula results in
a specified value, then a given format will be automatically applied to
the cell(s). |
AutoFormat
Lets you apply a pre-specified look to your entire Worksheet. |
Spelling... Checks
the Worksheet or selected cell(s) for spelling errors. |
Sort (see
below) |
Sort Makes it easy to sort columns of data alphanumerically. Be sure to check the box to indicate whether or not your data has headers at the tops of the columns, or else the headers may be sorted along with the rest of the list. The screenshot to the right shows how you would sort a list of data by Last name, then by First name, then by Role (e.g. CEO, President, etc.). Note that this list has top row column titles of Last, First and Role. |
New Window
Opens a new window to view the current document. It is not the same as selecting
New... from the file menu - no new file is created by this command. Like
two windows looking into the same room, two windows looking into the same
Workbook show the same contents, just from a different perspective. Windows
are denoted by Workbookname:WindowNumber. For example, changes made in one
window of a Workbook (FilemakerData.xls:1) will affect the Workbook in another
window (FilemakerData.xls:2). This is most useful for viewing two sheets
of the same workbook at the same time.Arrange Lets you arrange all of your open windows on the screen in the following layouts: Tiled, Horizontal, Vertical and Cascade (one on top of the other). Checking the box labeled Windows of active workbook will make it so windows of other workbooks are unarranged. Hide Makes your window disappear from sight completely. Unhide... Lists the hidden window and allows you to select which ones to show. Split Breaks the active window into four panes which can be scrolled up and down or left and right independently, allowing you to see the beginning of a large Worksheet in the left pane and the end in the right pane, for example. You can get rid of the pane dividers by double-clicking on them or by selecting Remove Split from the Window menu. Freeze Panes This is very useful for locking the heading row of a long list of data onto the top of the screen so that when you scroll down it will remain visible. First move a horizontal split below the column heading row or to the right of a row heading column, then Freeze Panes. Open Windows List Allows you to bring any open, non-hidden window to the foreground so that you can work on it. |
Microsoft Excel
Help Launches the sometimes-annoying Office Assistant where you can
type questions to find what you're looking for.Contents and Index An index of help topics, along with a nice search function. What's This? Lets you click on an area of the screen to find out what it does. Microsoft on the Web Online resources such as product updates and news, along with a web tutorial. Lotus 1-2-3 Help... Help for people accustomed to using Lotus 1-2-3. About Microsoft Excel Displays product version and licensing information. Also contains a link for information about your computer system and a link for tech support. |
|
| [Close Window] | |
©2001, Kevin Pedersen