|
Trying to do your work more efficiently? Of
course you are. Why make your work harder than it has to be. Microsoft Excel is
one of the most useful applications in the Microsoft arsenal. In fact, in
Microsoft Excel, you can accomplish pretty much all of your office work. On this page EMAGENIT is providing Free
Microsoft Excel tips for anyone to access. Enjoy and we hope it helps you out.
Undo a Mistake:
Just press Ctl+z. No need to move your mouse and go to the Excel
menu!
Move a worksheet:
The easiest way to move a
sheet around in a workbook is to click and hold on a sheet tab then drag the
selected tab to the new tab position in the workbook. To make a copy of the
sheet, hold down the Ctrl key while moving it. Release the mouse button
before the Ctrl key to complete the process. The worksheet is now moved.
How to Rename a Worksheet:
Renaming worksheets becomes important for organizational purposes. To change the
default name of any sheet in a workbook, double click on the sheet
tab then retype the sheet name. Press the Enter key to complete the
process or the Esc key to dump the change. The maximum number of characters is
32.
How to Clear the Contents of a Cell:
The Clear command can be used to
isolate certain parts of a cell or range to be cleared. To use the Clear
command, select the desired cell or range of cells, proceed to the worksheet
menu bar and select Edit / Clear. The Clear sub menu will have 4 choices:
All: Clears a cell’s formats and contents. Contents: Clears a cell’s
contents but leaves the cell’s format (color, font...etc.). Formats:
Clears a cell’s formats, but leaves its contents. Comments: Clears a
cell’s comment but leaves its format and contents untouched. Click on one of
these 4 choices.
What is a Range?
A range is defined as a continuous area of
adjacent cells on the worksheet. In other words, if you highlight cells A1-A5,
that is a range. A range can also include several columns as in: A1-B5.
Back
to Resource Center
|
