|
|
| Register | Invite Your Friends | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
![]() |
![]() |
![]() |
|
|
#1 (permalink) |
|
Senior Member
Join Date: Jan 2009
Posts: 122
|
=> 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 ] |
|
|
|
![]() |
| Tags |
| excel, killer, shortcuts |
| Thread Tools | |
|
|