Archive for August, 2007

Useful Tips in Excel

Instant charts in Excel.
Select any of the cells in the table of numbers and press F11

Headers and Footers in Excel.
Click on the File menu and select Page Setup. Now select the Header/Footer tab. Try experimenting with the Custom Header and Custom Footer options as well.

Displaying the serial number behind Date format in Microsoft [...]

Power of CTRL key in Excel

The POWER of the CTRL key !!!!!!!!!!!!
Practicing the CTRL SHIFT shortcuts will save tons of time:
CTRL SHIFT : Enters the timeCTRL SHIFT & Creates an outline box around whatever you selectCTRL SHIFT _ Removes the outline box around whatever has an outlineCTRL SHIFT * Highlights all the text surrounding the cell filled with data [...]

Protecting cells, sheets, workbooks, and files

Protecting cells, sheets, workbooks, and files
Cell protection
Cell has two key properties:

locked

hidden.

A locked cell can’t be changed, and the contents of a hidden cell don’t appear in the formula bar when the cell is selected. By default, every cell is locked and not hidden. Locked and hidden attributes have no effect unless [...]

Resize Excel’s Sheet Tabs

Resize Excel’s sheet tabs
select Start > Settings > Control Panel and double-click Display. In the Display Properties dialog box, click the Appearance tab, and choose Scrollbar from the Item list. Adjust the sheet tabs until they’re the size you want. Be aware that this setting affects the scroll bars in all your applications.

Separate full names into different columns

Separating the full names in column A into first and last names in columns B and C.Solution:
To retrieve the first name use the LEFT and FIND functions as shown in the following formula:=LEFT(A1,FIND(” “,A1))

To retrieve the last name use the RIGHT, LEN, and FIND functions as shown in the following formula:=RIGHT(A1,LEN(A1)-FIND(” “,B1))

Update Charts Automatically

Update charts automatically when you enter new data
When you select a chart series, the ranges used by the series are outlined on the worksheet. You could simply drag a corner of the outline to extend the range.
This document describes another approach that uses formulas to define the ranges used in a chart. The [...]

Moving Between Precedent and Dependent Cells

Moving Between Precedent and Dependent Cells

Using keyboard shortcuts
To move to a precedent cell(s):
Select a cell containing a formula and press Ctrl+[.It can trace a precedent cell(s) in the active sheet, in another sheet in the workbook, or in a sheet in another open workbook, and it can open a closed workbook and select the precedent [...]