14 August 2007

Excel Shortcuts

Beberapa shortcuts yang boleh digunakan dalam Microsoft Excel yang kebarangkalian untuk menjimatkan masa itu ada.
Sumber : Internet (gunakan pakcik google atau pak yahoo untuk cari)

CTRL+SHIFT + : Enters the time.
CTRL+SHIFT + & Creates an outline box around whatever you select.
CTRL+SHIFT+ _ Removes the outline box around whatever has an outline.
CTRL+SHIFT + * Highlights all the text surrounding the cell filled with data or numbers.
CTRL+SHIFT+ ! Applies the number format to selected cells.
CTRL+SHIFT+ % Applies the percentage format to the selected cells.
CTRL+SHIF+ # Applies the date format to the selected cells.
CTRL+SHIFT+ @ Applies the time format to the selected cells.
CTRL SHIFT +( Unhide columns that are selected.
CTRL SHIFT +) Unhide rows that are selected.

Cara terbaik untuk memahirkan diri ialah dengan cuba masukkan sesuatu nombor kedalam sel kemudian tekan CTRL +SHIFT + key1 – 10. Setiap kali penukaran penggunan CTRL+SHIFT+ key, nombor yang dimasukkan kedalam sel akan bertukar kepada simbol tertentu. (Trylah sendiri untuk memahirkan diri). Perkara susah akan menjadi mudah sekiranya ia selalu dipraktikkan.

Beberapa lagi penggunaan CTRL yang boleh menjimatkan masa tuan/puan dalam mengunakan Excel:

CTRL+; Enters the date.
CTRL+9 Hide Rows selected.
CTRL+0 Hide Columns selected.
CTRL+D Fills down current formula into all adjacent cells; this avoids copying first.
CTRL+K Insert a hyperlink.

1 komen:

It is also possible Abercrombie today to create your Abercrombie own custom polo shirts Abercrombie Sale wherein you can have your Cheap Abercrombie own logo embroidered Abercrombie outlet on the front of the shirt. abercrombie Jeans These custom polos are ideal for companies that are hosting an event of some kind. Abercrombie Pants They are also great to give away as promotional Abercrombie Tees items to company personnel for work well done. Clubs of all types take advantage of
Abercrombie Shorts custom polo shirts as do sports teams who wish to have all members Abercrombie Sweaters dressed the same when traveling together. Customized shirts are also great to use as staff clothing or uniforms for pubs, restaurants, hotels and a wide variety of other types of businesses.One of the most popular companies in business today that offers the custom polo shirts is LEADapparel. This online retailer offers custom embroidery services on orders of twelve or more shirts. The embroidery done is perfect and of the highest quality. Orders are processed quickly and shipped out within just a few days.


Twitter Delicious Facebook Digg Stumbleupon Favorites More