Talagang Temperature
Advertisment

Log in

I forgot my password

Who is online?
In total there are 9 users online :: 0 Registered, 0 Hidden and 9 Guests :: 2 Bots

None

[ View the whole list ]


Most users ever online was 145 on Wed Mar 02, 2011 2:26 am

Microsoft Excel Shortcut keys

View previous topic View next topic Go down

Microsoft Excel Shortcut keys

Post by Shehla Ali on Thu Jan 07, 2010 5:01 am

Microsoft Excel Shortcut keys
Auto sum shortcut key : Quickly create a Microsoft Excel formula to get the sum of all cells by highlighting the cells you wish to know the value of and pressing ALT and = .

Create hyper links in Excel : Quickly create hyper links in your Microsoft Word, Excel, or Front Page document by highlighting text and pressing “CTRL + K”.
Close all open files at once : Close all open Microsoft Word and/or Excel files by holding down the shift key and clicking “File” and then “Close All”.

Quickly open recently opened files : Quickly open the recent files by first pressing “ALT + F” to open the file Menu and press 1, 2, 3, or 4.

Create underlines without any text : This tip works with the majority of Microsoft Office applications. Easily create an underlined space by pressing CTRL + U to start the underline, then press SHIFT + Space for each underlined space you wish to create. An example of how this could be used is for printable forms, for example: Name: .

Print only sections of a document : Save on your printer ink by selectively printing in Windows programs such as Microsoft Word, Internet Explorer, WordPad, Outlook, etc. To do this highlight portions of text you wish to print and click print. In the printer dialog window under Page Range choose the option Selection. It is important to realize that not all programs or printer drivers support this feature.

Repeat recent action : Using the F4 key in Microsoft Office 2000 and above allows the user to repeat the last used action. For example, if you have changed the font of a selected text and wish to change another portion of text to the same font, pressing F4 will do this for you automatically.

Quickly undo : Quickly undo mistakes in the majority of most PC Windows program by pressing CTRL + Z.

Quickly above cell contents : In Microsoft Excel press CTRL + SHIFT + ” to copy the above cells contents.

Using the Microsoft Excel Auto filter : Organize cells quickly by using Microsoft Auto filter. Columns that contains long listing of data can be easily sorted by using the Auto filter option, to use this option select the top rows of the columns you want to be used and select Data / Filter and Auto Filter. Once successfully completed you can use drop down arrows to filter the data automatically.

_________________

Shehla Ali
Administrator
Administrator

Female Number of posts: 7666
Location: United Kingdom, Manchester
Job/hobbies: Reading Poetry, Writing,Music
Reputation: 55
Points: 13025
Registration date: 2009-01-14

View user profile

Back to top Go down

Re: Microsoft Excel Shortcut keys

Post by Shaheen on Sat Jan 09, 2010 3:21 pm

very niceeeeeeeeee information shehla. Smile

_________________



Shaheen
Super Moderator
Super Moderator

Female Number of posts: 11702
Location: United Kingdom
Job/hobbies: Music, Poetry,reading books.
Reputation: 88
Points: 20896
Registration date: 2009-02-13

View user profile

Back to top Go down

View previous topic View next topic Back to top


Permissions in this forum:
You cannot reply to topics in this forum