MS Excel Worksheets Tips Tricks

-
Worksheets

Renaming sheets
Double-click the sheet tab and type a name of up to 32 characters.
Spaces, hyphens, and underscores are allowed in worksheet names.
Press Enter when finished.

Coloring sheet tabs
Excel 2002/2003 Only
Right-click the sheet tab and choose Tab Color from the shortcut menu.
Select a color.

Moving worksheets in a
workbook

Drag the sheet tab to a new location.
Copying a worksheet in a

workbook
Hold Ctrl and drag the sheet tab to a new location.

Moving and copying
between workbooks
Right-click the sheet tab and choose Move or Copy to open the dialog
box.

Navigating between sheets Right-click the navigation buttons and select the sheet you want to
move to OR

Press Ctrl+PgDn to move to the next sheet; Ctrl+PgUp to move to the
previous sheet; Ctrl+Tab to move to the next open workbook.

Popular posts from this blog

Auto Cad Tip Applications for Xrefs

-
Image
Applications for Xrefs There are many different uses for external references. I will describe two common applications to illustrate their range. Let’s suppose you are working on a project as an interior designer and a subcontractor to the lead architect. The architect can give you a drawing of a floor plan that is still undergoing changes. You load this file onto your hard disk, in a specially designated folder, and then Xref it into your drawing as a background— a drawing to be used as a reference to draw over. You can now proceed to lay out furniture, partitions, and so on, while the architect is still refining the floor plan. At an agreed-on time, the architect will give you a revised version of the floor plan. You will overwrite the one that you have on your computer with the latest version. You can then reload the Xref into your furniture layout drawing, and the newer version of the floor plan will now be the background. In this example, the lead architect might al...
Read more

MAIN DISTRIBUTION FRAME (MDF) CABINETS AND DP

-
MDF,CABINETS AND DP MAIN DISTRIBUTION FRAME (M.D.F). Frame in the exchange used for making cross connections between the incoming cables and exchange equipment. On the line side of the frame the cables terminate on protector strips. It is a connecting/testing point where incoming cable (from switch room) out-going cable to cabinet are terminated. It is of two types (i) Wall Type. (ii) Floor Type. Both sides cables are terminated systematically and join them with a wire i.e. called jumper wire. By this we can change or shift a number easily. DEFINITION OF CABINET: It is a small testing point where primary and secondary pairs are terminated. CABINET CAPACITY: Total number of primary and secondary pairs those terminated in a cabinet is called capacity of cabinet. CONSTRUCTION OF CABINET: It is an almirah made of iron and fiber. It is fixed on the stand made of bricks and cement. TYPES OF CABINETS: 1 50/100 poles mount cabinet 2 300/400 ...
Read more

Binding Xrefs in Auto Cad

-
Binding Xrefs On occasion, you will want to permanently attach an Xref to the host drawing. If you send your drawing files to a printing service to be plotted, including a set of Xref files can complicate things. Also, for archiving finished work, it’s better to reduce the number of files. There may also be occasions when the Xref has been revised for the last time and no longer needs to be a separate file. In all these situations, you will use the Bind command to convert an external reference into a block that will be stored permanently in the host drawing. Open the Xref Manager dialog box and highlight the Cabin12a Xref. Click the Bind button to open the Bind Xrefs dialog box. The two options in the Bind Type area have to do with how layers are treated when an Xref is bound to the host drawing. The default is Bind. It sets the Xref layers to be maintained as unique layers in the host drawing. With the Insert option, layers that have the same name in the two drawin...
Read more