Excel 2007 shortcuts
Posted by dvanarsd on May 16, 2008
PC Magazine (June 2008) has a list of “11 Killer Excel 2007 Shortcuts”:
| Ctrl-Shift-& | Apply the outline border to the selected cells |
| Ctrl-Shift-# | Apply the Date format with day, month and year |
| Ctrl-Shift-@ | Apply the Time format: hour, minute, AM or PM |
| Ctrl-Shift-: | (colon) Enter current time |
| Ctrl-; | (semi-colon) Enter date |
| Ctrl-O | Hide selected columns |
| Ctrl-’ | (single quote) alternate: cell values/formulas |
| Ctrl-H | Find and replace |
| Ctrl-F2 | Print Preview |
| Ctrl-F6 | next workbook |
| Alt-F8 | macro dialog box |
ernesto Pena Correa said
I am in the need for an Excel VB macro that can identify the first character of column X and place a text value in column AC. Example is; first character B in column X, to place the word STUDENT in column AC same row, identify first character M y column X and place Master in column AC same row.
Please help, urgent!!
Response: sorry, I’m not enough of an Excel expert to help. I can only suggest doing a search for Excel macros. Remember to specify your version of Excel.