Free latest PlacementPapers, Interview Questions ....  
Invite Your Friends

Go Back   Free latest PlacementPapers, Interview Questions .... > TUTORIALS > Microsoft Technologies


  



Reply

 

LinkBack Thread Tools
Old 18-02-09, 08:52 PM   #1 (permalink)
Senior Member
 
Join Date: Jan 2009
Posts: 122
Post 13 Killer Excel Shortcuts




=> Apply the outline border to the selected cells. [ Ctrl-Shift-& ]
=> Apply the Date format with the day, month, and year.[ Ctrl-Shift-# ]
=> Apply the Time format with the hour and minute, and AM or PM. [ Ctrl-Shift-@ ]
=> Enter the current time. [ Ctrl-Shift-: ]
=> Enter the current date. [ Ctrl-; ]
=> Hide the selected rows. [ Ctrl-9 ]
=> Hide the selected columns. [ Ctrl-0 ]
=> Alternate between displaying cell values and displaying formulas in the worksheet. [ Ctrl-` ]
=> Display the Find and Replace dialog box, with the Replace tab selected. [ Ctrl-H ]
=> Display the Insert Hyperlink dialog box for new hyperlink. [ Ctrl-K ]
=> Display the Print Preview window. [ Ctrl-F2 ]
=> Switch to the next workbook window. [ Ctrl-F6 ]
=> Display the Macro dialog box to create, run, edit, or delete a macro. [ Alt-F8 ]
munni is offline   Reply With Quote
Reply

Tags
excel, killer, shortcuts

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Jump


All times are GMT +6.5. The time now is 05:52 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0
Please Do Not post, copyrighted/internal contents.We are not responsible for any kind of copyrighted material.
If you have objection to any content, please let us know to remove it ASAP.
admin@placementpapers.us