Tip of the Day# 8

Microsoft Office Excel 2007Image via Wikipedia
EXCEL KEYBOARD SHORTCUTS


Here are several keyboard shortcuts for you Excel power users.

These keystrokes change a cell’s format on the fly:
Read More>>


Ctrl-Shift-~ General (hold down the Control and Shift k eys while pressing the tilde key)

Ctr l-Shift-$ Currency with 2 decimal places

Ctrl-Shift-! Number with 2 decimal places and commas

Ctrl-Shift-% Percent with no decimal places

Ctrl-Shift-^ Exponential with 2 decimal places

Ctrl-Shift-# Date with day, month and year

Ctrl-Shift-@ Time with hour, minute and AM/PM indicator

Ctrl-Shift-& Apply the outline border

Ctrl-Shift-_ Remove outline borders

Ctrl-B Apply or remove bold (toggles)

Ctrl-I Apply or remove italics

Ctrl-U Apply or remove underline

C trl-5 Apply or remove strikethrough

Ctrl-; Insert current date into cell

Ctrl-: Insert current time into cell

Related articles by Zemanta
Enhanced by Zemanta

Comments

Post a Comment

Popular posts from this blog

Tip of the Day # 13

Image
How to disable delete confirmation dialog box in Windows 7 ? Its a very nice and easy tip to follow and also very useful.So,what are you waiting for just check it out! Read more>> The feature of Windows asking you if you really want to put the files in the Recycle Bin whenever you attempt to delete a file is to stop you from deleting a file by mistake or accident. The delete confirmation dialog box appears every time you give the command of deleting a file. However, there are times you are deleting many unnecessary files in order to clean up your hard drive. This delete confirmation dialog box will really bother you at such times and you would want to get rid of it as it takes up a lot of your time while you are deleting numerous files. There is an easy way to disable delete confirmation dialog box in Windows 7. As you disable delete confirmation dialog box in Windows 7, you will be able to save a lot of your time. However, it is recommended that you do not disable de...
Read more

Governor Generals of Pakistan

                Names                Durations Quaid e Azam Aug.15,1947 to Sep.11,1948 Khawaja Nazimuddin Sep.14,1948 to Oct.17,1951 Ghulam Muhammed Oct.19,1951 to Oct.5,1955 Maj. Gen. Iskander Mirza Oct.6,1955 to Mar.22,1956
Read more